ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 34009 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4841 | 4841 | 2020-03-19 | Cape May | New Jersey | 34009 | 1 | 0 |
5684 | 5684 | 2020-03-20 | Cape May | New Jersey | 34009 | 1 | 0 |
6677 | 6677 | 2020-03-21 | Cape May | New Jersey | 34009 | 2 | 0 |
7768 | 7768 | 2020-03-22 | Cape May | New Jersey | 34009 | 2 | 0 |
8964 | 8964 | 2020-03-23 | Cape May | New Jersey | 34009 | 2 | 0 |
10268 | 10268 | 2020-03-24 | Cape May | New Jersey | 34009 | 3 | 0 |
11700 | 11700 | 2020-03-25 | Cape May | New Jersey | 34009 | 4 | 0 |
13303 | 13303 | 2020-03-26 | Cape May | New Jersey | 34009 | 6 | 0 |
15035 | 15035 | 2020-03-27 | Cape May | New Jersey | 34009 | 7 | 0 |
16864 | 16864 | 2020-03-28 | Cape May | New Jersey | 34009 | 7 | 0 |
18788 | 18788 | 2020-03-29 | Cape May | New Jersey | 34009 | 9 | 0 |
20826 | 20826 | 2020-03-30 | Cape May | New Jersey | 34009 | 15 | 0 |
22949 | 22949 | 2020-03-31 | Cape May | New Jersey | 34009 | 15 | 0 |
25140 | 25140 | 2020-04-01 | Cape May | New Jersey | 34009 | 22 | 0 |
27400 | 27400 | 2020-04-02 | Cape May | New Jersey | 34009 | 34 | 0 |
29723 | 29723 | 2020-04-03 | Cape May | New Jersey | 34009 | 44 | 0 |
32108 | 32108 | 2020-04-04 | Cape May | New Jersey | 34009 | 50 | 1 |
34539 | 34539 | 2020-04-05 | Cape May | New Jersey | 34009 | 77 | 2 |
37009 | 37009 | 2020-04-06 | Cape May | New Jersey | 34009 | 85 | 3 |
39524 | 39524 | 2020-04-07 | Cape May | New Jersey | 34009 | 94 | 3 |
42081 | 42081 | 2020-04-08 | Cape May | New Jersey | 34009 | 100 | 3 |
44663 | 44663 | 2020-04-09 | Cape May | New Jersey | 34009 | 109 | 3 |
47275 | 47275 | 2020-04-10 | Cape May | New Jersey | 34009 | 116 | 5 |
49929 | 49929 | 2020-04-11 | Cape May | New Jersey | 34009 | 129 | 5 |
52602 | 52602 | 2020-04-12 | Cape May | New Jersey | 34009 | 145 | 9 |
55285 | 55285 | 2020-04-13 | Cape May | New Jersey | 34009 | 164 | 9 |
57985 | 57985 | 2020-04-14 | Cape May | New Jersey | 34009 | 169 | 10 |
60699 | 60699 | 2020-04-15 | Cape May | New Jersey | 34009 | 178 | 10 |
63425 | 63425 | 2020-04-16 | Cape May | New Jersey | 34009 | 186 | 10 |
66167 | 66167 | 2020-04-17 | Cape May | New Jersey | 34009 | 189 | 14 |
68923 | 68923 | 2020-04-18 | Cape May | New Jersey | 34009 | 199 | 14 |
71690 | 71690 | 2020-04-19 | Cape May | New Jersey | 34009 | 206 | 14 |
74465 | 74465 | 2020-04-20 | Cape May | New Jersey | 34009 | 212 | 15 |
77246 | 77246 | 2020-04-21 | Cape May | New Jersey | 34009 | 217 | 16 |
80035 | 80035 | 2020-04-22 | Cape May | New Jersey | 34009 | 227 | 16 |
82833 | 82833 | 2020-04-23 | Cape May | New Jersey | 34009 | 236 | 16 |
85637 | 85637 | 2020-04-24 | Cape May | New Jersey | 34009 | 247 | 16 |
88448 | 88448 | 2020-04-25 | Cape May | New Jersey | 34009 | 261 | 18 |
91263 | 91263 | 2020-04-26 | Cape May | New Jersey | 34009 | 281 | 18 |
94087 | 94087 | 2020-04-27 | Cape May | New Jersey | 34009 | 281 | 18 |
96923 | 96923 | 2020-04-28 | Cape May | New Jersey | 34009 | 299 | 20 |
99770 | 99770 | 2020-04-29 | Cape May | New Jersey | 34009 | 305 | 21 |
102623 | 102623 | 2020-04-30 | Cape May | New Jersey | 34009 | 323 | 22 |
105485 | 105485 | 2020-05-01 | Cape May | New Jersey | 34009 | 334 | 22 |
108351 | 108351 | 2020-05-02 | Cape May | New Jersey | 34009 | 337 | 23 |
111224 | 111224 | 2020-05-03 | Cape May | New Jersey | 34009 | 344 | 24 |
114105 | 114105 | 2020-05-04 | Cape May | New Jersey | 34009 | 355 | 24 |
116986 | 116986 | 2020-05-05 | Cape May | New Jersey | 34009 | 369 | 26 |
119947 | 119947 | 2020-05-06 | Cape May | New Jersey | 34009 | 378 | 28 |
122922 | 122922 | 2020-05-07 | Cape May | New Jersey | 34009 | 401 | 31 |
125905 | 125905 | 2020-05-08 | Cape May | New Jersey | 34009 | 424 | 31 |
128894 | 128894 | 2020-05-09 | Cape May | New Jersey | 34009 | 442 | 32 |
131883 | 131883 | 2020-05-10 | Cape May | New Jersey | 34009 | 458 | 32 |
134874 | 134874 | 2020-05-11 | Cape May | New Jersey | 34009 | 462 | 32 |
137864 | 137864 | 2020-05-12 | Cape May | New Jersey | 34009 | 471 | 35 |
140860 | 140860 | 2020-05-13 | Cape May | New Jersey | 34009 | 479 | 37 |
143855 | 143855 | 2020-05-14 | Cape May | New Jersey | 34009 | 483 | 39 |
146856 | 146856 | 2020-05-15 | Cape May | New Jersey | 34009 | 487 | 40 |
149863 | 149863 | 2020-05-16 | Cape May | New Jersey | 34009 | 500 | 41 |
152873 | 152873 | 2020-05-17 | Cape May | New Jersey | 34009 | 503 | 41 |
155889 | 155889 | 2020-05-18 | Cape May | New Jersey | 34009 | 506 | 41 |
158907 | 158907 | 2020-05-19 | Cape May | New Jersey | 34009 | 518 | 42 |
161933 | 161933 | 2020-05-20 | Cape May | New Jersey | 34009 | 531 | 42 |
164962 | 164962 | 2020-05-21 | Cape May | New Jersey | 34009 | 534 | 44 |
167998 | 167998 | 2020-05-22 | Cape May | New Jersey | 34009 | 545 | 46 |
171037 | 171037 | 2020-05-23 | Cape May | New Jersey | 34009 | 558 | 48 |
174079 | 174079 | 2020-05-24 | Cape May | New Jersey | 34009 | 561 | 48 |
177122 | 177122 | 2020-05-25 | Cape May | New Jersey | 34009 | 570 | 48 |
180166 | 180166 | 2020-05-26 | Cape May | New Jersey | 34009 | 571 | 48 |
183214 | 183214 | 2020-05-27 | Cape May | New Jersey | 34009 | 592 | 48 |
186271 | 186271 | 2020-05-28 | Cape May | New Jersey | 34009 | 602 | 48 |
189331 | 189331 | 2020-05-29 | Cape May | New Jersey | 34009 | 611 | 48 |
192395 | 192395 | 2020-05-30 | Cape May | New Jersey | 34009 | 615 | 49 |
195465 | 195465 | 2020-05-31 | Cape May | New Jersey | 34009 | 617 | 49 |
198538 | 198538 | 2020-06-01 | Cape May | New Jersey | 34009 | 623 | 49 |
201612 | 201612 | 2020-06-02 | Cape May | New Jersey | 34009 | 628 | 50 |
204689 | 204689 | 2020-06-03 | Cape May | New Jersey | 34009 | 629 | 50 |
207770 | 207770 | 2020-06-04 | Cape May | New Jersey | 34009 | 630 | 50 |
210852 | 210852 | 2020-06-05 | Cape May | New Jersey | 34009 | 637 | 50 |
213936 | 213936 | 2020-06-06 | Cape May | New Jersey | 34009 | 643 | 50 |
217025 | 217025 | 2020-06-07 | Cape May | New Jersey | 34009 | 646 | 51 |
220117 | 220117 | 2020-06-08 | Cape May | New Jersey | 34009 | 647 | 51 |
223212 | 223212 | 2020-06-09 | Cape May | New Jersey | 34009 | 654 | 54 |
226312 | 226312 | 2020-06-10 | Cape May | New Jersey | 34009 | 662 | 54 |
229416 | 229416 | 2020-06-11 | Cape May | New Jersey | 34009 | 663 | 55 |
232521 | 232521 | 2020-06-12 | Cape May | New Jersey | 34009 | 664 | 57 |
235626 | 235626 | 2020-06-13 | Cape May | New Jersey | 34009 | 669 | 58 |
238733 | 238733 | 2020-06-14 | Cape May | New Jersey | 34009 | 671 | 59 |
241843 | 241843 | 2020-06-15 | Cape May | New Jersey | 34009 | 672 | 61 |
244955 | 244955 | 2020-06-16 | Cape May | New Jersey | 34009 | 681 | 61 |
248068 | 248068 | 2020-06-17 | Cape May | New Jersey | 34009 | 682 | 61 |
251183 | 251183 | 2020-06-18 | Cape May | New Jersey | 34009 | 680 | 62 |
254298 | 254298 | 2020-06-19 | Cape May | New Jersey | 34009 | 681 | 62 |
257421 | 257421 | 2020-06-20 | Cape May | New Jersey | 34009 | 705 | 62 |
260547 | 260547 | 2020-06-21 | Cape May | New Jersey | 34009 | 688 | 62 |
263676 | 263676 | 2020-06-22 | Cape May | New Jersey | 34009 | 692 | 62 |
266803 | 266803 | 2020-06-23 | Cape May | New Jersey | 34009 | 694 | 63 |
269938 | 269938 | 2020-06-24 | Cape May | New Jersey | 34009 | 697 | 63 |
273077 | 273077 | 2020-06-25 | Cape May | New Jersey | 34009 | 708 | 67 |
276222 | 276222 | 2020-06-26 | Cape May | New Jersey | 34009 | 710 | 68 |
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);