ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,029 rows where county = "Shelby" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Shelby · 7,029 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499632 | 2499632 | 2022-05-13 | Shelby | Alabama | 1117 | 61273 | 452 |
2500262 | 2500262 | 2022-05-13 | Shelby | Illinois | 17173 | 6262 | 80 |
2500351 | 2500351 | 2022-05-13 | Shelby | Indiana | 18145 | 13647 | 182 |
2500455 | 2500455 | 2022-05-13 | Shelby | Iowa | 19165 | 2724 | 50 |
2500684 | 2500684 | 2022-05-13 | Shelby | Kentucky | 21211 | 13410 | 162 |
2501174 | 2501174 | 2022-05-13 | Shelby | Missouri | 29205 | 1603 | 15 |
2501718 | 2501718 | 2022-05-13 | Shelby | Ohio | 39149 | 11102 | 188 |
2502189 | 2502189 | 2022-05-13 | Shelby | Tennessee | 47157 | 240841 | 3307 |
2502417 | 2502417 | 2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 |
2496374 | 2496374 | 2022-05-12 | Shelby | Alabama | 1117 | 61246 | 452 |
2497004 | 2497004 | 2022-05-12 | Shelby | Illinois | 17173 | 6259 | 80 |
2497093 | 2497093 | 2022-05-12 | Shelby | Indiana | 18145 | 13640 | 182 |
2497197 | 2497197 | 2022-05-12 | Shelby | Iowa | 19165 | 2724 | 50 |
2497426 | 2497426 | 2022-05-12 | Shelby | Kentucky | 21211 | 13410 | 162 |
2497916 | 2497916 | 2022-05-12 | Shelby | Missouri | 29205 | 1598 | 15 |
2498460 | 2498460 | 2022-05-12 | Shelby | Ohio | 39149 | 11102 | 188 |
2498931 | 2498931 | 2022-05-12 | Shelby | Tennessee | 47157 | 240480 | 3307 |
2499159 | 2499159 | 2022-05-12 | Shelby | Texas | 48419 | 4488 | 134 |
2493116 | 2493116 | 2022-05-11 | Shelby | Alabama | 1117 | 61218 | 451 |
2493746 | 2493746 | 2022-05-11 | Shelby | Illinois | 17173 | 6258 | 80 |
2493835 | 2493835 | 2022-05-11 | Shelby | Indiana | 18145 | 13640 | 182 |
2493939 | 2493939 | 2022-05-11 | Shelby | Iowa | 19165 | 2724 | 50 |
2494168 | 2494168 | 2022-05-11 | Shelby | Kentucky | 21211 | 13410 | 162 |
2494658 | 2494658 | 2022-05-11 | Shelby | Missouri | 29205 | 1598 | 15 |
2495202 | 2495202 | 2022-05-11 | Shelby | Ohio | 39149 | 11087 | 187 |
2495673 | 2495673 | 2022-05-11 | Shelby | Tennessee | 47157 | 240281 | 3307 |
2495901 | 2495901 | 2022-05-11 | Shelby | Texas | 48419 | 4486 | 134 |
2489858 | 2489858 | 2022-05-10 | Shelby | Alabama | 1117 | 61191 | 451 |
2490488 | 2490488 | 2022-05-10 | Shelby | Illinois | 17173 | 6252 | 80 |
2490577 | 2490577 | 2022-05-10 | Shelby | Indiana | 18145 | 13635 | 182 |
2490681 | 2490681 | 2022-05-10 | Shelby | Iowa | 19165 | 2722 | 50 |
2490910 | 2490910 | 2022-05-10 | Shelby | Kentucky | 21211 | 13410 | 162 |
2491400 | 2491400 | 2022-05-10 | Shelby | Missouri | 29205 | 1598 | 15 |
2491944 | 2491944 | 2022-05-10 | Shelby | Ohio | 39149 | 11087 | 187 |
2492415 | 2492415 | 2022-05-10 | Shelby | Tennessee | 47157 | 240062 | 3302 |
2492643 | 2492643 | 2022-05-10 | Shelby | Texas | 48419 | 4485 | 134 |
2486601 | 2486601 | 2022-05-09 | Shelby | Alabama | 1117 | 61150 | 451 |
2487231 | 2487231 | 2022-05-09 | Shelby | Illinois | 17173 | 6252 | 80 |
2487320 | 2487320 | 2022-05-09 | Shelby | Indiana | 18145 | 13635 | 182 |
2487424 | 2487424 | 2022-05-09 | Shelby | Iowa | 19165 | 2722 | 50 |
2487653 | 2487653 | 2022-05-09 | Shelby | Kentucky | 21211 | 13410 | 162 |
2488142 | 2488142 | 2022-05-09 | Shelby | Missouri | 29205 | 1598 | 15 |
2488686 | 2488686 | 2022-05-09 | Shelby | Ohio | 39149 | 11087 | 187 |
2489157 | 2489157 | 2022-05-09 | Shelby | Tennessee | 47157 | 239965 | 3302 |
2489385 | 2489385 | 2022-05-09 | Shelby | Texas | 48419 | 4485 | 134 |
2483343 | 2483343 | 2022-05-08 | Shelby | Alabama | 1117 | 61104 | 451 |
2483973 | 2483973 | 2022-05-08 | Shelby | Illinois | 17173 | 6252 | 80 |
2484062 | 2484062 | 2022-05-08 | Shelby | Indiana | 18145 | 13622 | 182 |
2484166 | 2484166 | 2022-05-08 | Shelby | Iowa | 19165 | 2722 | 50 |
2484395 | 2484395 | 2022-05-08 | Shelby | Kentucky | 21211 | 13364 | 161 |
2484885 | 2484885 | 2022-05-08 | Shelby | Missouri | 29205 | 1598 | 15 |
2485429 | 2485429 | 2022-05-08 | Shelby | Ohio | 39149 | 11087 | 187 |
2485900 | 2485900 | 2022-05-08 | Shelby | Tennessee | 47157 | 239829 | 3302 |
2486127 | 2486127 | 2022-05-08 | Shelby | Texas | 48419 | 4485 | 134 |
2480085 | 2480085 | 2022-05-07 | Shelby | Alabama | 1117 | 61104 | 451 |
2480715 | 2480715 | 2022-05-07 | Shelby | Illinois | 17173 | 6252 | 80 |
2480804 | 2480804 | 2022-05-07 | Shelby | Indiana | 18145 | 13622 | 182 |
2480908 | 2480908 | 2022-05-07 | Shelby | Iowa | 19165 | 2722 | 50 |
2481137 | 2481137 | 2022-05-07 | Shelby | Kentucky | 21211 | 13364 | 161 |
2481627 | 2481627 | 2022-05-07 | Shelby | Missouri | 29205 | 1598 | 15 |
2482171 | 2482171 | 2022-05-07 | Shelby | Ohio | 39149 | 11087 | 187 |
2482642 | 2482642 | 2022-05-07 | Shelby | Tennessee | 47157 | 239658 | 3302 |
2482869 | 2482869 | 2022-05-07 | Shelby | Texas | 48419 | 4485 | 134 |
2476827 | 2476827 | 2022-05-06 | Shelby | Alabama | 1117 | 61104 | 451 |
2477457 | 2477457 | 2022-05-06 | Shelby | Illinois | 17173 | 6252 | 80 |
2477546 | 2477546 | 2022-05-06 | Shelby | Indiana | 18145 | 13622 | 182 |
2477650 | 2477650 | 2022-05-06 | Shelby | Iowa | 19165 | 2722 | 50 |
2477879 | 2477879 | 2022-05-06 | Shelby | Kentucky | 21211 | 13364 | 161 |
2478369 | 2478369 | 2022-05-06 | Shelby | Missouri | 29205 | 1598 | 15 |
2478913 | 2478913 | 2022-05-06 | Shelby | Ohio | 39149 | 11087 | 187 |
2479384 | 2479384 | 2022-05-06 | Shelby | Tennessee | 47157 | 239518 | 3302 |
2479611 | 2479611 | 2022-05-06 | Shelby | Texas | 48419 | 4485 | 134 |
2473569 | 2473569 | 2022-05-05 | Shelby | Alabama | 1117 | 61083 | 451 |
2474199 | 2474199 | 2022-05-05 | Shelby | Illinois | 17173 | 6249 | 80 |
2474288 | 2474288 | 2022-05-05 | Shelby | Indiana | 18145 | 13622 | 182 |
2474392 | 2474392 | 2022-05-05 | Shelby | Iowa | 19165 | 2722 | 50 |
2474621 | 2474621 | 2022-05-05 | Shelby | Kentucky | 21211 | 13364 | 161 |
2475111 | 2475111 | 2022-05-05 | Shelby | Missouri | 29205 | 1588 | 15 |
2475655 | 2475655 | 2022-05-05 | Shelby | Ohio | 39149 | 11087 | 187 |
2476126 | 2476126 | 2022-05-05 | Shelby | Tennessee | 47157 | 239299 | 3302 |
2476353 | 2476353 | 2022-05-05 | Shelby | Texas | 48419 | 4483 | 134 |
2470312 | 2470312 | 2022-05-04 | Shelby | Alabama | 1117 | 61067 | 451 |
2470942 | 2470942 | 2022-05-04 | Shelby | Illinois | 17173 | 6246 | 80 |
2471031 | 2471031 | 2022-05-04 | Shelby | Indiana | 18145 | 13622 | 182 |
2471135 | 2471135 | 2022-05-04 | Shelby | Iowa | 19165 | 2722 | 50 |
2471364 | 2471364 | 2022-05-04 | Shelby | Kentucky | 21211 | 13364 | 161 |
2471854 | 2471854 | 2022-05-04 | Shelby | Missouri | 29205 | 1555 | 15 |
2472398 | 2472398 | 2022-05-04 | Shelby | Ohio | 39149 | 11077 | 187 |
2472869 | 2472869 | 2022-05-04 | Shelby | Tennessee | 47157 | 239168 | 3302 |
2473096 | 2473096 | 2022-05-04 | Shelby | Texas | 48419 | 4481 | 134 |
2467056 | 2467056 | 2022-05-03 | Shelby | Alabama | 1117 | 61052 | 451 |
2467686 | 2467686 | 2022-05-03 | Shelby | Illinois | 17173 | 6244 | 80 |
2467775 | 2467775 | 2022-05-03 | Shelby | Indiana | 18145 | 13616 | 182 |
2467879 | 2467879 | 2022-05-03 | Shelby | Iowa | 19165 | 2716 | 50 |
2468108 | 2468108 | 2022-05-03 | Shelby | Kentucky | 21211 | 13364 | 161 |
2468598 | 2468598 | 2022-05-03 | Shelby | Missouri | 29205 | 1555 | 15 |
2469142 | 2469142 | 2022-05-03 | Shelby | Ohio | 39149 | 11077 | 187 |
2469613 | 2469613 | 2022-05-03 | Shelby | Tennessee | 47157 | 239073 | 3301 |
2469840 | 2469840 | 2022-05-03 | Shelby | Texas | 48419 | 4480 | 134 |
2463801 | 2463801 | 2022-05-02 | Shelby | Alabama | 1117 | 61035 | 451 |
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);