species_counts
2,395 rows
This data as json, CSV (advanced)
place 7 ✖
- Pillar Point 500
- James Fitzgerald Marine Reserve 485
- Laguna Point 425
- China beach 325
- Redondo beach 275
- Fiscalini Ranch 231
- Shark Fin Cove 154
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [species_counts] ( [place] TEXT REFERENCES [places]([slug]), [taxon] INTEGER REFERENCES [taxons]([id]), [count] INTEGER, PRIMARY KEY ([place], [taxon]) );