ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 23005 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 |
---|---|---|---|---|---|---|---|
1744 | 1744 | 2020-03-13 | Cumberland | Maine | 23005 | 1 | 0 |
2084 | 2084 | 2020-03-14 | Cumberland | Maine | 23005 | 2 | 0 |
2482 | 2482 | 2020-03-15 | Cumberland | Maine | 23005 | 10 | 0 |
2928 | 2928 | 2020-03-16 | Cumberland | Maine | 23005 | 13 | 0 |
3426 | 3426 | 2020-03-17 | Cumberland | Maine | 23005 | 20 | 0 |
4007 | 4007 | 2020-03-18 | Cumberland | Maine | 23005 | 29 | 0 |
4709 | 4709 | 2020-03-19 | Cumberland | Maine | 23005 | 34 | 0 |
5527 | 5527 | 2020-03-20 | Cumberland | Maine | 23005 | 35 | 0 |
6482 | 6482 | 2020-03-21 | Cumberland | Maine | 23005 | 41 | 0 |
7557 | 7557 | 2020-03-22 | Cumberland | Maine | 23005 | 56 | 0 |
8726 | 8726 | 2020-03-23 | Cumberland | Maine | 23005 | 66 | 0 |
10015 | 10015 | 2020-03-24 | Cumberland | Maine | 23005 | 74 | 0 |
11424 | 11424 | 2020-03-25 | Cumberland | Maine | 23005 | 87 | 0 |
13004 | 13004 | 2020-03-26 | Cumberland | Maine | 23005 | 90 | 0 |
14712 | 14712 | 2020-03-27 | Cumberland | Maine | 23005 | 92 | 1 |
16532 | 16532 | 2020-03-28 | Cumberland | Maine | 23005 | 120 | 1 |
18446 | 18446 | 2020-03-29 | Cumberland | Maine | 23005 | 142 | 2 |
20462 | 20462 | 2020-03-30 | Cumberland | Maine | 23005 | 154 | 3 |
22571 | 22571 | 2020-03-31 | Cumberland | Maine | 23005 | 169 | 3 |
24747 | 24747 | 2020-04-01 | Cumberland | Maine | 23005 | 192 | 5 |
26998 | 26998 | 2020-04-02 | Cumberland | Maine | 23005 | 204 | 5 |
29316 | 29316 | 2020-04-03 | Cumberland | Maine | 23005 | 222 | 7 |
31694 | 31694 | 2020-04-04 | Cumberland | Maine | 23005 | 231 | 7 |
34119 | 34119 | 2020-04-05 | Cumberland | Maine | 23005 | 238 | 7 |
36578 | 36578 | 2020-04-06 | Cumberland | Maine | 23005 | 249 | 7 |
39086 | 39086 | 2020-04-07 | Cumberland | Maine | 23005 | 253 | 9 |
41638 | 41638 | 2020-04-08 | Cumberland | Maine | 23005 | 262 | 10 |
44214 | 44214 | 2020-04-09 | Cumberland | Maine | 23005 | 269 | 11 |
46822 | 46822 | 2020-04-10 | Cumberland | Maine | 23005 | 276 | 11 |
49464 | 49464 | 2020-04-11 | Cumberland | Maine | 23005 | 284 | 12 |
52134 | 52134 | 2020-04-12 | Cumberland | Maine | 23005 | 292 | 12 |
54815 | 54815 | 2020-04-13 | Cumberland | Maine | 23005 | 299 | 12 |
57513 | 57513 | 2020-04-14 | Cumberland | Maine | 23005 | 331 | 12 |
60221 | 60221 | 2020-04-15 | Cumberland | Maine | 23005 | 339 | 14 |
62942 | 62942 | 2020-04-16 | Cumberland | Maine | 23005 | 343 | 14 |
65681 | 65681 | 2020-04-17 | Cumberland | Maine | 23005 | 360 | 14 |
68430 | 68430 | 2020-04-18 | Cumberland | Maine | 23005 | 369 | 14 |
71193 | 71193 | 2020-04-19 | Cumberland | Maine | 23005 | 378 | 16 |
73965 | 73965 | 2020-04-20 | Cumberland | Maine | 23005 | 380 | 16 |
76745 | 76745 | 2020-04-21 | Cumberland | Maine | 23005 | 386 | 17 |
79531 | 79531 | 2020-04-22 | Cumberland | Maine | 23005 | 395 | 18 |
82327 | 82327 | 2020-04-23 | Cumberland | Maine | 23005 | 414 | 23 |
85131 | 85131 | 2020-04-24 | Cumberland | Maine | 23005 | 426 | 24 |
87940 | 87940 | 2020-04-25 | Cumberland | Maine | 23005 | 434 | 24 |
90756 | 90756 | 2020-04-26 | Cumberland | Maine | 23005 | 454 | 24 |
93577 | 93577 | 2020-04-27 | Cumberland | Maine | 23005 | 459 | 24 |
96412 | 96412 | 2020-04-28 | Cumberland | Maine | 23005 | 466 | 24 |
99258 | 99258 | 2020-04-29 | Cumberland | Maine | 23005 | 472 | 25 |
102110 | 102110 | 2020-04-30 | Cumberland | Maine | 23005 | 486 | 26 |
104971 | 104971 | 2020-05-01 | Cumberland | Maine | 23005 | 504 | 27 |
107835 | 107835 | 2020-05-02 | Cumberland | Maine | 23005 | 527 | 27 |
110707 | 110707 | 2020-05-03 | Cumberland | Maine | 23005 | 549 | 28 |
113584 | 113584 | 2020-05-04 | Cumberland | Maine | 23005 | 558 | 28 |
116466 | 116466 | 2020-05-05 | Cumberland | Maine | 23005 | 571 | 30 |
119427 | 119427 | 2020-05-06 | Cumberland | Maine | 23005 | 583 | 30 |
122398 | 122398 | 2020-05-07 | Cumberland | Maine | 23005 | 631 | 30 |
125380 | 125380 | 2020-05-08 | Cumberland | Maine | 23005 | 658 | 30 |
128367 | 128367 | 2020-05-09 | Cumberland | Maine | 23005 | 685 | 30 |
131357 | 131357 | 2020-05-10 | Cumberland | Maine | 23005 | 702 | 30 |
134348 | 134348 | 2020-05-11 | Cumberland | Maine | 23005 | 714 | 31 |
137338 | 137338 | 2020-05-12 | Cumberland | Maine | 23005 | 721 | 31 |
140332 | 140332 | 2020-05-13 | Cumberland | Maine | 23005 | 744 | 32 |
143327 | 143327 | 2020-05-14 | Cumberland | Maine | 23005 | 778 | 34 |
146327 | 146327 | 2020-05-15 | Cumberland | Maine | 23005 | 798 | 34 |
149332 | 149332 | 2020-05-16 | Cumberland | Maine | 23005 | 821 | 35 |
152343 | 152343 | 2020-05-17 | Cumberland | Maine | 23005 | 837 | 35 |
155357 | 155357 | 2020-05-18 | Cumberland | Maine | 23005 | 852 | 36 |
158375 | 158375 | 2020-05-19 | Cumberland | Maine | 23005 | 863 | 38 |
161401 | 161401 | 2020-05-20 | Cumberland | Maine | 23005 | 891 | 38 |
164430 | 164430 | 2020-05-21 | Cumberland | Maine | 23005 | 919 | 38 |
167466 | 167466 | 2020-05-22 | Cumberland | Maine | 23005 | 968 | 38 |
170504 | 170504 | 2020-05-23 | Cumberland | Maine | 23005 | 1009 | 40 |
173545 | 173545 | 2020-05-24 | Cumberland | Maine | 23005 | 1032 | 40 |
176589 | 176589 | 2020-05-25 | Cumberland | Maine | 23005 | 1040 | 40 |
179633 | 179633 | 2020-05-26 | Cumberland | Maine | 23005 | 1056 | 41 |
182678 | 182678 | 2020-05-27 | Cumberland | Maine | 23005 | 1065 | 43 |
185733 | 185733 | 2020-05-28 | Cumberland | Maine | 23005 | 1092 | 46 |
188791 | 188791 | 2020-05-29 | Cumberland | Maine | 23005 | 1117 | 47 |
191855 | 191855 | 2020-05-30 | Cumberland | Maine | 23005 | 1146 | 50 |
194923 | 194923 | 2020-05-31 | Cumberland | Maine | 23005 | 1175 | 50 |
197994 | 197994 | 2020-06-01 | Cumberland | Maine | 23005 | 1189 | 50 |
201066 | 201066 | 2020-06-02 | Cumberland | Maine | 23005 | 1203 | 54 |
204143 | 204143 | 2020-06-03 | Cumberland | Maine | 23005 | 1226 | 54 |
207224 | 207224 | 2020-06-04 | Cumberland | Maine | 23005 | 1244 | 54 |
210305 | 210305 | 2020-06-05 | Cumberland | Maine | 23005 | 1265 | 55 |
213390 | 213390 | 2020-06-06 | Cumberland | Maine | 23005 | 1290 | 55 |
216477 | 216477 | 2020-06-07 | Cumberland | Maine | 23005 | 1307 | 56 |
219569 | 219569 | 2020-06-08 | Cumberland | Maine | 23005 | 1311 | 56 |
222664 | 222664 | 2020-06-09 | Cumberland | Maine | 23005 | 1324 | 57 |
225760 | 225760 | 2020-06-10 | Cumberland | Maine | 23005 | 1339 | 57 |
228862 | 228862 | 2020-06-11 | Cumberland | Maine | 23005 | 1361 | 57 |
231966 | 231966 | 2020-06-12 | Cumberland | Maine | 23005 | 1388 | 57 |
235071 | 235071 | 2020-06-13 | Cumberland | Maine | 23005 | 1414 | 57 |
238178 | 238178 | 2020-06-14 | Cumberland | Maine | 23005 | 1434 | 57 |
241287 | 241287 | 2020-06-15 | Cumberland | Maine | 23005 | 1445 | 57 |
244398 | 244398 | 2020-06-16 | Cumberland | Maine | 23005 | 1450 | 57 |
247511 | 247511 | 2020-06-17 | Cumberland | Maine | 23005 | 1461 | 58 |
250623 | 250623 | 2020-06-18 | Cumberland | Maine | 23005 | 1493 | 58 |
253738 | 253738 | 2020-06-19 | Cumberland | Maine | 23005 | 1516 | 58 |
256858 | 256858 | 2020-06-20 | Cumberland | Maine | 23005 | 1534 | 58 |
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);