ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Unknown" and state = "New Jersey" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1512 | 1512 | 2020-03-12 | Unknown | New Jersey | 1 | 0 | |
1805 | 1805 | 2020-03-13 | Unknown | New Jersey | 1 | 0 | |
2152 | 2152 | 2020-03-14 | Unknown | New Jersey | 1 | 0 | |
2560 | 2560 | 2020-03-15 | Unknown | New Jersey | 1 | 0 | |
3018 | 3018 | 2020-03-16 | Unknown | New Jersey | 1 | 0 | |
3531 | 3531 | 2020-03-17 | Unknown | New Jersey | 1 | 0 | |
4127 | 4127 | 2020-03-18 | Unknown | New Jersey | 1 | 0 | |
4855 | 4855 | 2020-03-19 | Unknown | New Jersey | 1 | 0 | |
5699 | 5699 | 2020-03-20 | Unknown | New Jersey | 3 | 0 | |
6692 | 6692 | 2020-03-21 | Unknown | New Jersey | 151 | 0 | |
7784 | 7784 | 2020-03-22 | Unknown | New Jersey | 221 | 0 | |
8980 | 8980 | 2020-03-23 | Unknown | New Jersey | 416 | 0 | |
10284 | 10284 | 2020-03-24 | Unknown | New Jersey | 645 | 0 | |
11716 | 11716 | 2020-03-25 | Unknown | New Jersey | 933 | 0 | |
13319 | 13319 | 2020-03-26 | Unknown | New Jersey | 1478 | 0 | |
15051 | 15051 | 2020-03-27 | Unknown | New Jersey | 1984 | 0 | |
16880 | 16880 | 2020-03-28 | Unknown | New Jersey | 2478 | 0 | |
18804 | 18804 | 2020-03-29 | Unknown | New Jersey | 3020 | 21 | |
20842 | 20842 | 2020-03-30 | Unknown | New Jersey | 3840 | 0 | |
22965 | 22965 | 2020-03-31 | Unknown | New Jersey | 3683 | 0 | |
25156 | 25156 | 2020-04-01 | Unknown | New Jersey | 4512 | 0 | |
27416 | 27416 | 2020-04-02 | Unknown | New Jersey | 4866 | 4 | |
29739 | 29739 | 2020-04-03 | Unknown | New Jersey | 4805 | 4 | |
32124 | 32124 | 2020-04-04 | Unknown | New Jersey | 3935 | 11 | |
34555 | 34555 | 2020-04-05 | Unknown | New Jersey | 3821 | 11 | |
37025 | 37025 | 2020-04-06 | Unknown | New Jersey | 3521 | 14 | |
39540 | 39540 | 2020-04-07 | Unknown | New Jersey | 2220 | 4 | |
42097 | 42097 | 2020-04-08 | Unknown | New Jersey | 1362 | 4 | |
44679 | 44679 | 2020-04-09 | Unknown | New Jersey | 996 | 6 | |
47291 | 47291 | 2020-04-10 | Unknown | New Jersey | 649 | 2 | |
49945 | 49945 | 2020-04-11 | Unknown | New Jersey | 924 | 2 | |
52618 | 52618 | 2020-04-12 | Unknown | New Jersey | 1274 | 2 | |
55301 | 55301 | 2020-04-13 | Unknown | New Jersey | 1203 | 2 | |
58001 | 58001 | 2020-04-14 | Unknown | New Jersey | 1702 | 2 | |
60715 | 60715 | 2020-04-15 | Unknown | New Jersey | 1189 | 2 | |
63441 | 63441 | 2020-04-16 | Unknown | New Jersey | 1048 | 3 | |
66183 | 66183 | 2020-04-17 | Unknown | New Jersey | 719 | 3 | |
68939 | 68939 | 2020-04-18 | Unknown | New Jersey | 748 | 2 | |
71706 | 71706 | 2020-04-19 | Unknown | New Jersey | 585 | 0 | |
74481 | 74481 | 2020-04-20 | Unknown | New Jersey | 669 | 1 | |
77262 | 77262 | 2020-04-21 | Unknown | New Jersey | 599 | 0 | |
80051 | 80051 | 2020-04-22 | Unknown | New Jersey | 1045 | 2 | |
82849 | 82849 | 2020-04-23 | Unknown | New Jersey | 1108 | 2 | |
85653 | 85653 | 2020-04-24 | Unknown | New Jersey | 532 | 0 | |
88464 | 88464 | 2020-04-25 | Unknown | New Jersey | 557 | 0 | |
91279 | 91279 | 2020-04-26 | Unknown | New Jersey | 681 | 0 | |
94103 | 94103 | 2020-04-27 | Unknown | New Jersey | 818 | 0 | |
96939 | 96939 | 2020-04-28 | Unknown | New Jersey | 718 | 0 | |
99786 | 99786 | 2020-04-29 | Unknown | New Jersey | 617 | 0 | |
102639 | 102639 | 2020-04-30 | Unknown | New Jersey | 478 | 0 | |
105501 | 105501 | 2020-05-01 | Unknown | New Jersey | 583 | 0 | |
108367 | 108367 | 2020-05-02 | Unknown | New Jersey | 676 | 0 | |
111240 | 111240 | 2020-05-03 | Unknown | New Jersey | 641 | 0 | |
114121 | 114121 | 2020-05-04 | Unknown | New Jersey | 647 | 0 | |
117002 | 117002 | 2020-05-05 | Unknown | New Jersey | 550 | 0 | |
119963 | 119963 | 2020-05-06 | Unknown | New Jersey | 594 | 0 | |
122938 | 122938 | 2020-05-07 | Unknown | New Jersey | 552 | 0 | |
125921 | 125921 | 2020-05-08 | Unknown | New Jersey | 553 | 1 | |
128910 | 128910 | 2020-05-09 | Unknown | New Jersey | 557 | 0 | |
131899 | 131899 | 2020-05-10 | Unknown | New Jersey | 591 | 0 | |
134890 | 134890 | 2020-05-11 | Unknown | New Jersey | 729 | 0 | |
137880 | 137880 | 2020-05-12 | Unknown | New Jersey | 704 | 0 | |
140876 | 140876 | 2020-05-13 | Unknown | New Jersey | 662 | 0 | |
143871 | 143871 | 2020-05-14 | Unknown | New Jersey | 802 | 0 | |
146872 | 146872 | 2020-05-15 | Unknown | New Jersey | 885 | 0 | |
149879 | 149879 | 2020-05-16 | Unknown | New Jersey | 996 | 0 | |
152889 | 152889 | 2020-05-17 | Unknown | New Jersey | 949 | 0 | |
155905 | 155905 | 2020-05-18 | Unknown | New Jersey | 835 | 0 | |
158923 | 158923 | 2020-05-19 | Unknown | New Jersey | 778 | 0 | |
161949 | 161949 | 2020-05-20 | Unknown | New Jersey | 855 | 0 | |
164978 | 164978 | 2020-05-21 | Unknown | New Jersey | 1026 | 0 | |
168014 | 168014 | 2020-05-22 | Unknown | New Jersey | 1123 | 0 | |
171053 | 171053 | 2020-05-23 | Unknown | New Jersey | 1110 | 0 | |
174095 | 174095 | 2020-05-24 | Unknown | New Jersey | 1200 | 0 | |
177138 | 177138 | 2020-05-25 | Unknown | New Jersey | 1100 | 0 | |
180182 | 180182 | 2020-05-26 | Unknown | New Jersey | 1083 | 0 | |
183230 | 183230 | 2020-05-27 | Unknown | New Jersey | 1172 | 0 | |
186287 | 186287 | 2020-05-28 | Unknown | New Jersey | 1162 | 0 | |
189347 | 189347 | 2020-05-29 | Unknown | New Jersey | 1095 | 0 | |
192411 | 192411 | 2020-05-30 | Unknown | New Jersey | 970 | 0 | |
195481 | 195481 | 2020-05-31 | Unknown | New Jersey | 870 | 0 | |
198554 | 198554 | 2020-06-01 | Unknown | New Jersey | 863 | 0 | |
201628 | 201628 | 2020-06-02 | Unknown | New Jersey | 946 | 0 | |
204705 | 204705 | 2020-06-03 | Unknown | New Jersey | 854 | 0 | |
207786 | 207786 | 2020-06-04 | Unknown | New Jersey | 836 | 0 | |
210868 | 210868 | 2020-06-05 | Unknown | New Jersey | 785 | 0 | |
213952 | 213952 | 2020-06-06 | Unknown | New Jersey | 782 | 0 | |
217041 | 217041 | 2020-06-07 | Unknown | New Jersey | 744 | 0 | |
220133 | 220133 | 2020-06-08 | Unknown | New Jersey | 732 | 0 | |
223228 | 223228 | 2020-06-09 | Unknown | New Jersey | 680 | 0 | |
226328 | 226328 | 2020-06-10 | Unknown | New Jersey | 665 | 0 | |
229432 | 229432 | 2020-06-11 | Unknown | New Jersey | 653 | 0 | |
232537 | 232537 | 2020-06-12 | Unknown | New Jersey | 677 | 0 | |
235642 | 235642 | 2020-06-13 | Unknown | New Jersey | 667 | 0 | |
238749 | 238749 | 2020-06-14 | Unknown | New Jersey | 663 | 0 | |
241859 | 241859 | 2020-06-15 | Unknown | New Jersey | 651 | 0 | |
244971 | 244971 | 2020-06-16 | Unknown | New Jersey | 664 | 0 | |
248084 | 248084 | 2020-06-17 | Unknown | New Jersey | 643 | 0 | |
251199 | 251199 | 2020-06-18 | Unknown | New Jersey | 683 | 0 | |
254314 | 254314 | 2020-06-19 | Unknown | New Jersey | 693 | 0 |
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);