ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Stafford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500565 | 2500565 | 2022-05-13 | Stafford | Kansas | 20185 | 1139 | 26 |
2502627 | 2502627 | 2022-05-13 | Stafford | Virginia | 51179 | 31265 | 177 |
2497307 | 2497307 | 2022-05-12 | Stafford | Kansas | 20185 | 1139 | 26 |
2499369 | 2499369 | 2022-05-12 | Stafford | Virginia | 51179 | 31215 | 177 |
2494049 | 2494049 | 2022-05-11 | Stafford | Kansas | 20185 | 1139 | 26 |
2496111 | 2496111 | 2022-05-11 | Stafford | Virginia | 51179 | 31147 | 177 |
2490791 | 2490791 | 2022-05-10 | Stafford | Kansas | 20185 | 1139 | 26 |
2492853 | 2492853 | 2022-05-10 | Stafford | Virginia | 51179 | 31091 | 177 |
2487534 | 2487534 | 2022-05-09 | Stafford | Kansas | 20185 | 1139 | 26 |
2489595 | 2489595 | 2022-05-09 | Stafford | Virginia | 51179 | 31048 | 177 |
2484276 | 2484276 | 2022-05-08 | Stafford | Kansas | 20185 | 1139 | 26 |
2486338 | 2486338 | 2022-05-08 | Stafford | Virginia | 51179 | 30917 | 177 |
2481018 | 2481018 | 2022-05-07 | Stafford | Kansas | 20185 | 1139 | 26 |
2483080 | 2483080 | 2022-05-07 | Stafford | Virginia | 51179 | 30917 | 177 |
2477760 | 2477760 | 2022-05-06 | Stafford | Kansas | 20185 | 1139 | 26 |
2479822 | 2479822 | 2022-05-06 | Stafford | Virginia | 51179 | 30917 | 177 |
2474502 | 2474502 | 2022-05-05 | Stafford | Kansas | 20185 | 1139 | 26 |
2476564 | 2476564 | 2022-05-05 | Stafford | Virginia | 51179 | 30852 | 176 |
2471245 | 2471245 | 2022-05-04 | Stafford | Kansas | 20185 | 1139 | 26 |
2473306 | 2473306 | 2022-05-04 | Stafford | Virginia | 51179 | 30796 | 176 |
2467989 | 2467989 | 2022-05-03 | Stafford | Kansas | 20185 | 1139 | 26 |
2470050 | 2470050 | 2022-05-03 | Stafford | Virginia | 51179 | 30752 | 176 |
2464734 | 2464734 | 2022-05-02 | Stafford | Kansas | 20185 | 1139 | 26 |
2466794 | 2466794 | 2022-05-02 | Stafford | Virginia | 51179 | 30713 | 176 |
2461478 | 2461478 | 2022-05-01 | Stafford | Kansas | 20185 | 1139 | 26 |
2463539 | 2463539 | 2022-05-01 | Stafford | Virginia | 51179 | 30662 | 176 |
2458222 | 2458222 | 2022-04-30 | Stafford | Kansas | 20185 | 1139 | 26 |
2460283 | 2460283 | 2022-04-30 | Stafford | Virginia | 51179 | 30662 | 176 |
2454966 | 2454966 | 2022-04-29 | Stafford | Kansas | 20185 | 1139 | 26 |
2457027 | 2457027 | 2022-04-29 | Stafford | Virginia | 51179 | 30662 | 176 |
2451710 | 2451710 | 2022-04-28 | Stafford | Kansas | 20185 | 1137 | 26 |
2453771 | 2453771 | 2022-04-28 | Stafford | Virginia | 51179 | 30640 | 175 |
2448454 | 2448454 | 2022-04-27 | Stafford | Kansas | 20185 | 1137 | 26 |
2450515 | 2450515 | 2022-04-27 | Stafford | Virginia | 51179 | 30600 | 175 |
2445198 | 2445198 | 2022-04-26 | Stafford | Kansas | 20185 | 1137 | 26 |
2447258 | 2447258 | 2022-04-26 | Stafford | Virginia | 51179 | 30572 | 175 |
2441942 | 2441942 | 2022-04-25 | Stafford | Kansas | 20185 | 1137 | 26 |
2444003 | 2444003 | 2022-04-25 | Stafford | Virginia | 51179 | 30539 | 175 |
2438686 | 2438686 | 2022-04-24 | Stafford | Kansas | 20185 | 1137 | 26 |
2440747 | 2440747 | 2022-04-24 | Stafford | Virginia | 51179 | 30483 | 175 |
2435430 | 2435430 | 2022-04-23 | Stafford | Kansas | 20185 | 1137 | 26 |
2437491 | 2437491 | 2022-04-23 | Stafford | Virginia | 51179 | 30483 | 175 |
2432174 | 2432174 | 2022-04-22 | Stafford | Kansas | 20185 | 1137 | 26 |
2434235 | 2434235 | 2022-04-22 | Stafford | Virginia | 51179 | 30483 | 175 |
2428918 | 2428918 | 2022-04-21 | Stafford | Kansas | 20185 | 1136 | 26 |
2430979 | 2430979 | 2022-04-21 | Stafford | Virginia | 51179 | 30453 | 175 |
2425662 | 2425662 | 2022-04-20 | Stafford | Kansas | 20185 | 1136 | 26 |
2427723 | 2427723 | 2022-04-20 | Stafford | Virginia | 51179 | 30443 | 175 |
2422406 | 2422406 | 2022-04-19 | Stafford | Kansas | 20185 | 1136 | 26 |
2424467 | 2424467 | 2022-04-19 | Stafford | Virginia | 51179 | 30438 | 175 |
2419150 | 2419150 | 2022-04-18 | Stafford | Kansas | 20185 | 1136 | 26 |
2421211 | 2421211 | 2022-04-18 | Stafford | Virginia | 51179 | 30415 | 175 |
2415894 | 2415894 | 2022-04-17 | Stafford | Kansas | 20185 | 1136 | 26 |
2417955 | 2417955 | 2022-04-17 | Stafford | Virginia | 51179 | 30373 | 175 |
2412638 | 2412638 | 2022-04-16 | Stafford | Kansas | 20185 | 1136 | 26 |
2414699 | 2414699 | 2022-04-16 | Stafford | Virginia | 51179 | 30373 | 175 |
2409382 | 2409382 | 2022-04-15 | Stafford | Kansas | 20185 | 1136 | 26 |
2411443 | 2411443 | 2022-04-15 | Stafford | Virginia | 51179 | 30373 | 175 |
2406126 | 2406126 | 2022-04-14 | Stafford | Kansas | 20185 | 1136 | 26 |
2408187 | 2408187 | 2022-04-14 | Stafford | Virginia | 51179 | 30343 | 174 |
2402870 | 2402870 | 2022-04-13 | Stafford | Kansas | 20185 | 1136 | 26 |
2404931 | 2404931 | 2022-04-13 | Stafford | Virginia | 51179 | 30332 | 174 |
2399616 | 2399616 | 2022-04-12 | Stafford | Kansas | 20185 | 1136 | 26 |
2401676 | 2401676 | 2022-04-12 | Stafford | Virginia | 51179 | 30316 | 174 |
2396360 | 2396360 | 2022-04-11 | Stafford | Kansas | 20185 | 1136 | 26 |
2398421 | 2398421 | 2022-04-11 | Stafford | Virginia | 51179 | 30294 | 172 |
2393105 | 2393105 | 2022-04-10 | Stafford | Kansas | 20185 | 1136 | 26 |
2395166 | 2395166 | 2022-04-10 | Stafford | Virginia | 51179 | 30264 | 172 |
2389849 | 2389849 | 2022-04-09 | Stafford | Kansas | 20185 | 1136 | 26 |
2391910 | 2391910 | 2022-04-09 | Stafford | Virginia | 51179 | 30264 | 172 |
2386593 | 2386593 | 2022-04-08 | Stafford | Kansas | 20185 | 1136 | 26 |
2388654 | 2388654 | 2022-04-08 | Stafford | Virginia | 51179 | 30264 | 172 |
2383339 | 2383339 | 2022-04-07 | Stafford | Kansas | 20185 | 1136 | 26 |
2385399 | 2385399 | 2022-04-07 | Stafford | Virginia | 51179 | 30232 | 171 |
2380084 | 2380084 | 2022-04-06 | Stafford | Kansas | 20185 | 1136 | 26 |
2382144 | 2382144 | 2022-04-06 | Stafford | Virginia | 51179 | 30208 | 171 |
2376829 | 2376829 | 2022-04-05 | Stafford | Kansas | 20185 | 1136 | 26 |
2378889 | 2378889 | 2022-04-05 | Stafford | Virginia | 51179 | 30181 | 171 |
2373577 | 2373577 | 2022-04-04 | Stafford | Kansas | 20185 | 1136 | 26 |
2375635 | 2375635 | 2022-04-04 | Stafford | Virginia | 51179 | 30156 | 170 |
2370324 | 2370324 | 2022-04-03 | Stafford | Kansas | 20185 | 1136 | 26 |
2372383 | 2372383 | 2022-04-03 | Stafford | Virginia | 51179 | 30139 | 170 |
2367071 | 2367071 | 2022-04-02 | Stafford | Kansas | 20185 | 1136 | 26 |
2369130 | 2369130 | 2022-04-02 | Stafford | Virginia | 51179 | 30139 | 170 |
2363818 | 2363818 | 2022-04-01 | Stafford | Kansas | 20185 | 1136 | 26 |
2365877 | 2365877 | 2022-04-01 | Stafford | Virginia | 51179 | 30139 | 170 |
2360564 | 2360564 | 2022-03-31 | Stafford | Kansas | 20185 | 1136 | 26 |
2362624 | 2362624 | 2022-03-31 | Stafford | Virginia | 51179 | 30103 | 170 |
2357310 | 2357310 | 2022-03-30 | Stafford | Kansas | 20185 | 1136 | 26 |
2359370 | 2359370 | 2022-03-30 | Stafford | Virginia | 51179 | 30052 | 170 |
2354057 | 2354057 | 2022-03-29 | Stafford | Kansas | 20185 | 1136 | 26 |
2356116 | 2356116 | 2022-03-29 | Stafford | Virginia | 51179 | 30037 | 170 |
2350805 | 2350805 | 2022-03-28 | Stafford | Kansas | 20185 | 1136 | 26 |
2352863 | 2352863 | 2022-03-28 | Stafford | Virginia | 51179 | 30022 | 169 |
2347552 | 2347552 | 2022-03-27 | Stafford | Kansas | 20185 | 1136 | 26 |
2349611 | 2349611 | 2022-03-27 | Stafford | Virginia | 51179 | 30002 | 169 |
2344299 | 2344299 | 2022-03-26 | Stafford | Kansas | 20185 | 1136 | 26 |
2346358 | 2346358 | 2022-03-26 | Stafford | Virginia | 51179 | 30002 | 169 |
2341046 | 2341046 | 2022-03-25 | Stafford | Kansas | 20185 | 1136 | 26 |
2343105 | 2343105 | 2022-03-25 | Stafford | Virginia | 51179 | 30002 | 169 |
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);