ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Ocean" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1802 | 1802 | 2020-03-13 | Ocean | New Jersey | 34029 | 1 | 0 |
2149 | 2149 | 2020-03-14 | Ocean | New Jersey | 34029 | 1 | 0 |
2557 | 2557 | 2020-03-15 | Ocean | New Jersey | 34029 | 2 | 0 |
3014 | 3014 | 2020-03-16 | Ocean | New Jersey | 34029 | 3 | 0 |
3527 | 3527 | 2020-03-17 | Ocean | New Jersey | 34029 | 4 | 0 |
4123 | 4123 | 2020-03-18 | Ocean | New Jersey | 34029 | 16 | 0 |
4850 | 4850 | 2020-03-19 | Ocean | New Jersey | 34029 | 33 | 0 |
5694 | 5694 | 2020-03-20 | Ocean | New Jersey | 34029 | 49 | 0 |
6687 | 6687 | 2020-03-21 | Ocean | New Jersey | 34029 | 62 | 0 |
7778 | 7778 | 2020-03-22 | Ocean | New Jersey | 34029 | 102 | 0 |
8974 | 8974 | 2020-03-23 | Ocean | New Jersey | 34029 | 144 | 0 |
10278 | 10278 | 2020-03-24 | Ocean | New Jersey | 34029 | 180 | 1 |
11710 | 11710 | 2020-03-25 | Ocean | New Jersey | 34029 | 222 | 5 |
13313 | 13313 | 2020-03-26 | Ocean | New Jersey | 34029 | 389 | 5 |
15045 | 15045 | 2020-03-27 | Ocean | New Jersey | 34029 | 484 | 8 |
16874 | 16874 | 2020-03-28 | Ocean | New Jersey | 34029 | 624 | 9 |
18798 | 18798 | 2020-03-29 | Ocean | New Jersey | 34029 | 759 | 9 |
20836 | 20836 | 2020-03-30 | Ocean | New Jersey | 34029 | 874 | 12 |
22959 | 22959 | 2020-03-31 | Ocean | New Jersey | 34029 | 1022 | 18 |
25150 | 25150 | 2020-04-01 | Ocean | New Jersey | 34029 | 1209 | 23 |
27410 | 27410 | 2020-04-02 | Ocean | New Jersey | 34029 | 1371 | 38 |
29733 | 29733 | 2020-04-03 | Ocean | New Jersey | 34029 | 1685 | 45 |
32118 | 32118 | 2020-04-04 | Ocean | New Jersey | 34029 | 2003 | 56 |
34549 | 34549 | 2020-04-05 | Ocean | New Jersey | 34029 | 2177 | 62 |
37019 | 37019 | 2020-04-06 | Ocean | New Jersey | 34029 | 2374 | 71 |
39534 | 39534 | 2020-04-07 | Ocean | New Jersey | 34029 | 2641 | 85 |
42091 | 42091 | 2020-04-08 | Ocean | New Jersey | 34029 | 2856 | 101 |
44673 | 44673 | 2020-04-09 | Ocean | New Jersey | 34029 | 3093 | 119 |
47285 | 47285 | 2020-04-10 | Ocean | New Jersey | 34029 | 3269 | 121 |
49939 | 49939 | 2020-04-11 | Ocean | New Jersey | 34029 | 3403 | 132 |
52612 | 52612 | 2020-04-12 | Ocean | New Jersey | 34029 | 3554 | 138 |
55295 | 55295 | 2020-04-13 | Ocean | New Jersey | 34029 | 3593 | 141 |
57995 | 57995 | 2020-04-14 | Ocean | New Jersey | 34029 | 3833 | 149 |
60709 | 60709 | 2020-04-15 | Ocean | New Jersey | 34029 | 4016 | 166 |
63435 | 63435 | 2020-04-16 | Ocean | New Jersey | 34029 | 4272 | 185 |
66177 | 66177 | 2020-04-17 | Ocean | New Jersey | 34029 | 4424 | 201 |
68933 | 68933 | 2020-04-18 | Ocean | New Jersey | 34029 | 4548 | 212 |
71700 | 71700 | 2020-04-19 | Ocean | New Jersey | 34029 | 4648 | 217 |
74475 | 74475 | 2020-04-20 | Ocean | New Jersey | 34029 | 4868 | 222 |
77256 | 77256 | 2020-04-21 | Ocean | New Jersey | 34029 | 5036 | 253 |
80045 | 80045 | 2020-04-22 | Ocean | New Jersey | 34029 | 5234 | 270 |
82843 | 82843 | 2020-04-23 | Ocean | New Jersey | 34029 | 5444 | 286 |
85647 | 85647 | 2020-04-24 | Ocean | New Jersey | 34029 | 5612 | 301 |
88458 | 88458 | 2020-04-25 | Ocean | New Jersey | 34029 | 5811 | 317 |
91273 | 91273 | 2020-04-26 | Ocean | New Jersey | 34029 | 5962 | 322 |
94097 | 94097 | 2020-04-27 | Ocean | New Jersey | 34029 | 6024 | 330 |
96933 | 96933 | 2020-04-28 | Ocean | New Jersey | 34029 | 6151 | 342 |
99780 | 99780 | 2020-04-29 | Ocean | New Jersey | 34029 | 6253 | 367 |
102633 | 102633 | 2020-04-30 | Ocean | New Jersey | 34029 | 6375 | 397 |
105495 | 105495 | 2020-05-01 | Ocean | New Jersey | 34029 | 6505 | 420 |
108361 | 108361 | 2020-05-02 | Ocean | New Jersey | 34029 | 6692 | 426 |
111234 | 111234 | 2020-05-03 | Ocean | New Jersey | 34029 | 6871 | 440 |
114115 | 114115 | 2020-05-04 | Ocean | New Jersey | 34029 | 6974 | 447 |
116996 | 116996 | 2020-05-05 | Ocean | New Jersey | 34029 | 7060 | 469 |
119957 | 119957 | 2020-05-06 | Ocean | New Jersey | 34029 | 7125 | 483 |
122932 | 122932 | 2020-05-07 | Ocean | New Jersey | 34029 | 7209 | 500 |
125915 | 125915 | 2020-05-08 | Ocean | New Jersey | 34029 | 7277 | 516 |
128904 | 128904 | 2020-05-09 | Ocean | New Jersey | 34029 | 7366 | 522 |
131893 | 131893 | 2020-05-10 | Ocean | New Jersey | 34029 | 7462 | 540 |
134884 | 134884 | 2020-05-11 | Ocean | New Jersey | 34029 | 7569 | 547 |
137874 | 137874 | 2020-05-12 | Ocean | New Jersey | 34029 | 7633 | 562 |
140870 | 140870 | 2020-05-13 | Ocean | New Jersey | 34029 | 7688 | 571 |
143865 | 143865 | 2020-05-14 | Ocean | New Jersey | 34029 | 7742 | 595 |
146866 | 146866 | 2020-05-15 | Ocean | New Jersey | 34029 | 7829 | 610 |
149873 | 149873 | 2020-05-16 | Ocean | New Jersey | 34029 | 7878 | 617 |
152883 | 152883 | 2020-05-17 | Ocean | New Jersey | 34029 | 7913 | 626 |
155899 | 155899 | 2020-05-18 | Ocean | New Jersey | 34029 | 7994 | 633 |
158917 | 158917 | 2020-05-19 | Ocean | New Jersey | 34029 | 8067 | 643 |
161943 | 161943 | 2020-05-20 | Ocean | New Jersey | 34029 | 8165 | 656 |
164972 | 164972 | 2020-05-21 | Ocean | New Jersey | 34029 | 8214 | 661 |
168008 | 168008 | 2020-05-22 | Ocean | New Jersey | 34029 | 8285 | 678 |
171047 | 171047 | 2020-05-23 | Ocean | New Jersey | 34029 | 8316 | 686 |
174089 | 174089 | 2020-05-24 | Ocean | New Jersey | 34029 | 8372 | 686 |
177132 | 177132 | 2020-05-25 | Ocean | New Jersey | 34029 | 8430 | 690 |
180176 | 180176 | 2020-05-26 | Ocean | New Jersey | 34029 | 8462 | 692 |
183224 | 183224 | 2020-05-27 | Ocean | New Jersey | 34029 | 8514 | 704 |
186281 | 186281 | 2020-05-28 | Ocean | New Jersey | 34029 | 8577 | 711 |
189341 | 189341 | 2020-05-29 | Ocean | New Jersey | 34029 | 8627 | 721 |
192405 | 192405 | 2020-05-30 | Ocean | New Jersey | 34029 | 8700 | 726 |
195475 | 195475 | 2020-05-31 | Ocean | New Jersey | 34029 | 8748 | 739 |
198548 | 198548 | 2020-06-01 | Ocean | New Jersey | 34029 | 8770 | 740 |
201622 | 201622 | 2020-06-02 | Ocean | New Jersey | 34029 | 8817 | 743 |
204699 | 204699 | 2020-06-03 | Ocean | New Jersey | 34029 | 8853 | 755 |
207780 | 207780 | 2020-06-04 | Ocean | New Jersey | 34029 | 8900 | 763 |
210862 | 210862 | 2020-06-05 | Ocean | New Jersey | 34029 | 8954 | 765 |
213946 | 213946 | 2020-06-06 | Ocean | New Jersey | 34029 | 8979 | 767 |
217035 | 217035 | 2020-06-07 | Ocean | New Jersey | 34029 | 9022 | 774 |
220127 | 220127 | 2020-06-08 | Ocean | New Jersey | 34029 | 9041 | 781 |
223222 | 223222 | 2020-06-09 | Ocean | New Jersey | 34029 | 9059 | 787 |
226322 | 226322 | 2020-06-10 | Ocean | New Jersey | 34029 | 9100 | 792 |
229426 | 229426 | 2020-06-11 | Ocean | New Jersey | 34029 | 9166 | 803 |
232531 | 232531 | 2020-06-12 | Ocean | New Jersey | 34029 | 9200 | 807 |
235636 | 235636 | 2020-06-13 | Ocean | New Jersey | 34029 | 9222 | 813 |
238743 | 238743 | 2020-06-14 | Ocean | New Jersey | 34029 | 9244 | 817 |
241853 | 241853 | 2020-06-15 | Ocean | New Jersey | 34029 | 9258 | 820 |
244965 | 244965 | 2020-06-16 | Ocean | New Jersey | 34029 | 9279 | 826 |
248078 | 248078 | 2020-06-17 | Ocean | New Jersey | 34029 | 9306 | 828 |
251193 | 251193 | 2020-06-18 | Ocean | New Jersey | 34029 | 9351 | 835 |
254308 | 254308 | 2020-06-19 | Ocean | New Jersey | 34029 | 9382 | 842 |
257431 | 257431 | 2020-06-20 | Ocean | New Jersey | 34029 | 9413 | 845 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);