ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 34013 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1505 | 1505 | 2020-03-12 | Essex | New Jersey | 34013 | 1 | 0 |
1797 | 1797 | 2020-03-13 | Essex | New Jersey | 34013 | 6 | 0 |
2143 | 2143 | 2020-03-14 | Essex | New Jersey | 34013 | 7 | 0 |
2551 | 2551 | 2020-03-15 | Essex | New Jersey | 34013 | 11 | 0 |
3007 | 3007 | 2020-03-16 | Essex | New Jersey | 34013 | 20 | 0 |
3519 | 3519 | 2020-03-17 | Essex | New Jersey | 34013 | 32 | 0 |
4115 | 4115 | 2020-03-18 | Essex | New Jersey | 34013 | 45 | 0 |
4842 | 4842 | 2020-03-19 | Essex | New Jersey | 34013 | 63 | 2 |
5686 | 5686 | 2020-03-20 | Essex | New Jersey | 34013 | 73 | 3 |
6679 | 6679 | 2020-03-21 | Essex | New Jersey | 34013 | 107 | 4 |
7770 | 7770 | 2020-03-22 | Essex | New Jersey | 34013 | 172 | 4 |
8966 | 8966 | 2020-03-23 | Essex | New Jersey | 34013 | 273 | 5 |
10270 | 10270 | 2020-03-24 | Essex | New Jersey | 34013 | 342 | 8 |
11702 | 11702 | 2020-03-25 | Essex | New Jersey | 34013 | 381 | 11 |
13305 | 13305 | 2020-03-26 | Essex | New Jersey | 34013 | 609 | 15 |
15037 | 15037 | 2020-03-27 | Essex | New Jersey | 34013 | 826 | 18 |
16866 | 16866 | 2020-03-28 | Essex | New Jersey | 34013 | 1086 | 20 |
18790 | 18790 | 2020-03-29 | Essex | New Jersey | 34013 | 1227 | 20 |
20828 | 20828 | 2020-03-30 | Essex | New Jersey | 34013 | 1564 | 36 |
22951 | 22951 | 2020-03-31 | Essex | New Jersey | 34013 | 1900 | 47 |
25142 | 25142 | 2020-04-01 | Essex | New Jersey | 34013 | 2262 | 69 |
27402 | 27402 | 2020-04-02 | Essex | New Jersey | 34013 | 2617 | 99 |
29725 | 29725 | 2020-04-03 | Essex | New Jersey | 34013 | 3067 | 118 |
32110 | 32110 | 2020-04-04 | Essex | New Jersey | 34013 | 3584 | 156 |
34541 | 34541 | 2020-04-05 | Essex | New Jersey | 34013 | 4082 | 172 |
37011 | 37011 | 2020-04-06 | Essex | New Jersey | 34013 | 4493 | 186 |
39526 | 39526 | 2020-04-07 | Essex | New Jersey | 34013 | 5078 | 232 |
42083 | 42083 | 2020-04-08 | Essex | New Jersey | 34013 | 5598 | 276 |
44665 | 44665 | 2020-04-09 | Essex | New Jersey | 34013 | 6069 | 312 |
47277 | 47277 | 2020-04-10 | Essex | New Jersey | 34013 | 6580 | 352 |
49931 | 49931 | 2020-04-11 | Essex | New Jersey | 34013 | 7007 | 412 |
52604 | 52604 | 2020-04-12 | Essex | New Jersey | 34013 | 7410 | 428 |
55287 | 55287 | 2020-04-13 | Essex | New Jersey | 34013 | 7634 | 433 |
57987 | 57987 | 2020-04-14 | Essex | New Jersey | 34013 | 8212 | 535 |
60701 | 60701 | 2020-04-15 | Essex | New Jersey | 34013 | 8579 | 590 |
63427 | 63427 | 2020-04-16 | Essex | New Jersey | 34013 | 9084 | 642 |
66169 | 66169 | 2020-04-17 | Essex | New Jersey | 34013 | 9672 | 684 |
68925 | 68925 | 2020-04-18 | Essex | New Jersey | 34013 | 9901 | 732 |
71692 | 71692 | 2020-04-19 | Essex | New Jersey | 34013 | 10304 | 740 |
74467 | 74467 | 2020-04-20 | Essex | New Jersey | 34013 | 10729 | 751 |
77248 | 77248 | 2020-04-21 | Essex | New Jersey | 34013 | 11128 | 849 |
80037 | 80037 | 2020-04-22 | Essex | New Jersey | 34013 | 11387 | 888 |
82835 | 82835 | 2020-04-23 | Essex | New Jersey | 34013 | 11811 | 932 |
85639 | 85639 | 2020-04-24 | Essex | New Jersey | 34013 | 12110 | 975 |
88450 | 88450 | 2020-04-25 | Essex | New Jersey | 34013 | 12520 | 1019 |
91265 | 91265 | 2020-04-26 | Essex | New Jersey | 34013 | 12863 | 1023 |
94089 | 94089 | 2020-04-27 | Essex | New Jersey | 34013 | 13047 | 1028 |
96925 | 96925 | 2020-04-28 | Essex | New Jersey | 34013 | 13190 | 1090 |
99772 | 99772 | 2020-04-29 | Essex | New Jersey | 34013 | 13445 | 1139 |
102625 | 102625 | 2020-04-30 | Essex | New Jersey | 34013 | 13682 | 1186 |
105487 | 105487 | 2020-05-01 | Essex | New Jersey | 34013 | 13994 | 1240 |
108353 | 108353 | 2020-05-02 | Essex | New Jersey | 34013 | 14248 | 1265 |
111226 | 111226 | 2020-05-03 | Essex | New Jersey | 34013 | 14521 | 1282 |
114107 | 114107 | 2020-05-04 | Essex | New Jersey | 34013 | 14621 | 1292 |
116988 | 116988 | 2020-05-05 | Essex | New Jersey | 34013 | 14840 | 1319 |
119949 | 119949 | 2020-05-06 | Essex | New Jersey | 34013 | 14951 | 1349 |
122924 | 122924 | 2020-05-07 | Essex | New Jersey | 34013 | 15095 | 1381 |
125907 | 125907 | 2020-05-08 | Essex | New Jersey | 34013 | 15256 | 1398 |
128896 | 128896 | 2020-05-09 | Essex | New Jersey | 34013 | 15365 | 1414 |
131885 | 131885 | 2020-05-10 | Essex | New Jersey | 34013 | 15524 | 1423 |
134876 | 134876 | 2020-05-11 | Essex | New Jersey | 34013 | 15602 | 1426 |
137866 | 137866 | 2020-05-12 | Essex | New Jersey | 34013 | 15658 | 1444 |
140862 | 140862 | 2020-05-13 | Essex | New Jersey | 34013 | 15749 | 1471 |
143857 | 143857 | 2020-05-14 | Essex | New Jersey | 34013 | 15824 | 1496 |
146858 | 146858 | 2020-05-15 | Essex | New Jersey | 34013 | 15953 | 1510 |
149865 | 149865 | 2020-05-16 | Essex | New Jersey | 34013 | 16032 | 1522 |
152875 | 152875 | 2020-05-17 | Essex | New Jersey | 34013 | 16140 | 1528 |
155891 | 155891 | 2020-05-18 | Essex | New Jersey | 34013 | 16600 | 1546 |
158909 | 158909 | 2020-05-19 | Essex | New Jersey | 34013 | 16686 | 1565 |
161935 | 161935 | 2020-05-20 | Essex | New Jersey | 34013 | 16852 | 1569 |
164964 | 164964 | 2020-05-21 | Essex | New Jersey | 34013 | 16906 | 1576 |
168000 | 168000 | 2020-05-22 | Essex | New Jersey | 34013 | 17014 | 1585 |
171039 | 171039 | 2020-05-23 | Essex | New Jersey | 34013 | 17065 | 1588 |
174081 | 174081 | 2020-05-24 | Essex | New Jersey | 34013 | 17142 | 1595 |
177124 | 177124 | 2020-05-25 | Essex | New Jersey | 34013 | 17202 | 1595 |
180168 | 180168 | 2020-05-26 | Essex | New Jersey | 34013 | 17255 | 1605 |
183216 | 183216 | 2020-05-27 | Essex | New Jersey | 34013 | 17338 | 1624 |
186273 | 186273 | 2020-05-28 | Essex | New Jersey | 34013 | 17450 | 1628 |
189333 | 189333 | 2020-05-29 | Essex | New Jersey | 34013 | 17546 | 1647 |
192397 | 192397 | 2020-05-30 | Essex | New Jersey | 34013 | 17594 | 1657 |
195467 | 195467 | 2020-05-31 | Essex | New Jersey | 34013 | 17629 | 1664 |
198540 | 198540 | 2020-06-01 | Essex | New Jersey | 34013 | 17695 | 1667 |
201614 | 201614 | 2020-06-02 | Essex | New Jersey | 34013 | 17752 | 1672 |
204691 | 204691 | 2020-06-03 | Essex | New Jersey | 34013 | 17811 | 1687 |
207772 | 207772 | 2020-06-04 | Essex | New Jersey | 34013 | 17912 | 1694 |
210854 | 210854 | 2020-06-05 | Essex | New Jersey | 34013 | 18019 | 1702 |
213938 | 213938 | 2020-06-06 | Essex | New Jersey | 34013 | 18066 | 1701 |
217027 | 217027 | 2020-06-07 | Essex | New Jersey | 34013 | 18077 | 1707 |
220119 | 220119 | 2020-06-08 | Essex | New Jersey | 34013 | 18117 | 1710 |
223214 | 223214 | 2020-06-09 | Essex | New Jersey | 34013 | 18151 | 1722 |
226314 | 226314 | 2020-06-10 | Essex | New Jersey | 34013 | 18206 | 1723 |
229418 | 229418 | 2020-06-11 | Essex | New Jersey | 34013 | 18234 | 1723 |
232523 | 232523 | 2020-06-12 | Essex | New Jersey | 34013 | 18295 | 1728 |
235628 | 235628 | 2020-06-13 | Essex | New Jersey | 34013 | 18336 | 1741 |
238735 | 238735 | 2020-06-14 | Essex | New Jersey | 34013 | 18364 | 1745 |
241845 | 241845 | 2020-06-15 | Essex | New Jersey | 34013 | 18375 | 1751 |
244957 | 244957 | 2020-06-16 | Essex | New Jersey | 34013 | 18388 | 1751 |
248070 | 248070 | 2020-06-17 | Essex | New Jersey | 34013 | 18421 | 1755 |
251185 | 251185 | 2020-06-18 | Essex | New Jersey | 34013 | 18499 | 1758 |
254300 | 254300 | 2020-06-19 | Essex | New Jersey | 34013 | 18533 | 1758 |
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);