ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Shelby" and state = "Alabama" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- …
state 1
- Alabama · 790 ✖
fips 1
- 1117 790
county 1
- Shelby · 790 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2316 | 2316 | 2020-03-15 | Shelby | Alabama | 1117 | 2 | 0 |
2745 | 2745 | 2020-03-16 | Shelby | Alabama | 1117 | 3 | 0 |
3222 | 3222 | 2020-03-17 | Shelby | Alabama | 1117 | 4 | 0 |
3769 | 3769 | 2020-03-18 | Shelby | Alabama | 1117 | 4 | 0 |
4411 | 4411 | 2020-03-19 | Shelby | Alabama | 1117 | 9 | 0 |
5181 | 5181 | 2020-03-20 | Shelby | Alabama | 1117 | 10 | 0 |
6098 | 6098 | 2020-03-21 | Shelby | Alabama | 1117 | 16 | 0 |
7132 | 7132 | 2020-03-22 | Shelby | Alabama | 1117 | 17 | 0 |
8272 | 8272 | 2020-03-23 | Shelby | Alabama | 1117 | 22 | 0 |
9500 | 9500 | 2020-03-24 | Shelby | Alabama | 1117 | 27 | 0 |
10869 | 10869 | 2020-03-25 | Shelby | Alabama | 1117 | 42 | 0 |
12408 | 12408 | 2020-03-26 | Shelby | Alabama | 1117 | 53 | 0 |
14070 | 14070 | 2020-03-27 | Shelby | Alabama | 1117 | 70 | 0 |
15849 | 15849 | 2020-03-28 | Shelby | Alabama | 1117 | 72 | 0 |
17733 | 17733 | 2020-03-29 | Shelby | Alabama | 1117 | 79 | 0 |
19705 | 19705 | 2020-03-30 | Shelby | Alabama | 1117 | 88 | 0 |
21777 | 21777 | 2020-03-31 | Shelby | Alabama | 1117 | 86 | 2 |
23933 | 23933 | 2020-04-01 | Shelby | Alabama | 1117 | 89 | 3 |
26155 | 26155 | 2020-04-02 | Shelby | Alabama | 1117 | 101 | 3 |
28452 | 28452 | 2020-04-03 | Shelby | Alabama | 1117 | 115 | 4 |
30809 | 30809 | 2020-04-04 | Shelby | Alabama | 1117 | 127 | 5 |
33213 | 33213 | 2020-04-05 | Shelby | Alabama | 1117 | 145 | 5 |
35652 | 35652 | 2020-04-06 | Shelby | Alabama | 1117 | 150 | 5 |
38140 | 38140 | 2020-04-07 | Shelby | Alabama | 1117 | 159 | 5 |
40682 | 40682 | 2020-04-08 | Shelby | Alabama | 1117 | 165 | 5 |
43256 | 43256 | 2020-04-09 | Shelby | Alabama | 1117 | 183 | 5 |
45854 | 45854 | 2020-04-10 | Shelby | Alabama | 1117 | 185 | 5 |
48483 | 48483 | 2020-04-11 | Shelby | Alabama | 1117 | 196 | 5 |
51145 | 51145 | 2020-04-12 | Shelby | Alabama | 1117 | 213 | 5 |
53823 | 53823 | 2020-04-13 | Shelby | Alabama | 1117 | 230 | 5 |
72953 | 72953 | 2020-04-20 | Shelby | Alabama | 1117 | 273 | 6 |
75729 | 75729 | 2020-04-21 | Shelby | Alabama | 1117 | 274 | 6 |
56515 | 56515 | 2020-04-14 | Shelby | Alabama | 1117 | 235 | 7 |
59223 | 59223 | 2020-04-15 | Shelby | Alabama | 1117 | 241 | 7 |
61941 | 61941 | 2020-04-16 | Shelby | Alabama | 1117 | 242 | 7 |
67422 | 67422 | 2020-04-18 | Shelby | Alabama | 1117 | 257 | 7 |
70184 | 70184 | 2020-04-19 | Shelby | Alabama | 1117 | 269 | 7 |
78512 | 78512 | 2020-04-22 | Shelby | Alabama | 1117 | 278 | 7 |
81305 | 81305 | 2020-04-23 | Shelby | Alabama | 1117 | 283 | 7 |
84106 | 84106 | 2020-04-24 | Shelby | Alabama | 1117 | 294 | 7 |
64674 | 64674 | 2020-04-17 | Shelby | Alabama | 1117 | 248 | 8 |
86914 | 86914 | 2020-04-25 | Shelby | Alabama | 1117 | 298 | 8 |
89730 | 89730 | 2020-04-26 | Shelby | Alabama | 1117 | 311 | 9 |
92548 | 92548 | 2020-04-27 | Shelby | Alabama | 1117 | 318 | 9 |
95378 | 95378 | 2020-04-28 | Shelby | Alabama | 1117 | 319 | 10 |
98223 | 98223 | 2020-04-29 | Shelby | Alabama | 1117 | 320 | 11 |
101073 | 101073 | 2020-04-30 | Shelby | Alabama | 1117 | 320 | 12 |
103928 | 103928 | 2020-05-01 | Shelby | Alabama | 1117 | 320 | 13 |
106793 | 106793 | 2020-05-02 | Shelby | Alabama | 1117 | 324 | 13 |
109662 | 109662 | 2020-05-03 | Shelby | Alabama | 1117 | 327 | 13 |
112537 | 112537 | 2020-05-04 | Shelby | Alabama | 1117 | 328 | 13 |
115420 | 115420 | 2020-05-05 | Shelby | Alabama | 1117 | 335 | 13 |
118379 | 118379 | 2020-05-06 | Shelby | Alabama | 1117 | 339 | 16 |
121345 | 121345 | 2020-05-07 | Shelby | Alabama | 1117 | 348 | 16 |
124325 | 124325 | 2020-05-08 | Shelby | Alabama | 1117 | 358 | 17 |
127310 | 127310 | 2020-05-09 | Shelby | Alabama | 1117 | 362 | 17 |
130300 | 130300 | 2020-05-10 | Shelby | Alabama | 1117 | 367 | 17 |
133290 | 133290 | 2020-05-11 | Shelby | Alabama | 1117 | 370 | 17 |
136280 | 136280 | 2020-05-12 | Shelby | Alabama | 1117 | 378 | 18 |
139271 | 139271 | 2020-05-13 | Shelby | Alabama | 1117 | 381 | 18 |
142267 | 142267 | 2020-05-14 | Shelby | Alabama | 1117 | 390 | 19 |
145266 | 145266 | 2020-05-15 | Shelby | Alabama | 1117 | 391 | 19 |
148269 | 148269 | 2020-05-16 | Shelby | Alabama | 1117 | 398 | 19 |
151278 | 151278 | 2020-05-17 | Shelby | Alabama | 1117 | 399 | 19 |
154290 | 154290 | 2020-05-18 | Shelby | Alabama | 1117 | 404 | 19 |
157306 | 157306 | 2020-05-19 | Shelby | Alabama | 1117 | 404 | 19 |
160330 | 160330 | 2020-05-20 | Shelby | Alabama | 1117 | 414 | 19 |
163358 | 163358 | 2020-05-21 | Shelby | Alabama | 1117 | 419 | 19 |
166390 | 166390 | 2020-05-22 | Shelby | Alabama | 1117 | 420 | 19 |
169426 | 169426 | 2020-05-23 | Shelby | Alabama | 1117 | 427 | 19 |
172467 | 172467 | 2020-05-24 | Shelby | Alabama | 1117 | 433 | 19 |
175510 | 175510 | 2020-05-25 | Shelby | Alabama | 1117 | 447 | 19 |
178555 | 178555 | 2020-05-26 | Shelby | Alabama | 1117 | 467 | 19 |
181599 | 181599 | 2020-05-27 | Shelby | Alabama | 1117 | 470 | 19 |
184651 | 184651 | 2020-05-28 | Shelby | Alabama | 1117 | 484 | 19 |
187708 | 187708 | 2020-05-29 | Shelby | Alabama | 1117 | 497 | 19 |
190772 | 190772 | 2020-05-30 | Shelby | Alabama | 1117 | 503 | 19 |
206136 | 206136 | 2020-06-04 | Shelby | Alabama | 1117 | 547 | 19 |
209218 | 209218 | 2020-06-05 | Shelby | Alabama | 1117 | 555 | 19 |
212303 | 212303 | 2020-06-06 | Shelby | Alabama | 1117 | 561 | 19 |
215390 | 215390 | 2020-06-07 | Shelby | Alabama | 1117 | 568 | 19 |
218480 | 218480 | 2020-06-08 | Shelby | Alabama | 1117 | 573 | 19 |
193838 | 193838 | 2020-05-31 | Shelby | Alabama | 1117 | 517 | 20 |
196908 | 196908 | 2020-06-01 | Shelby | Alabama | 1117 | 541 | 20 |
199981 | 199981 | 2020-06-02 | Shelby | Alabama | 1117 | 541 | 20 |
203057 | 203057 | 2020-06-03 | Shelby | Alabama | 1117 | 541 | 20 |
221572 | 221572 | 2020-06-09 | Shelby | Alabama | 1117 | 579 | 20 |
224668 | 224668 | 2020-06-10 | Shelby | Alabama | 1117 | 586 | 20 |
227769 | 227769 | 2020-06-11 | Shelby | Alabama | 1117 | 599 | 20 |
230873 | 230873 | 2020-06-12 | Shelby | Alabama | 1117 | 615 | 20 |
233978 | 233978 | 2020-06-13 | Shelby | Alabama | 1117 | 634 | 20 |
237085 | 237085 | 2020-06-14 | Shelby | Alabama | 1117 | 656 | 20 |
240193 | 240193 | 2020-06-15 | Shelby | Alabama | 1117 | 674 | 20 |
243304 | 243304 | 2020-06-16 | Shelby | Alabama | 1117 | 693 | 20 |
246417 | 246417 | 2020-06-17 | Shelby | Alabama | 1117 | 706 | 20 |
249529 | 249529 | 2020-06-18 | Shelby | Alabama | 1117 | 730 | 20 |
252644 | 252644 | 2020-06-19 | Shelby | Alabama | 1117 | 759 | 21 |
255763 | 255763 | 2020-06-20 | Shelby | Alabama | 1117 | 778 | 22 |
258890 | 258890 | 2020-06-21 | Shelby | Alabama | 1117 | 784 | 22 |
262017 | 262017 | 2020-06-22 | Shelby | Alabama | 1117 | 798 | 22 |
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);