From a 500-row sample across 20 columns.
categoryboroughboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| unit | group_name | date | program_month | borough | location_type | location_name | programtime | program_name | program_type | category | duration_of_program |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Urban Park Rangers | General Public | 2021-11-29T00:00:00.000 | November | Brooklyn | Park | Prospect Park | Evening | Sunset Hike | Pop-Up Adventure | Hiking | 1 |
| Urban Park Rangers |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unit | text | Name of unit that performed the Education & Wildlife program | 0% | Urban Park Rangersof 1 |
group_name | text | Name of group who requested the Education & Wildlife program | 1% | General PublicGeneral publicgeneral public |
date | datetime | The date on which the Education & Wildlife program was held | 0% | 2020-01-11T00:00:00.0002024-06-13T00:00:00.0002022-05-25T00:00:00.000 |
program_month | categorical | The month in which the program was held | 0% | May |
GET /api/datasets/rcd4-qkns GET /api/datasets/rcd4-qkns/quality GET /api/datasets/rcd4-qkns/related GET /api/columns?dataset=rcd4-qkns
borough| General Public |
| 2021-11-29T00:00:00.000 |
| November |
| Bronx |
| Park |
| Crotona Park |
| Day |
| Keep Waterfowl Wild |
| Pop-Up Adventure |
| Wildlife Viewing |
| 0.25 |
| Urban Park Rangers | General Public | 2021-11-28T00:00:00.000 | November | Queens | Park | Flushing Meadows Corona Park | Day | Historic New York: The 1964 World's Fair | Weekend Adventures | History | 2 |
| Urban Park Rangers | General Public | 2021-11-29T00:00:00.000 | November | Brooklyn | Park | Fort Greene Park | Day | Meet Big Sam the Corn Snake | Pop-Up Adventure | Kids & Family | 0.5 |
| Urban Park Rangers | General Public | 2021-11-29T00:00:00.000 | November | Brooklyn | Park | Brooklyn Bridge Park | Day | Hawk Talk | Pop-Up Adventure | Wildlife Viewing | 0.5 |
| Urban Park Rangers | General Public | 2021-11-29T00:00:00.000 | November | Brooklyn | Park | Prospect Park | Day | Winter Water Fowl! (with a little swan talk) | Pop-Up Adventure | Wildlife Viewing | 0.5 |
| Urban Park Rangers | PS 321 | 2021-11-24T00:00:00.000 | November | Brooklyn | Park | Prospect Park | Day | Native American | Natural Classroom | History Highlights | 1 |
| Urban Park Rangers | General Public | 2021-11-28T00:00:00.000 | November | Staten Island | Park | Silver Lake Park | Day | Duck Frenzy | Pop-Up Adventure | Wildlife Viewing | 0.25 |
| Urban Park Rangers | General Public | 2021-11-28T00:00:00.000 | November | Staten Island | Park | Clove Lakes Park | Day | Bird Brains | Pop-Up Adventure | Kids & Family | 0.25 |
| Urban Park Rangers | General Public | 2021-11-28T00:00:00.000 | November | Staten Island | Nature Center | Blue Heron Nature Center | Day | Hawks and Songbirds | Pop-Up Adventure | Wildlife Viewing | 0.5 |
Showing 12 of 19 columns. All of them are listed below.
OctoberJulyborough | categorical | Borough where Education & Wildlife program was held | 0% | BronxQueensBrooklynof 5 |
location_type | text | Type of location where the Education & Wildlife program was held | 0% | ParkNature CenterSchool |
location_name | text | Name of location where Education & Wildlife program was held | 0% | Central ParkVan Cortlandt ParkFort Greene Park |
programtime | categorical | Time of day when the Education & Wildlife program was held | 3% | DayEveningDay;#Eveningof 5 |
program_name | text | Name of the Education & Wildlife program | 0% | Urban WildlifeEcosystem HighlightsAdventure Course |
program_type | categorical | Type of Education & Wildlife program being held | 0% | Pop-Up AdventureNatural ClassroomWeekend Adventuresof 10 |
category | text | Described the Education & Wildlife program type | 0% | Wildlife ViewingKids & FamilyNature Exploration |
classification | text | Described further the Education & Wildlife program based on the category | 61% | WildlifeVirtual ProgramWho Lives here |
duration_of_program | float | Length of the Education & Wildlife program held | 0% | 0.51.51 |
audience | text | Population group who participated in the Education & Wildlife program | 2% | General PublicSchoolOutside Group |
student_youth_att | integer | Total number of students or youth attendees to the Education & Wildlife program | 0% | 235 |
optional_supply_categories | text | A list of supplies used for the Education & Wildlife program | 13% | Biofacts/ArtifactsDiscovered ObjectsBinoculars/Scopes |
activity | text | A list of specific activities conducted during the Education & Wildlife program | 95% | ["Nature Exploration"]HikingNature Exploration |
length_of_activity_1 | text | The amount of time (in hours) spent on first activity | 98% | 11.50.5 |
length_of_activity_2 | categorical | The amount of time (in hours) spent on second activity | 100% | 1.510.5of 9 |
total_participant_hours | float | A calculated field of number of participants multiplied by the values in the Length of Activity 1 and Length of Activity 2 columns. | 0% | 0122 |