From a 500-row sample across 8 columns.
numberfirst_namemonth+5numberfirst_namemonth+5county| first_name | last_name | soundex | county | number | year | month | day |
|---|---|---|---|---|---|---|---|
| Emma | Reillie | R400 | MANHATTAN | 443692 | 1885 | NOV | 25 |
| Seocvina | Aaps | A120 | KINGS | 4364 | 1881 | JUN | 17 |
| Levi | Aaron | A650 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
first_name | text | First name and middle name/initial on the certificate | 20% | MaleMaryJohn |
last_name | text | Last name on the certificate | 17% | SmithCohenMiller |
soundex | text | A phonetic algorithm for indexing names by sound | 17% | S530M600C500 |
county | categorical | Borough in which the certificate was issued. | 0% | MANHATTANKINGSBRONXof 5 |
GET /api/datasets/5gq7-rgmv GET /api/datasets/5gq7-rgmv/quality GET /api/datasets/5gq7-rgmv/related GET /api/columns?dataset=5gq7-rgmv
month| KINGS |
| 9 |
| 1883 |
| JAN |
| 8 |
| George C | Aass | A200 | KINGS | 10791 | 1884 | DEC | 12 |
| — | Abarrbach | A161 | KINGS | 8783 | 1882 | NOV | 30 |
| Joseph | Abbazzo | A120 | KINGS | 4907 | 1884 | JUN | 24 |
| Walter | Abbe | A100 | KINGS | 10797 | 1884 | DEC | 16 |
| Charles | Abbitz | A132 | KINGS | 10777 | 1884 | DEC | 1 |
| — | Abbott | A130 | KINGS | 6157 | 1881 | AUG | 18 |
| — | Abbott | A130 | KINGS | 9024 | 1881 | NOV | 22 |
number| text |
| Certificate number on the document |
| 0% |
1228683 |
year | text | Year of Birth on the certificate | 0% | 190819091907 |
month | categorical | Month of Birth on the certificate | 17% | OCTJULJANof 15 |
day | text | Day of Birth on the certificate | 17% | 11020 |