ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 34003 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
518 | 518 | 2020-03-04 | Bergen | New Jersey | 34003 | 1 | 0 |
564 | 564 | 2020-03-05 | Bergen | New Jersey | 34003 | 2 | 0 |
625 | 625 | 2020-03-06 | Bergen | New Jersey | 34003 | 3 | 0 |
713 | 713 | 2020-03-07 | Bergen | New Jersey | 34003 | 3 | 0 |
817 | 817 | 2020-03-08 | Bergen | New Jersey | 34003 | 4 | 0 |
941 | 941 | 2020-03-09 | Bergen | New Jersey | 34003 | 5 | 0 |
1091 | 1091 | 2020-03-10 | Bergen | New Jersey | 34003 | 7 | 1 |
1273 | 1273 | 2020-03-11 | Bergen | New Jersey | 34003 | 11 | 1 |
1502 | 1502 | 2020-03-12 | Bergen | New Jersey | 34003 | 13 | 1 |
1794 | 1794 | 2020-03-13 | Bergen | New Jersey | 34003 | 17 | 1 |
2140 | 2140 | 2020-03-14 | Bergen | New Jersey | 34003 | 31 | 1 |
2548 | 2548 | 2020-03-15 | Bergen | New Jersey | 34003 | 32 | 1 |
3004 | 3004 | 2020-03-16 | Bergen | New Jersey | 34003 | 61 | 2 |
3516 | 3516 | 2020-03-17 | Bergen | New Jersey | 34003 | 84 | 2 |
4112 | 4112 | 2020-03-18 | Bergen | New Jersey | 34003 | 133 | 4 |
4838 | 4838 | 2020-03-19 | Bergen | New Jersey | 34003 | 297 | 6 |
5681 | 5681 | 2020-03-20 | Bergen | New Jersey | 34003 | 342 | 7 |
6674 | 6674 | 2020-03-21 | Bergen | New Jersey | 34003 | 362 | 9 |
7765 | 7765 | 2020-03-22 | Bergen | New Jersey | 34003 | 457 | 10 |
8961 | 8961 | 2020-03-23 | Bergen | New Jersey | 34003 | 609 | 12 |
10265 | 10265 | 2020-03-24 | Bergen | New Jersey | 34003 | 701 | 14 |
11697 | 11697 | 2020-03-25 | Bergen | New Jersey | 34003 | 819 | 15 |
13300 | 13300 | 2020-03-26 | Bergen | New Jersey | 34003 | 1206 | 21 |
15032 | 15032 | 2020-03-27 | Bergen | New Jersey | 34003 | 1505 | 28 |
16861 | 16861 | 2020-03-28 | Bergen | New Jersey | 34003 | 1838 | 35 |
18785 | 18785 | 2020-03-29 | Bergen | New Jersey | 34003 | 2169 | 35 |
20823 | 20823 | 2020-03-30 | Bergen | New Jersey | 34003 | 2482 | 41 |
22946 | 22946 | 2020-03-31 | Bergen | New Jersey | 34003 | 2909 | 53 |
25137 | 25137 | 2020-04-01 | Bergen | New Jersey | 34003 | 3494 | 75 |
27397 | 27397 | 2020-04-02 | Bergen | New Jersey | 34003 | 4099 | 120 |
29720 | 29720 | 2020-04-03 | Bergen | New Jersey | 34003 | 4866 | 132 |
32105 | 32105 | 2020-04-04 | Bergen | New Jersey | 34003 | 5760 | 179 |
34536 | 34536 | 2020-04-05 | Bergen | New Jersey | 34003 | 6187 | 189 |
37006 | 37006 | 2020-04-06 | Bergen | New Jersey | 34003 | 6862 | 200 |
39521 | 39521 | 2020-04-07 | Bergen | New Jersey | 34003 | 7533 | 263 |
42078 | 42078 | 2020-04-08 | Bergen | New Jersey | 34003 | 7874 | 314 |
44660 | 44660 | 2020-04-09 | Bergen | New Jersey | 34003 | 8343 | 345 |
47272 | 47272 | 2020-04-10 | Bergen | New Jersey | 34003 | 8928 | 390 |
49926 | 49926 | 2020-04-11 | Bergen | New Jersey | 34003 | 9362 | 435 |
52599 | 52599 | 2020-04-12 | Bergen | New Jersey | 34003 | 9784 | 453 |
55282 | 55282 | 2020-04-13 | Bergen | New Jersey | 34003 | 10092 | 482 |
57982 | 57982 | 2020-04-14 | Bergen | New Jersey | 34003 | 10426 | 550 |
60696 | 60696 | 2020-04-15 | Bergen | New Jersey | 34003 | 10848 | 608 |
63422 | 63422 | 2020-04-16 | Bergen | New Jersey | 34003 | 11409 | 668 |
66164 | 66164 | 2020-04-17 | Bergen | New Jersey | 34003 | 11863 | 714 |
68920 | 68920 | 2020-04-18 | Bergen | New Jersey | 34003 | 12163 | 741 |
71687 | 71687 | 2020-04-19 | Bergen | New Jersey | 34003 | 12639 | 767 |
74462 | 74462 | 2020-04-20 | Bergen | New Jersey | 34003 | 13011 | 787 |
77243 | 77243 | 2020-04-21 | Bergen | New Jersey | 34003 | 13356 | 835 |
80032 | 80032 | 2020-04-22 | Bergen | New Jersey | 34003 | 13686 | 876 |
82830 | 82830 | 2020-04-23 | Bergen | New Jersey | 34003 | 14049 | 907 |
85634 | 85634 | 2020-04-24 | Bergen | New Jersey | 34003 | 14363 | 934 |
88445 | 88445 | 2020-04-25 | Bergen | New Jersey | 34003 | 14738 | 954 |
91260 | 91260 | 2020-04-26 | Bergen | New Jersey | 34003 | 14965 | 955 |
94084 | 94084 | 2020-04-27 | Bergen | New Jersey | 34003 | 15104 | 960 |
96920 | 96920 | 2020-04-28 | Bergen | New Jersey | 34003 | 15251 | 1002 |
99767 | 99767 | 2020-04-29 | Bergen | New Jersey | 34003 | 15446 | 1057 |
102620 | 102620 | 2020-04-30 | Bergen | New Jersey | 34003 | 15610 | 1136 |
105482 | 105482 | 2020-05-01 | Bergen | New Jersey | 34003 | 15830 | 1187 |
108348 | 108348 | 2020-05-02 | Bergen | New Jersey | 34003 | 15974 | 1202 |
111221 | 111221 | 2020-05-03 | Bergen | New Jersey | 34003 | 16185 | 1210 |
114102 | 114102 | 2020-05-04 | Bergen | New Jersey | 34003 | 16282 | 1215 |
116983 | 116983 | 2020-05-05 | Bergen | New Jersey | 34003 | 16460 | 1261 |
119944 | 119944 | 2020-05-06 | Bergen | New Jersey | 34003 | 16520 | 1289 |
122919 | 122919 | 2020-05-07 | Bergen | New Jersey | 34003 | 16609 | 1319 |
125902 | 125902 | 2020-05-08 | Bergen | New Jersey | 34003 | 16709 | 1329 |
128891 | 128891 | 2020-05-09 | Bergen | New Jersey | 34003 | 16804 | 1348 |
131880 | 131880 | 2020-05-10 | Bergen | New Jersey | 34003 | 16929 | 1355 |
134871 | 134871 | 2020-05-11 | Bergen | New Jersey | 34003 | 17028 | 1358 |
137861 | 137861 | 2020-05-12 | Bergen | New Jersey | 34003 | 17091 | 1388 |
140857 | 140857 | 2020-05-13 | Bergen | New Jersey | 34003 | 17150 | 1409 |
143852 | 143852 | 2020-05-14 | Bergen | New Jersey | 34003 | 17080 | 1423 |
146853 | 146853 | 2020-05-15 | Bergen | New Jersey | 34003 | 17195 | 1443 |
149860 | 149860 | 2020-05-16 | Bergen | New Jersey | 34003 | 17246 | 1450 |
152870 | 152870 | 2020-05-17 | Bergen | New Jersey | 34003 | 17361 | 1455 |
155886 | 155886 | 2020-05-18 | Bergen | New Jersey | 34003 | 17459 | 1460 |
158904 | 158904 | 2020-05-19 | Bergen | New Jersey | 34003 | 17522 | 1474 |
161930 | 161930 | 2020-05-20 | Bergen | New Jersey | 34003 | 17518 | 1500 |
164959 | 164959 | 2020-05-21 | Bergen | New Jersey | 34003 | 17583 | 1508 |
167995 | 167995 | 2020-05-22 | Bergen | New Jersey | 34003 | 17653 | 1515 |
171034 | 171034 | 2020-05-23 | Bergen | New Jersey | 34003 | 17668 | 1521 |
174076 | 174076 | 2020-05-24 | Bergen | New Jersey | 34003 | 17804 | 1525 |
177119 | 177119 | 2020-05-25 | Bergen | New Jersey | 34003 | 17901 | 1525 |
180163 | 180163 | 2020-05-26 | Bergen | New Jersey | 34003 | 17963 | 1528 |
183211 | 183211 | 2020-05-27 | Bergen | New Jersey | 34003 | 18023 | 1547 |
186268 | 186268 | 2020-05-28 | Bergen | New Jersey | 34003 | 18158 | 1553 |
189328 | 189328 | 2020-05-29 | Bergen | New Jersey | 34003 | 18223 | 1567 |
192392 | 192392 | 2020-05-30 | Bergen | New Jersey | 34003 | 18211 | 1573 |
195462 | 195462 | 2020-05-31 | Bergen | New Jersey | 34003 | 18272 | 1579 |
198535 | 198535 | 2020-06-01 | Bergen | New Jersey | 34003 | 18302 | 1580 |
201609 | 201609 | 2020-06-02 | Bergen | New Jersey | 34003 | 18333 | 1584 |
204686 | 204686 | 2020-06-03 | Bergen | New Jersey | 34003 | 18376 | 1595 |
207767 | 207767 | 2020-06-04 | Bergen | New Jersey | 34003 | 18408 | 1603 |
210849 | 210849 | 2020-06-05 | Bergen | New Jersey | 34003 | 18463 | 1611 |
213933 | 213933 | 2020-06-06 | Bergen | New Jersey | 34003 | 18492 | 1612 |
217022 | 217022 | 2020-06-07 | Bergen | New Jersey | 34003 | 18512 | 1618 |
220114 | 220114 | 2020-06-08 | Bergen | New Jersey | 34003 | 18538 | 1621 |
223209 | 223209 | 2020-06-09 | Bergen | New Jersey | 34003 | 18573 | 1628 |
226309 | 226309 | 2020-06-10 | Bergen | New Jersey | 34003 | 18667 | 1635 |
229413 | 229413 | 2020-06-11 | Bergen | New Jersey | 34003 | 18719 | 1646 |
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);