From a 500-row sample across 43 columns.
lotblocklongitudelatitudelot+1boroughlongitudelatitudeboroughzip_codelongitude+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| title | alternate_title | primary_artist_last | primary_artist_first | primary_artist_middle | secondary_artist_last | secondary_artist_first | secondary_artist_middle | artists_keyword | primary_architect_last | primary_architect_first | primary_architect_middle |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Column of Jerash | Whispering Column of Jerash | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
title | text | — | 0% | Christopher ColumbusAbraham LincolnSundial |
alternate_title | text | — | 0% | NULLBrooklyn RemembersQuilt |
primary_artist_last | text | — | 0% | NULLRothWard |
primary_artist_first | text | — | 0% | NULLFrederickJohn |
primary_artist_middle | text |
GET /api/datasets/2pg3-gcaa GET /api/datasets/2pg3-gcaa/quality GET /api/datasets/2pg3-gcaa/related GET /api/columns?dataset=2pg3-gcaa
boroughlongitudelatitude+2longitudelatitudelot+1| Amiable Child Memorial | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Fort George Memorial Tablet | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Firemen's Memorial | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Madison Square Fountain | Southern Fountain | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Eagles and Prey | NULL | Fratin | Christophe | NULL | NULL | NULL | NULL | French | NULL | NULL | NULL |
| George Washington | NULL | Brown | Henry | Kirke | Ward | John Quincy | Adams | American | Upjohn | NULL | Richard |
| General William Jenkins Worth | NULL | Batterson | James | Goodwin | NULL | NULL | NULL | American | NULL | NULL | NULL |
| Johann Christoph Friedrich Von Schiller | NULL | Richter | C.L. | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Flushing Park Memorial | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
Showing 12 of 43 columns. All of them are listed below.
| — |
| 0% |
NULLGeorge RichardWilliam |
secondary_artist_last | text | — | 0% | NULLKraitzJaegers |
secondary_artist_first | text | — | 0% | NULLUllaWilliam |
secondary_artist_middle | categorical | — | 0% | NULLRudolphGeorge Richardof 6 |
artists_keyword | text | — | 0% | NULLAmericanWoman, American |
primary_architect_last | text | — | 0% | NULLEmbury IIWhite |
primary_architect_first | text | — | 0% | NULLAymarStanford |
primary_architect_middle | text | — | 0% | NULLE.Morris |
secondary_architect_last | categorical | — | 0% | NULLEmburyDeacyof 12 |
secondary_architect_first | categorical | — | 0% | NULLDonnWillof 12 |
secondary_architect_middle | categorical | — | 0% | NULLD.Henryof 6 |
landscape_architect_last | categorical | — | 0% | NULLBosworthAdamsof 11 |
landscape_architect_first | categorical | — | 0% | NULLGilmoreQuennellof 10 |
landscape_architect_middle | categorical | — | 0% | NULLD.Wellesof 6 |
architecture_firm | text | — | 0% | NULLGeneral Bronze Corporati…Department of Parks and … |
foundry | text | — | 0% | NULLModern Art FoundryRoman Bronze Works |
fabricator | text | — | 0% | NULLGeneral Bronze Corporati…A. Ottavino Corp. |
date_created | text | — | 0% | 193519361926 |
date_created_approximation | categorical | — | 0% | NYNULLof 3 |
date_dedicated | text | — | 0% | 193519361921 |
date_dedicated_approximation | categorical | — | 0% | NNULLYof 3 |
artwork_type1 | text | — | 0% | StatuePlaqueSculpture |
artwork_type2 | categorical | — | 0% | Monument/MemorialArtworkMarkerof 6 |
material | text | — | 0% | Bronze, graniteBronzeGranite |
location_name | text | — | 0% | Central ParkRiverside ParkCentral Park Zoo |
address | text | — | 0% | Central Park Zoo173rd Street and Fulton …The Mall |
city | text | — | 0% | New YorkBrooklynBronx |
state | text | — | 0% | NYof 1 |
zip_code | integer | — | 0% | 100191000410301 |
borough | categorical | — | 0% | ManhattanBrooklynQueensof 5 |
subject_keyword | text | — | 0% | World War I, WarAbstractAnimals, WPA |
inscription | text | — | 0% | NULLSigned: F.G.R. ROTHIN REMEMBERANCE OF / THE… |
managing_city_agency | text | — | 0% | Department of Parks and …Department of Citywide A…Department of Transporta… |
acquisition | text | — | 0% | Commissioned through Dep…NULLPurchased with Works Pro… |
pdc_records | text | — | 0% | NULL1859177 |
latitude | coordinate | — | 0% | 40.83994240.6302140.900093 |
longitude | coordinate | — | 0% | -73.898056-74.087535-73.958162 |
block | text | — | 0% | NULL11111117 |
lot | text | — | 0% | 1NULL2 |