From a 500-row sample across 8 columns.
monthlast_namefirst_name+5monthlast_namefirst_name+5county| first_name | last_name | soundex | county | number | year | month | day |
|---|---|---|---|---|---|---|---|
| Harry | Adock | A320 | KINGS | 40 | 1866 | MAY | 24 |
| Ellen D | Graves | A320 | KINGS | 40 | 1866 | MAY | 24 |
| William H | Abbott | A130 |
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 | 0% | MaryJohnAnna |
last_name | text | Last name on the certificate | 0% | SmithCohenMiller |
soundex | text | A phonetic algorithm for indexing names by sound | 0% | S530C500R200 |
county | categorical | Borough in which the certificate was issued. | 0% | MANHATTANKINGSBRONXof 5 |
GET /api/datasets/j62e-7maa GET /api/datasets/j62e-7maa/quality GET /api/datasets/j62e-7maa/related GET /api/columns?dataset=j62e-7maa
month| KINGS |
| 2720 |
| 1898 |
| JUN |
| 8 |
| Binie | Shumway | A130 | KINGS | 2720 | 1898 | JUN | 8 |
| Henry | Abel | A140 | KINGS | 3814 | 1890 | SEP | 29 |
| Henriette | Bohn | A140 | KINGS | 3814 | 1890 | SEP | 29 |
| William | Abel | A140 | KINGS | 948 | 1900 | FEB | 14 |
| George W | Adams | A352 | KINGS | 937 | 1870 | JUN | 1 |
| John | Ahrens | A652 | KINGS | 66 | 1866 | JUN | 3 |
| Elisabetta Cath. | Doscher | A652 | KINGS | 66 | 1866 | JUN | 3 |
number| text |
| Certificate number on the document |
| 0% |
284125414 |
year | text | Year of Birth on the certificate | 0% | 193619261929 |
month | text | Month of Birth on the certificate | 0% | JUNOCTNOV |
day | text | Day of Birth on the certificate | 0% | 25281 |