ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 34021 and state = "New Jersey" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2145 | 2145 | 2020-03-14 | Mercer | New Jersey | 34021 | 1 | 0 |
2553 | 2553 | 2020-03-15 | Mercer | New Jersey | 34021 | 1 | 0 |
3010 | 3010 | 2020-03-16 | Mercer | New Jersey | 34021 | 6 | 0 |
3523 | 3523 | 2020-03-17 | Mercer | New Jersey | 34021 | 9 | 0 |
4119 | 4119 | 2020-03-18 | Mercer | New Jersey | 34021 | 15 | 0 |
4846 | 4846 | 2020-03-19 | Mercer | New Jersey | 34021 | 20 | 0 |
5690 | 5690 | 2020-03-20 | Mercer | New Jersey | 34021 | 22 | 0 |
6683 | 6683 | 2020-03-21 | Mercer | New Jersey | 34021 | 30 | 0 |
7774 | 7774 | 2020-03-22 | Mercer | New Jersey | 34021 | 40 | 0 |
8970 | 8970 | 2020-03-23 | Mercer | New Jersey | 34021 | 50 | 0 |
10274 | 10274 | 2020-03-24 | Mercer | New Jersey | 34021 | 58 | 0 |
11706 | 11706 | 2020-03-25 | Mercer | New Jersey | 34021 | 82 | 0 |
13309 | 13309 | 2020-03-26 | Mercer | New Jersey | 34021 | 111 | 0 |
15041 | 15041 | 2020-03-27 | Mercer | New Jersey | 34021 | 131 | 0 |
16870 | 16870 | 2020-03-28 | Mercer | New Jersey | 34021 | 168 | 0 |
18794 | 18794 | 2020-03-29 | Mercer | New Jersey | 34021 | 202 | 0 |
20832 | 20832 | 2020-03-30 | Mercer | New Jersey | 34021 | 249 | 0 |
22955 | 22955 | 2020-03-31 | Mercer | New Jersey | 34021 | 268 | 1 |
25146 | 25146 | 2020-04-01 | Mercer | New Jersey | 34021 | 333 | 3 |
27406 | 27406 | 2020-04-02 | Mercer | New Jersey | 34021 | 386 | 4 |
29729 | 29729 | 2020-04-03 | Mercer | New Jersey | 34021 | 484 | 5 |
32114 | 32114 | 2020-04-04 | Mercer | New Jersey | 34021 | 586 | 13 |
34545 | 34545 | 2020-04-05 | Mercer | New Jersey | 34021 | 654 | 16 |
37015 | 37015 | 2020-04-06 | Mercer | New Jersey | 34021 | 740 | 19 |
39530 | 39530 | 2020-04-07 | Mercer | New Jersey | 34021 | 837 | 24 |
42087 | 42087 | 2020-04-08 | Mercer | New Jersey | 34021 | 992 | 28 |
44669 | 44669 | 2020-04-09 | Mercer | New Jersey | 34021 | 1161 | 36 |
47281 | 47281 | 2020-04-10 | Mercer | New Jersey | 34021 | 1282 | 39 |
49935 | 49935 | 2020-04-11 | Mercer | New Jersey | 34021 | 1434 | 49 |
52608 | 52608 | 2020-04-12 | Mercer | New Jersey | 34021 | 1567 | 50 |
55291 | 55291 | 2020-04-13 | Mercer | New Jersey | 34021 | 1646 | 53 |
57991 | 57991 | 2020-04-14 | Mercer | New Jersey | 34021 | 1731 | 71 |
60705 | 60705 | 2020-04-15 | Mercer | New Jersey | 34021 | 1856 | 76 |
63431 | 63431 | 2020-04-16 | Mercer | New Jersey | 34021 | 2037 | 87 |
66173 | 66173 | 2020-04-17 | Mercer | New Jersey | 34021 | 2123 | 101 |
68929 | 68929 | 2020-04-18 | Mercer | New Jersey | 34021 | 2215 | 110 |
71696 | 71696 | 2020-04-19 | Mercer | New Jersey | 34021 | 2395 | 113 |
74471 | 74471 | 2020-04-20 | Mercer | New Jersey | 34021 | 2591 | 122 |
77252 | 77252 | 2020-04-21 | Mercer | New Jersey | 34021 | 2753 | 133 |
80041 | 80041 | 2020-04-22 | Mercer | New Jersey | 34021 | 2845 | 145 |
82839 | 82839 | 2020-04-23 | Mercer | New Jersey | 34021 | 2991 | 163 |
85643 | 85643 | 2020-04-24 | Mercer | New Jersey | 34021 | 3086 | 178 |
88454 | 88454 | 2020-04-25 | Mercer | New Jersey | 34021 | 3245 | 183 |
91269 | 91269 | 2020-04-26 | Mercer | New Jersey | 34021 | 3355 | 188 |
94093 | 94093 | 2020-04-27 | Mercer | New Jersey | 34021 | 3433 | 194 |
96929 | 96929 | 2020-04-28 | Mercer | New Jersey | 34021 | 3605 | 212 |
99776 | 99776 | 2020-04-29 | Mercer | New Jersey | 34021 | 3725 | 220 |
102629 | 102629 | 2020-04-30 | Mercer | New Jersey | 34021 | 3937 | 231 |
105491 | 105491 | 2020-05-01 | Mercer | New Jersey | 34021 | 4077 | 239 |
108357 | 108357 | 2020-05-02 | Mercer | New Jersey | 34021 | 4271 | 252 |
111230 | 111230 | 2020-05-03 | Mercer | New Jersey | 34021 | 4504 | 255 |
114111 | 114111 | 2020-05-04 | Mercer | New Jersey | 34021 | 4594 | 256 |
116992 | 116992 | 2020-05-05 | Mercer | New Jersey | 34021 | 4743 | 280 |
119953 | 119953 | 2020-05-06 | Mercer | New Jersey | 34021 | 4860 | 298 |
122928 | 122928 | 2020-05-07 | Mercer | New Jersey | 34021 | 4986 | 313 |
125911 | 125911 | 2020-05-08 | Mercer | New Jersey | 34021 | 5111 | 322 |
128900 | 128900 | 2020-05-09 | Mercer | New Jersey | 34021 | 5233 | 330 |
131889 | 131889 | 2020-05-10 | Mercer | New Jersey | 34021 | 5317 | 334 |
134880 | 134880 | 2020-05-11 | Mercer | New Jersey | 34021 | 5393 | 340 |
137870 | 137870 | 2020-05-12 | Mercer | New Jersey | 34021 | 5426 | 349 |
140866 | 140866 | 2020-05-13 | Mercer | New Jersey | 34021 | 5499 | 360 |
143861 | 143861 | 2020-05-14 | Mercer | New Jersey | 34021 | 5612 | 374 |
146862 | 146862 | 2020-05-15 | Mercer | New Jersey | 34021 | 5673 | 386 |
149869 | 149869 | 2020-05-16 | Mercer | New Jersey | 34021 | 5719 | 396 |
152879 | 152879 | 2020-05-17 | Mercer | New Jersey | 34021 | 5825 | 407 |
155895 | 155895 | 2020-05-18 | Mercer | New Jersey | 34021 | 5950 | 408 |
158913 | 158913 | 2020-05-19 | Mercer | New Jersey | 34021 | 6018 | 422 |
161939 | 161939 | 2020-05-20 | Mercer | New Jersey | 34021 | 6162 | 431 |
164968 | 164968 | 2020-05-21 | Mercer | New Jersey | 34021 | 6205 | 438 |
168004 | 168004 | 2020-05-22 | Mercer | New Jersey | 34021 | 6295 | 443 |
171043 | 171043 | 2020-05-23 | Mercer | New Jersey | 34021 | 6351 | 447 |
174085 | 174085 | 2020-05-24 | Mercer | New Jersey | 34021 | 6413 | 449 |
177128 | 177128 | 2020-05-25 | Mercer | New Jersey | 34021 | 6491 | 450 |
180172 | 180172 | 2020-05-26 | Mercer | New Jersey | 34021 | 6544 | 452 |
183220 | 183220 | 2020-05-27 | Mercer | New Jersey | 34021 | 6592 | 458 |
186277 | 186277 | 2020-05-28 | Mercer | New Jersey | 34021 | 6670 | 462 |
189337 | 189337 | 2020-05-29 | Mercer | New Jersey | 34021 | 6775 | 466 |
192401 | 192401 | 2020-05-30 | Mercer | New Jersey | 34021 | 6850 | 470 |
195471 | 195471 | 2020-05-31 | Mercer | New Jersey | 34021 | 6933 | 472 |
198544 | 198544 | 2020-06-01 | Mercer | New Jersey | 34021 | 6961 | 475 |
201618 | 201618 | 2020-06-02 | Mercer | New Jersey | 34021 | 7004 | 477 |
204695 | 204695 | 2020-06-03 | Mercer | New Jersey | 34021 | 7033 | 485 |
207776 | 207776 | 2020-06-04 | Mercer | New Jersey | 34021 | 7072 | 492 |
210858 | 210858 | 2020-06-05 | Mercer | New Jersey | 34021 | 7120 | 499 |
213942 | 213942 | 2020-06-06 | Mercer | New Jersey | 34021 | 7148 | 500 |
217031 | 217031 | 2020-06-07 | Mercer | New Jersey | 34021 | 7166 | 501 |
220123 | 220123 | 2020-06-08 | Mercer | New Jersey | 34021 | 7184 | 504 |
223218 | 223218 | 2020-06-09 | Mercer | New Jersey | 34021 | 7204 | 509 |
226318 | 226318 | 2020-06-10 | Mercer | New Jersey | 34021 | 7245 | 510 |
229422 | 229422 | 2020-06-11 | Mercer | New Jersey | 34021 | 7275 | 510 |
232527 | 232527 | 2020-06-12 | Mercer | New Jersey | 34021 | 7295 | 515 |
235632 | 235632 | 2020-06-13 | Mercer | New Jersey | 34021 | 7323 | 517 |
238739 | 238739 | 2020-06-14 | Mercer | New Jersey | 34021 | 7351 | 518 |
241849 | 241849 | 2020-06-15 | Mercer | New Jersey | 34021 | 7371 | 517 |
244961 | 244961 | 2020-06-16 | Mercer | New Jersey | 34021 | 7381 | 522 |
248074 | 248074 | 2020-06-17 | Mercer | New Jersey | 34021 | 7393 | 523 |
251189 | 251189 | 2020-06-18 | Mercer | New Jersey | 34021 | 7416 | 524 |
254304 | 254304 | 2020-06-19 | Mercer | New Jersey | 34021 | 7463 | 525 |
257427 | 257427 | 2020-06-20 | Mercer | New Jersey | 34021 | 7489 | 524 |
260553 | 260553 | 2020-06-21 | Mercer | New Jersey | 34021 | 7541 | 524 |
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);