The spreadsheets lacked a primary or unique key or auto-incrementing field.The spreadsheets' cells and columns were in text format even in cases where it was inappropriate, such as the column for license sequence (license ID numbers) which were a series of integers.Each spreadsheet file had multiple sheets of data within it, and each sheet had a maximum of 65,000 entries on it. XLS (Microsoft Excel spreadsheet) files, one file per borough except for Manhattan which was broken up into two files. Rather than providing a raw database dump in CSV format, the New York City Clerk's Office originally provided the files on a USB drive in six.** This data was released to the public through a successful Freedom of Information request and lawsuit filed by Reclaim The Records, settled with the New York City Clerk's Office in mid-2016. ON MICROFILM at the NYC Municipal Archives (only through 1949) MAIL ORDER at the NYC Municipal Archives (only through 1949) ONSITE ACCESS at the City Clerk's Office (after 1949) MAIL ORDER through the City Clerk's Office (after 1949) ONLINE at this website! DOWNLOADABLE at the Internet Archive in XLS, CSV, and SQL formats (The two columns of data containing the spouses' dates of birth were redacted for privacy.) SEARCHABLE at SEARCHABLE at the German Genealogy Group SEARCHABLE at FamilySearch SEARCHABLE at Steve Morse's website SEARCHABLE at ONLINE at the Internet Archive, for 1930-1972** (images do not exist after 1972) ON MICROFILM at the NYC Municipal Archives through 1949 Newer files are still stored there, but some older files have been moved to the New York City Municipal Archives. This is a three-page (occasionally four-page) document set originally issued by the New York City Clerk's Office.
0 Comments
Leave a Reply. |