ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 34019 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 |
---|---|---|---|---|---|---|---|
3009 | 3009 | 2020-03-16 | Hunterdon | New Jersey | 34019 | 1 | 0 |
3522 | 3522 | 2020-03-17 | Hunterdon | New Jersey | 34019 | 4 | 0 |
4118 | 4118 | 2020-03-18 | Hunterdon | New Jersey | 34019 | 6 | 0 |
4845 | 4845 | 2020-03-19 | Hunterdon | New Jersey | 34019 | 8 | 0 |
5689 | 5689 | 2020-03-20 | Hunterdon | New Jersey | 34019 | 11 | 0 |
6682 | 6682 | 2020-03-21 | Hunterdon | New Jersey | 34019 | 14 | 0 |
7773 | 7773 | 2020-03-22 | Hunterdon | New Jersey | 34019 | 16 | 0 |
8969 | 8969 | 2020-03-23 | Hunterdon | New Jersey | 34019 | 18 | 0 |
10273 | 10273 | 2020-03-24 | Hunterdon | New Jersey | 34019 | 25 | 0 |
11705 | 11705 | 2020-03-25 | Hunterdon | New Jersey | 34019 | 25 | 0 |
13308 | 13308 | 2020-03-26 | Hunterdon | New Jersey | 34019 | 39 | 0 |
15040 | 15040 | 2020-03-27 | Hunterdon | New Jersey | 34019 | 52 | 0 |
16869 | 16869 | 2020-03-28 | Hunterdon | New Jersey | 34019 | 61 | 0 |
18793 | 18793 | 2020-03-29 | Hunterdon | New Jersey | 34019 | 66 | 0 |
20831 | 20831 | 2020-03-30 | Hunterdon | New Jersey | 34019 | 79 | 0 |
22954 | 22954 | 2020-03-31 | Hunterdon | New Jersey | 34019 | 97 | 0 |
25145 | 25145 | 2020-04-01 | Hunterdon | New Jersey | 34019 | 117 | 0 |
27405 | 27405 | 2020-04-02 | Hunterdon | New Jersey | 34019 | 130 | 0 |
29728 | 29728 | 2020-04-03 | Hunterdon | New Jersey | 34019 | 148 | 0 |
32113 | 32113 | 2020-04-04 | Hunterdon | New Jersey | 34019 | 171 | 1 |
34544 | 34544 | 2020-04-05 | Hunterdon | New Jersey | 34019 | 189 | 2 |
37014 | 37014 | 2020-04-06 | Hunterdon | New Jersey | 34019 | 211 | 2 |
39529 | 39529 | 2020-04-07 | Hunterdon | New Jersey | 34019 | 234 | 2 |
42086 | 42086 | 2020-04-08 | Hunterdon | New Jersey | 34019 | 255 | 2 |
44668 | 44668 | 2020-04-09 | Hunterdon | New Jersey | 34019 | 286 | 4 |
47280 | 47280 | 2020-04-10 | Hunterdon | New Jersey | 34019 | 293 | 7 |
49934 | 49934 | 2020-04-11 | Hunterdon | New Jersey | 34019 | 301 | 11 |
52607 | 52607 | 2020-04-12 | Hunterdon | New Jersey | 34019 | 314 | 11 |
55290 | 55290 | 2020-04-13 | Hunterdon | New Jersey | 34019 | 325 | 11 |
57990 | 57990 | 2020-04-14 | Hunterdon | New Jersey | 34019 | 349 | 11 |
60704 | 60704 | 2020-04-15 | Hunterdon | New Jersey | 34019 | 356 | 14 |
63430 | 63430 | 2020-04-16 | Hunterdon | New Jersey | 34019 | 373 | 15 |
66172 | 66172 | 2020-04-17 | Hunterdon | New Jersey | 34019 | 385 | 16 |
68928 | 68928 | 2020-04-18 | Hunterdon | New Jersey | 34019 | 391 | 17 |
71695 | 71695 | 2020-04-19 | Hunterdon | New Jersey | 34019 | 407 | 18 |
74470 | 74470 | 2020-04-20 | Hunterdon | New Jersey | 34019 | 419 | 18 |
77251 | 77251 | 2020-04-21 | Hunterdon | New Jersey | 34019 | 422 | 19 |
80040 | 80040 | 2020-04-22 | Hunterdon | New Jersey | 34019 | 434 | 21 |
82838 | 82838 | 2020-04-23 | Hunterdon | New Jersey | 34019 | 464 | 22 |
85642 | 85642 | 2020-04-24 | Hunterdon | New Jersey | 34019 | 490 | 22 |
88453 | 88453 | 2020-04-25 | Hunterdon | New Jersey | 34019 | 505 | 23 |
91268 | 91268 | 2020-04-26 | Hunterdon | New Jersey | 34019 | 536 | 23 |
94092 | 94092 | 2020-04-27 | Hunterdon | New Jersey | 34019 | 564 | 23 |
96928 | 96928 | 2020-04-28 | Hunterdon | New Jersey | 34019 | 573 | 24 |
99775 | 99775 | 2020-04-29 | Hunterdon | New Jersey | 34019 | 583 | 23 |
102628 | 102628 | 2020-04-30 | Hunterdon | New Jersey | 34019 | 603 | 29 |
105490 | 105490 | 2020-05-01 | Hunterdon | New Jersey | 34019 | 608 | 31 |
108356 | 108356 | 2020-05-02 | Hunterdon | New Jersey | 34019 | 622 | 35 |
111229 | 111229 | 2020-05-03 | Hunterdon | New Jersey | 34019 | 661 | 37 |
114110 | 114110 | 2020-05-04 | Hunterdon | New Jersey | 34019 | 665 | 37 |
116991 | 116991 | 2020-05-05 | Hunterdon | New Jersey | 34019 | 679 | 38 |
119952 | 119952 | 2020-05-06 | Hunterdon | New Jersey | 34019 | 682 | 39 |
122927 | 122927 | 2020-05-07 | Hunterdon | New Jersey | 34019 | 685 | 43 |
125910 | 125910 | 2020-05-08 | Hunterdon | New Jersey | 34019 | 701 | 44 |
128899 | 128899 | 2020-05-09 | Hunterdon | New Jersey | 34019 | 706 | 46 |
131888 | 131888 | 2020-05-10 | Hunterdon | New Jersey | 34019 | 714 | 45 |
134879 | 134879 | 2020-05-11 | Hunterdon | New Jersey | 34019 | 723 | 45 |
137869 | 137869 | 2020-05-12 | Hunterdon | New Jersey | 34019 | 729 | 45 |
140865 | 140865 | 2020-05-13 | Hunterdon | New Jersey | 34019 | 732 | 47 |
143860 | 143860 | 2020-05-14 | Hunterdon | New Jersey | 34019 | 764 | 48 |
146861 | 146861 | 2020-05-15 | Hunterdon | New Jersey | 34019 | 777 | 49 |
149868 | 149868 | 2020-05-16 | Hunterdon | New Jersey | 34019 | 795 | 49 |
152878 | 152878 | 2020-05-17 | Hunterdon | New Jersey | 34019 | 808 | 52 |
155894 | 155894 | 2020-05-18 | Hunterdon | New Jersey | 34019 | 846 | 52 |
158912 | 158912 | 2020-05-19 | Hunterdon | New Jersey | 34019 | 885 | 53 |
161938 | 161938 | 2020-05-20 | Hunterdon | New Jersey | 34019 | 920 | 55 |
164967 | 164967 | 2020-05-21 | Hunterdon | New Jersey | 34019 | 925 | 55 |
168003 | 168003 | 2020-05-22 | Hunterdon | New Jersey | 34019 | 938 | 55 |
171042 | 171042 | 2020-05-23 | Hunterdon | New Jersey | 34019 | 938 | 57 |
174084 | 174084 | 2020-05-24 | Hunterdon | New Jersey | 34019 | 960 | 57 |
177127 | 177127 | 2020-05-25 | Hunterdon | New Jersey | 34019 | 966 | 57 |
180171 | 180171 | 2020-05-26 | Hunterdon | New Jersey | 34019 | 967 | 57 |
183219 | 183219 | 2020-05-27 | Hunterdon | New Jersey | 34019 | 973 | 57 |
186276 | 186276 | 2020-05-28 | Hunterdon | New Jersey | 34019 | 974 | 58 |
189336 | 189336 | 2020-05-29 | Hunterdon | New Jersey | 34019 | 981 | 58 |
192400 | 192400 | 2020-05-30 | Hunterdon | New Jersey | 34019 | 985 | 60 |
195470 | 195470 | 2020-05-31 | Hunterdon | New Jersey | 34019 | 993 | 60 |
198543 | 198543 | 2020-06-01 | Hunterdon | New Jersey | 34019 | 996 | 60 |
201617 | 201617 | 2020-06-02 | Hunterdon | New Jersey | 34019 | 999 | 60 |
204694 | 204694 | 2020-06-03 | Hunterdon | New Jersey | 34019 | 1006 | 61 |
207775 | 207775 | 2020-06-04 | Hunterdon | New Jersey | 34019 | 1009 | 61 |
210857 | 210857 | 2020-06-05 | Hunterdon | New Jersey | 34019 | 1015 | 62 |
213941 | 213941 | 2020-06-06 | Hunterdon | New Jersey | 34019 | 1022 | 63 |
217030 | 217030 | 2020-06-07 | Hunterdon | New Jersey | 34019 | 1023 | 64 |
220122 | 220122 | 2020-06-08 | Hunterdon | New Jersey | 34019 | 1025 | 64 |
223217 | 223217 | 2020-06-09 | Hunterdon | New Jersey | 34019 | 1027 | 64 |
226317 | 226317 | 2020-06-10 | Hunterdon | New Jersey | 34019 | 1028 | 64 |
229421 | 229421 | 2020-06-11 | Hunterdon | New Jersey | 34019 | 1032 | 65 |
232526 | 232526 | 2020-06-12 | Hunterdon | New Jersey | 34019 | 1034 | 66 |
235631 | 235631 | 2020-06-13 | Hunterdon | New Jersey | 34019 | 1038 | 66 |
238738 | 238738 | 2020-06-14 | Hunterdon | New Jersey | 34019 | 1039 | 66 |
241848 | 241848 | 2020-06-15 | Hunterdon | New Jersey | 34019 | 1041 | 66 |
244960 | 244960 | 2020-06-16 | Hunterdon | New Jersey | 34019 | 1042 | 66 |
248073 | 248073 | 2020-06-17 | Hunterdon | New Jersey | 34019 | 1049 | 67 |
251188 | 251188 | 2020-06-18 | Hunterdon | New Jersey | 34019 | 1049 | 67 |
254303 | 254303 | 2020-06-19 | Hunterdon | New Jersey | 34019 | 1050 | 67 |
257426 | 257426 | 2020-06-20 | Hunterdon | New Jersey | 34019 | 1053 | 67 |
260552 | 260552 | 2020-06-21 | Hunterdon | New Jersey | 34019 | 1054 | 67 |
263681 | 263681 | 2020-06-22 | Hunterdon | New Jersey | 34019 | 1060 | 67 |
266808 | 266808 | 2020-06-23 | Hunterdon | New Jersey | 34019 | 1062 | 67 |
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);