ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37031 and state = "North Carolina" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5753 | 5753 | 2020-03-20 | Carteret | North Carolina | 37031 | 1 | 0 |
6749 | 6749 | 2020-03-21 | Carteret | North Carolina | 37031 | 1 | 0 |
7845 | 7845 | 2020-03-22 | Carteret | North Carolina | 37031 | 2 | 0 |
9046 | 9046 | 2020-03-23 | Carteret | North Carolina | 37031 | 4 | 0 |
10354 | 10354 | 2020-03-24 | Carteret | North Carolina | 37031 | 4 | 0 |
11793 | 11793 | 2020-03-25 | Carteret | North Carolina | 37031 | 5 | 0 |
13397 | 13397 | 2020-03-26 | Carteret | North Carolina | 37031 | 5 | 0 |
15131 | 15131 | 2020-03-27 | Carteret | North Carolina | 37031 | 5 | 0 |
16962 | 16962 | 2020-03-28 | Carteret | North Carolina | 37031 | 6 | 0 |
18889 | 18889 | 2020-03-29 | Carteret | North Carolina | 37031 | 8 | 0 |
20929 | 20929 | 2020-03-30 | Carteret | North Carolina | 37031 | 10 | 0 |
23054 | 23054 | 2020-03-31 | Carteret | North Carolina | 37031 | 12 | 0 |
25248 | 25248 | 2020-04-01 | Carteret | North Carolina | 37031 | 12 | 0 |
27509 | 27509 | 2020-04-02 | Carteret | North Carolina | 37031 | 13 | 0 |
29834 | 29834 | 2020-04-03 | Carteret | North Carolina | 37031 | 14 | 0 |
32221 | 32221 | 2020-04-04 | Carteret | North Carolina | 37031 | 15 | 0 |
34652 | 34652 | 2020-04-05 | Carteret | North Carolina | 37031 | 15 | 0 |
37121 | 37121 | 2020-04-06 | Carteret | North Carolina | 37031 | 17 | 0 |
39636 | 39636 | 2020-04-07 | Carteret | North Carolina | 37031 | 17 | 1 |
42193 | 42193 | 2020-04-08 | Carteret | North Carolina | 37031 | 18 | 1 |
44776 | 44776 | 2020-04-09 | Carteret | North Carolina | 37031 | 19 | 1 |
47389 | 47389 | 2020-04-10 | Carteret | North Carolina | 37031 | 20 | 1 |
50044 | 50044 | 2020-04-11 | Carteret | North Carolina | 37031 | 21 | 1 |
52717 | 52717 | 2020-04-12 | Carteret | North Carolina | 37031 | 21 | 1 |
55400 | 55400 | 2020-04-13 | Carteret | North Carolina | 37031 | 22 | 1 |
58100 | 58100 | 2020-04-14 | Carteret | North Carolina | 37031 | 22 | 1 |
60814 | 60814 | 2020-04-15 | Carteret | North Carolina | 37031 | 22 | 1 |
63540 | 63540 | 2020-04-16 | Carteret | North Carolina | 37031 | 22 | 1 |
66283 | 66283 | 2020-04-17 | Carteret | North Carolina | 37031 | 22 | 1 |
69040 | 69040 | 2020-04-18 | Carteret | North Carolina | 37031 | 22 | 2 |
71806 | 71806 | 2020-04-19 | Carteret | North Carolina | 37031 | 22 | 2 |
74581 | 74581 | 2020-04-20 | Carteret | North Carolina | 37031 | 22 | 2 |
77362 | 77362 | 2020-04-21 | Carteret | North Carolina | 37031 | 21 | 2 |
80151 | 80151 | 2020-04-22 | Carteret | North Carolina | 37031 | 21 | 2 |
82950 | 82950 | 2020-04-23 | Carteret | North Carolina | 37031 | 22 | 2 |
85754 | 85754 | 2020-04-24 | Carteret | North Carolina | 37031 | 22 | 2 |
88566 | 88566 | 2020-04-25 | Carteret | North Carolina | 37031 | 26 | 3 |
91381 | 91381 | 2020-04-26 | Carteret | North Carolina | 37031 | 26 | 3 |
94207 | 94207 | 2020-04-27 | Carteret | North Carolina | 37031 | 28 | 3 |
97043 | 97043 | 2020-04-28 | Carteret | North Carolina | 37031 | 28 | 3 |
99890 | 99890 | 2020-04-29 | Carteret | North Carolina | 37031 | 27 | 3 |
102743 | 102743 | 2020-04-30 | Carteret | North Carolina | 37031 | 27 | 3 |
105605 | 105605 | 2020-05-01 | Carteret | North Carolina | 37031 | 29 | 3 |
108472 | 108472 | 2020-05-02 | Carteret | North Carolina | 37031 | 27 | 3 |
111345 | 111345 | 2020-05-03 | Carteret | North Carolina | 37031 | 27 | 3 |
114226 | 114226 | 2020-05-04 | Carteret | North Carolina | 37031 | 27 | 3 |
117106 | 117106 | 2020-05-05 | Carteret | North Carolina | 37031 | 27 | 3 |
120067 | 120067 | 2020-05-06 | Carteret | North Carolina | 37031 | 28 | 3 |
123042 | 123042 | 2020-05-07 | Carteret | North Carolina | 37031 | 29 | 3 |
126025 | 126025 | 2020-05-08 | Carteret | North Carolina | 37031 | 29 | 3 |
129014 | 129014 | 2020-05-09 | Carteret | North Carolina | 37031 | 29 | 3 |
132003 | 132003 | 2020-05-10 | Carteret | North Carolina | 37031 | 31 | 3 |
134994 | 134994 | 2020-05-11 | Carteret | North Carolina | 37031 | 31 | 3 |
137984 | 137984 | 2020-05-12 | Carteret | North Carolina | 37031 | 32 | 3 |
140980 | 140980 | 2020-05-13 | Carteret | North Carolina | 37031 | 34 | 3 |
143975 | 143975 | 2020-05-14 | Carteret | North Carolina | 37031 | 34 | 3 |
146976 | 146976 | 2020-05-15 | Carteret | North Carolina | 37031 | 35 | 3 |
149983 | 149983 | 2020-05-16 | Carteret | North Carolina | 37031 | 35 | 3 |
152993 | 152993 | 2020-05-17 | Carteret | North Carolina | 37031 | 35 | 3 |
156010 | 156010 | 2020-05-18 | Carteret | North Carolina | 37031 | 35 | 3 |
159029 | 159029 | 2020-05-19 | Carteret | North Carolina | 37031 | 35 | 3 |
162056 | 162056 | 2020-05-20 | Carteret | North Carolina | 37031 | 35 | 3 |
165085 | 165085 | 2020-05-21 | Carteret | North Carolina | 37031 | 35 | 3 |
168120 | 168120 | 2020-05-22 | Carteret | North Carolina | 37031 | 35 | 9 |
171159 | 171159 | 2020-05-23 | Carteret | North Carolina | 37031 | 35 | 9 |
174201 | 174201 | 2020-05-24 | Carteret | North Carolina | 37031 | 35 | 9 |
177245 | 177245 | 2020-05-25 | Carteret | North Carolina | 37031 | 36 | 3 |
180288 | 180288 | 2020-05-26 | Carteret | North Carolina | 37031 | 36 | 3 |
183336 | 183336 | 2020-05-27 | Carteret | North Carolina | 37031 | 36 | 3 |
186393 | 186393 | 2020-05-28 | Carteret | North Carolina | 37031 | 36 | 3 |
189453 | 189453 | 2020-05-29 | Carteret | North Carolina | 37031 | 36 | 3 |
192517 | 192517 | 2020-05-30 | Carteret | North Carolina | 37031 | 36 | 3 |
195587 | 195587 | 2020-05-31 | Carteret | North Carolina | 37031 | 36 | 3 |
198660 | 198660 | 2020-06-01 | Carteret | North Carolina | 37031 | 36 | 3 |
201734 | 201734 | 2020-06-02 | Carteret | North Carolina | 37031 | 36 | 3 |
204811 | 204811 | 2020-06-03 | Carteret | North Carolina | 37031 | 36 | 3 |
207892 | 207892 | 2020-06-04 | Carteret | North Carolina | 37031 | 37 | 3 |
210974 | 210974 | 2020-06-05 | Carteret | North Carolina | 37031 | 39 | 3 |
214058 | 214058 | 2020-06-06 | Carteret | North Carolina | 37031 | 39 | 3 |
217148 | 217148 | 2020-06-07 | Carteret | North Carolina | 37031 | 39 | 3 |
220240 | 220240 | 2020-06-08 | Carteret | North Carolina | 37031 | 40 | 3 |
223334 | 223334 | 2020-06-09 | Carteret | North Carolina | 37031 | 40 | 3 |
226434 | 226434 | 2020-06-10 | Carteret | North Carolina | 37031 | 42 | 3 |
229538 | 229538 | 2020-06-11 | Carteret | North Carolina | 37031 | 43 | 3 |
232643 | 232643 | 2020-06-12 | Carteret | North Carolina | 37031 | 45 | 3 |
235748 | 235748 | 2020-06-13 | Carteret | North Carolina | 37031 | 46 | 3 |
238856 | 238856 | 2020-06-14 | Carteret | North Carolina | 37031 | 46 | 3 |
241965 | 241965 | 2020-06-15 | Carteret | North Carolina | 37031 | 47 | 3 |
245077 | 245077 | 2020-06-16 | Carteret | North Carolina | 37031 | 48 | 3 |
248190 | 248190 | 2020-06-17 | Carteret | North Carolina | 37031 | 47 | 3 |
251305 | 251305 | 2020-06-18 | Carteret | North Carolina | 37031 | 49 | 3 |
254420 | 254420 | 2020-06-19 | Carteret | North Carolina | 37031 | 51 | 3 |
257543 | 257543 | 2020-06-20 | Carteret | North Carolina | 37031 | 52 | 3 |
260670 | 260670 | 2020-06-21 | Carteret | North Carolina | 37031 | 53 | 3 |
263798 | 263798 | 2020-06-22 | Carteret | North Carolina | 37031 | 57 | 3 |
266926 | 266926 | 2020-06-23 | Carteret | North Carolina | 37031 | 59 | 3 |
270060 | 270060 | 2020-06-24 | Carteret | North Carolina | 37031 | 61 | 3 |
273199 | 273199 | 2020-06-25 | Carteret | North Carolina | 37031 | 64 | 3 |
276345 | 276345 | 2020-06-26 | Carteret | North Carolina | 37031 | 67 | 3 |
279493 | 279493 | 2020-06-27 | Carteret | North Carolina | 37031 | 70 | 3 |
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);