ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 37051 and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7850 | 7850 | 2020-03-22 | Cumberland | North Carolina | 37051 | 2 | 0 |
9051 | 9051 | 2020-03-23 | Cumberland | North Carolina | 37051 | 2 | 0 |
10359 | 10359 | 2020-03-24 | Cumberland | North Carolina | 37051 | 2 | 0 |
11799 | 11799 | 2020-03-25 | Cumberland | North Carolina | 37051 | 5 | 0 |
13403 | 13403 | 2020-03-26 | Cumberland | North Carolina | 37051 | 7 | 0 |
15137 | 15137 | 2020-03-27 | Cumberland | North Carolina | 37051 | 8 | 0 |
16968 | 16968 | 2020-03-28 | Cumberland | North Carolina | 37051 | 10 | 0 |
18897 | 18897 | 2020-03-29 | Cumberland | North Carolina | 37051 | 13 | 0 |
20937 | 20937 | 2020-03-30 | Cumberland | North Carolina | 37051 | 15 | 0 |
23063 | 23063 | 2020-03-31 | Cumberland | North Carolina | 37051 | 18 | 0 |
25257 | 25257 | 2020-04-01 | Cumberland | North Carolina | 37051 | 19 | 0 |
27518 | 27518 | 2020-04-02 | Cumberland | North Carolina | 37051 | 25 | 0 |
29844 | 29844 | 2020-04-03 | Cumberland | North Carolina | 37051 | 35 | 0 |
32231 | 32231 | 2020-04-04 | Cumberland | North Carolina | 37051 | 42 | 0 |
34662 | 34662 | 2020-04-05 | Cumberland | North Carolina | 37051 | 42 | 0 |
37131 | 37131 | 2020-04-06 | Cumberland | North Carolina | 37051 | 45 | 0 |
39646 | 39646 | 2020-04-07 | Cumberland | North Carolina | 37051 | 62 | 0 |
42203 | 42203 | 2020-04-08 | Cumberland | North Carolina | 37051 | 64 | 0 |
44786 | 44786 | 2020-04-09 | Cumberland | North Carolina | 37051 | 72 | 1 |
47399 | 47399 | 2020-04-10 | Cumberland | North Carolina | 37051 | 75 | 1 |
50054 | 50054 | 2020-04-11 | Cumberland | North Carolina | 37051 | 82 | 1 |
52727 | 52727 | 2020-04-12 | Cumberland | North Carolina | 37051 | 84 | 1 |
55410 | 55410 | 2020-04-13 | Cumberland | North Carolina | 37051 | 84 | 2 |
58110 | 58110 | 2020-04-14 | Cumberland | North Carolina | 37051 | 86 | 2 |
60824 | 60824 | 2020-04-15 | Cumberland | North Carolina | 37051 | 87 | 2 |
63550 | 63550 | 2020-04-16 | Cumberland | North Carolina | 37051 | 93 | 2 |
66293 | 66293 | 2020-04-17 | Cumberland | North Carolina | 37051 | 97 | 3 |
69050 | 69050 | 2020-04-18 | Cumberland | North Carolina | 37051 | 105 | 3 |
71816 | 71816 | 2020-04-19 | Cumberland | North Carolina | 37051 | 112 | 3 |
74591 | 74591 | 2020-04-20 | Cumberland | North Carolina | 37051 | 112 | 3 |
77372 | 77372 | 2020-04-21 | Cumberland | North Carolina | 37051 | 127 | 6 |
80161 | 80161 | 2020-04-22 | Cumberland | North Carolina | 37051 | 129 | 6 |
82960 | 82960 | 2020-04-23 | Cumberland | North Carolina | 37051 | 137 | 5 |
85764 | 85764 | 2020-04-24 | Cumberland | North Carolina | 37051 | 161 | 6 |
88576 | 88576 | 2020-04-25 | Cumberland | North Carolina | 37051 | 184 | 6 |
91391 | 91391 | 2020-04-26 | Cumberland | North Carolina | 37051 | 192 | 6 |
94217 | 94217 | 2020-04-27 | Cumberland | North Carolina | 37051 | 193 | 6 |
97053 | 97053 | 2020-04-28 | Cumberland | North Carolina | 37051 | 218 | 7 |
99900 | 99900 | 2020-04-29 | Cumberland | North Carolina | 37051 | 223 | 7 |
102753 | 102753 | 2020-04-30 | Cumberland | North Carolina | 37051 | 238 | 7 |
105615 | 105615 | 2020-05-01 | Cumberland | North Carolina | 37051 | 256 | 8 |
108482 | 108482 | 2020-05-02 | Cumberland | North Carolina | 37051 | 275 | 8 |
111355 | 111355 | 2020-05-03 | Cumberland | North Carolina | 37051 | 276 | 8 |
114236 | 114236 | 2020-05-04 | Cumberland | North Carolina | 37051 | 279 | 8 |
117116 | 117116 | 2020-05-05 | Cumberland | North Carolina | 37051 | 290 | 8 |
120077 | 120077 | 2020-05-06 | Cumberland | North Carolina | 37051 | 318 | 8 |
123052 | 123052 | 2020-05-07 | Cumberland | North Carolina | 37051 | 336 | 9 |
126035 | 126035 | 2020-05-08 | Cumberland | North Carolina | 37051 | 342 | 9 |
129024 | 129024 | 2020-05-09 | Cumberland | North Carolina | 37051 | 347 | 9 |
132013 | 132013 | 2020-05-10 | Cumberland | North Carolina | 37051 | 348 | 9 |
135004 | 135004 | 2020-05-11 | Cumberland | North Carolina | 37051 | 351 | 9 |
137994 | 137994 | 2020-05-12 | Cumberland | North Carolina | 37051 | 368 | 10 |
140990 | 140990 | 2020-05-13 | Cumberland | North Carolina | 37051 | 398 | 10 |
143985 | 143985 | 2020-05-14 | Cumberland | North Carolina | 37051 | 413 | 11 |
146986 | 146986 | 2020-05-15 | Cumberland | North Carolina | 37051 | 435 | 11 |
149993 | 149993 | 2020-05-16 | Cumberland | North Carolina | 37051 | 463 | 12 |
153003 | 153003 | 2020-05-17 | Cumberland | North Carolina | 37051 | 468 | 12 |
156020 | 156020 | 2020-05-18 | Cumberland | North Carolina | 37051 | 471 | 12 |
159039 | 159039 | 2020-05-19 | Cumberland | North Carolina | 37051 | 500 | 13 |
162066 | 162066 | 2020-05-20 | Cumberland | North Carolina | 37051 | 505 | 13 |
165095 | 165095 | 2020-05-21 | Cumberland | North Carolina | 37051 | 524 | 14 |
168130 | 168130 | 2020-05-22 | Cumberland | North Carolina | 37051 | 541 | 14 |
171169 | 171169 | 2020-05-23 | Cumberland | North Carolina | 37051 | 559 | 14 |
174211 | 174211 | 2020-05-24 | Cumberland | North Carolina | 37051 | 578 | 14 |
177255 | 177255 | 2020-05-25 | Cumberland | North Carolina | 37051 | 588 | 15 |
180298 | 180298 | 2020-05-26 | Cumberland | North Carolina | 37051 | 590 | 15 |
183346 | 183346 | 2020-05-27 | Cumberland | North Carolina | 37051 | 600 | 16 |
186403 | 186403 | 2020-05-28 | Cumberland | North Carolina | 37051 | 622 | 16 |
189463 | 189463 | 2020-05-29 | Cumberland | North Carolina | 37051 | 658 | 17 |
192527 | 192527 | 2020-05-30 | Cumberland | North Carolina | 37051 | 682 | 17 |
195597 | 195597 | 2020-05-31 | Cumberland | North Carolina | 37051 | 691 | 17 |
198670 | 198670 | 2020-06-01 | Cumberland | North Carolina | 37051 | 696 | 17 |
201744 | 201744 | 2020-06-02 | Cumberland | North Carolina | 37051 | 708 | 23 |
204821 | 204821 | 2020-06-03 | Cumberland | North Carolina | 37051 | 721 | 23 |
207902 | 207902 | 2020-06-04 | Cumberland | North Carolina | 37051 | 733 | 24 |
210984 | 210984 | 2020-06-05 | Cumberland | North Carolina | 37051 | 744 | 24 |
214068 | 214068 | 2020-06-06 | Cumberland | North Carolina | 37051 | 768 | 26 |
217158 | 217158 | 2020-06-07 | Cumberland | North Carolina | 37051 | 775 | 26 |
220250 | 220250 | 2020-06-08 | Cumberland | North Carolina | 37051 | 781 | 26 |
223344 | 223344 | 2020-06-09 | Cumberland | North Carolina | 37051 | 798 | 26 |
226444 | 226444 | 2020-06-10 | Cumberland | North Carolina | 37051 | 811 | 30 |
229548 | 229548 | 2020-06-11 | Cumberland | North Carolina | 37051 | 828 | 29 |
232653 | 232653 | 2020-06-12 | Cumberland | North Carolina | 37051 | 855 | 30 |
235758 | 235758 | 2020-06-13 | Cumberland | North Carolina | 37051 | 874 | 30 |
238866 | 238866 | 2020-06-14 | Cumberland | North Carolina | 37051 | 888 | 30 |
241975 | 241975 | 2020-06-15 | Cumberland | North Carolina | 37051 | 895 | 30 |
245087 | 245087 | 2020-06-16 | Cumberland | North Carolina | 37051 | 904 | 30 |
248200 | 248200 | 2020-06-17 | Cumberland | North Carolina | 37051 | 935 | 30 |
251315 | 251315 | 2020-06-18 | Cumberland | North Carolina | 37051 | 948 | 30 |
254430 | 254430 | 2020-06-19 | Cumberland | North Carolina | 37051 | 965 | 30 |
257553 | 257553 | 2020-06-20 | Cumberland | North Carolina | 37051 | 988 | 31 |
260680 | 260680 | 2020-06-21 | Cumberland | North Carolina | 37051 | 1008 | 31 |
263808 | 263808 | 2020-06-22 | Cumberland | North Carolina | 37051 | 1014 | 31 |
266936 | 266936 | 2020-06-23 | Cumberland | North Carolina | 37051 | 1031 | 36 |
270070 | 270070 | 2020-06-24 | Cumberland | North Carolina | 37051 | 1053 | 39 |
273209 | 273209 | 2020-06-25 | Cumberland | North Carolina | 37051 | 1065 | 40 |
276355 | 276355 | 2020-06-26 | Cumberland | North Carolina | 37051 | 1087 | 41 |
279503 | 279503 | 2020-06-27 | Cumberland | North Carolina | 37051 | 1101 | 41 |
282649 | 282649 | 2020-06-28 | Cumberland | North Carolina | 37051 | 1142 | 41 |
285794 | 285794 | 2020-06-29 | Cumberland | North Carolina | 37051 | 1157 | 41 |
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);