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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337793 | 2337793 | 2022-03-24 | Stafford | Kansas | 20185 | 1136 | 26 |
2339852 | 2339852 | 2022-03-24 | Stafford | Virginia | 51179 | 29989 | 169 |
2334539 | 2334539 | 2022-03-23 | Stafford | Kansas | 20185 | 1136 | 26 |
2336598 | 2336598 | 2022-03-23 | Stafford | Virginia | 51179 | 29980 | 169 |
2331285 | 2331285 | 2022-03-22 | Stafford | Kansas | 20185 | 1135 | 26 |
2333344 | 2333344 | 2022-03-22 | Stafford | Virginia | 51179 | 29968 | 168 |
2328033 | 2328033 | 2022-03-21 | Stafford | Kansas | 20185 | 1135 | 26 |
2330091 | 2330091 | 2022-03-21 | Stafford | Virginia | 51179 | 29968 | 168 |
2324780 | 2324780 | 2022-03-20 | Stafford | Kansas | 20185 | 1135 | 26 |
2326839 | 2326839 | 2022-03-20 | Stafford | Virginia | 51179 | 29939 | 167 |
2321526 | 2321526 | 2022-03-19 | Stafford | Kansas | 20185 | 1135 | 26 |
2323586 | 2323586 | 2022-03-19 | Stafford | Virginia | 51179 | 29939 | 167 |
2318272 | 2318272 | 2022-03-18 | Stafford | Kansas | 20185 | 1135 | 26 |
2320332 | 2320332 | 2022-03-18 | Stafford | Virginia | 51179 | 29939 | 167 |
2315019 | 2315019 | 2022-03-17 | Stafford | Kansas | 20185 | 1134 | 26 |
2317078 | 2317078 | 2022-03-17 | Stafford | Virginia | 51179 | 29920 | 167 |
2311766 | 2311766 | 2022-03-16 | Stafford | Kansas | 20185 | 1134 | 26 |
2313825 | 2313825 | 2022-03-16 | Stafford | Virginia | 51179 | 29907 | 167 |
2308513 | 2308513 | 2022-03-15 | Stafford | Kansas | 20185 | 1134 | 26 |
2310572 | 2310572 | 2022-03-15 | Stafford | Virginia | 51179 | 29888 | 167 |
2305262 | 2305262 | 2022-03-14 | Stafford | Kansas | 20185 | 1134 | 26 |
2307319 | 2307319 | 2022-03-14 | Stafford | Virginia | 51179 | 29881 | 167 |
2302010 | 2302010 | 2022-03-13 | Stafford | Kansas | 20185 | 1134 | 26 |
2304068 | 2304068 | 2022-03-13 | Stafford | Virginia | 51179 | 29884 | 166 |
2298758 | 2298758 | 2022-03-12 | Stafford | Kansas | 20185 | 1134 | 26 |
2300816 | 2300816 | 2022-03-12 | Stafford | Virginia | 51179 | 29884 | 166 |
2295506 | 2295506 | 2022-03-11 | Stafford | Kansas | 20185 | 1134 | 26 |
2297564 | 2297564 | 2022-03-11 | Stafford | Virginia | 51179 | 29884 | 166 |
2292254 | 2292254 | 2022-03-10 | Stafford | Kansas | 20185 | 1134 | 26 |
2294312 | 2294312 | 2022-03-10 | Stafford | Virginia | 51179 | 29890 | 166 |
2289002 | 2289002 | 2022-03-09 | Stafford | Kansas | 20185 | 1134 | 26 |
2291060 | 2291060 | 2022-03-09 | Stafford | Virginia | 51179 | 29863 | 166 |
2285751 | 2285751 | 2022-03-08 | Stafford | Kansas | 20185 | 1134 | 26 |
2287808 | 2287808 | 2022-03-08 | Stafford | Virginia | 51179 | 29849 | 166 |
2282499 | 2282499 | 2022-03-07 | Stafford | Kansas | 20185 | 1134 | 26 |
2284556 | 2284556 | 2022-03-07 | Stafford | Virginia | 51179 | 29834 | 166 |
2279246 | 2279246 | 2022-03-06 | Stafford | Kansas | 20185 | 1133 | 26 |
2281304 | 2281304 | 2022-03-06 | Stafford | Virginia | 51179 | 29778 | 163 |
2275993 | 2275993 | 2022-03-05 | Stafford | Kansas | 20185 | 1133 | 26 |
2278051 | 2278051 | 2022-03-05 | Stafford | Virginia | 51179 | 29778 | 163 |
2272740 | 2272740 | 2022-03-04 | Stafford | Kansas | 20185 | 1133 | 26 |
2274798 | 2274798 | 2022-03-04 | Stafford | Virginia | 51179 | 29778 | 163 |
2269488 | 2269488 | 2022-03-03 | Stafford | Kansas | 20185 | 1131 | 26 |
2271545 | 2271545 | 2022-03-03 | Stafford | Virginia | 51179 | 29756 | 163 |
2266235 | 2266235 | 2022-03-02 | Stafford | Kansas | 20185 | 1131 | 26 |
2268293 | 2268293 | 2022-03-02 | Stafford | Virginia | 51179 | 29716 | 161 |
2262984 | 2262984 | 2022-03-01 | Stafford | Kansas | 20185 | 1130 | 26 |
2265040 | 2265040 | 2022-03-01 | Stafford | Virginia | 51179 | 29681 | 161 |
2259733 | 2259733 | 2022-02-28 | Stafford | Kansas | 20185 | 1130 | 26 |
2261790 | 2261790 | 2022-02-28 | Stafford | Virginia | 51179 | 29658 | 160 |
2256482 | 2256482 | 2022-02-27 | Stafford | Kansas | 20185 | 1129 | 26 |
2258539 | 2258539 | 2022-02-27 | Stafford | Virginia | 51179 | 29621 | 155 |
2253231 | 2253231 | 2022-02-26 | Stafford | Kansas | 20185 | 1129 | 26 |
2255288 | 2255288 | 2022-02-26 | Stafford | Virginia | 51179 | 29621 | 155 |
2249980 | 2249980 | 2022-02-25 | Stafford | Kansas | 20185 | 1129 | 26 |
2252037 | 2252037 | 2022-02-25 | Stafford | Virginia | 51179 | 29621 | 155 |
2246729 | 2246729 | 2022-02-24 | Stafford | Kansas | 20185 | 1128 | 26 |
2248786 | 2248786 | 2022-02-24 | Stafford | Virginia | 51179 | 29603 | 154 |
2243478 | 2243478 | 2022-02-23 | Stafford | Kansas | 20185 | 1128 | 26 |
2245535 | 2245535 | 2022-02-23 | Stafford | Virginia | 51179 | 29570 | 153 |
2240227 | 2240227 | 2022-02-22 | Stafford | Kansas | 20185 | 1126 | 26 |
2242284 | 2242284 | 2022-02-22 | Stafford | Virginia | 51179 | 29551 | 152 |
2236976 | 2236976 | 2022-02-21 | Stafford | Kansas | 20185 | 1126 | 26 |
2239033 | 2239033 | 2022-02-21 | Stafford | Virginia | 51179 | 29494 | 149 |
2233725 | 2233725 | 2022-02-20 | Stafford | Kansas | 20185 | 1126 | 26 |
2235782 | 2235782 | 2022-02-20 | Stafford | Virginia | 51179 | 29411 | 148 |
2230474 | 2230474 | 2022-02-19 | Stafford | Kansas | 20185 | 1126 | 26 |
2232531 | 2232531 | 2022-02-19 | Stafford | Virginia | 51179 | 29411 | 148 |
2227223 | 2227223 | 2022-02-18 | Stafford | Kansas | 20185 | 1126 | 26 |
2229280 | 2229280 | 2022-02-18 | Stafford | Virginia | 51179 | 29411 | 148 |
2223972 | 2223972 | 2022-02-17 | Stafford | Kansas | 20185 | 1124 | 26 |
2226029 | 2226029 | 2022-02-17 | Stafford | Virginia | 51179 | 29368 | 148 |
2220721 | 2220721 | 2022-02-16 | Stafford | Kansas | 20185 | 1124 | 26 |
2222778 | 2222778 | 2022-02-16 | Stafford | Virginia | 51179 | 29299 | 148 |
2217470 | 2217470 | 2022-02-15 | Stafford | Kansas | 20185 | 1122 | 26 |
2219527 | 2219527 | 2022-02-15 | Stafford | Virginia | 51179 | 29247 | 146 |
2214219 | 2214219 | 2022-02-14 | Stafford | Kansas | 20185 | 1122 | 26 |
2216277 | 2216277 | 2022-02-14 | Stafford | Virginia | 51179 | 29188 | 145 |
2210967 | 2210967 | 2022-02-13 | Stafford | Kansas | 20185 | 1118 | 26 |
2213026 | 2213026 | 2022-02-13 | Stafford | Virginia | 51179 | 29040 | 141 |
2207714 | 2207714 | 2022-02-12 | Stafford | Kansas | 20185 | 1118 | 26 |
2209773 | 2209773 | 2022-02-12 | Stafford | Virginia | 51179 | 29040 | 141 |
2204461 | 2204461 | 2022-02-11 | Stafford | Kansas | 20185 | 1118 | 26 |
2206520 | 2206520 | 2022-02-11 | Stafford | Virginia | 51179 | 29040 | 141 |
2201208 | 2201208 | 2022-02-10 | Stafford | Kansas | 20185 | 1118 | 26 |
2203267 | 2203267 | 2022-02-10 | Stafford | Virginia | 51179 | 28974 | 141 |
2197954 | 2197954 | 2022-02-09 | Stafford | Kansas | 20185 | 1118 | 26 |
2200013 | 2200013 | 2022-02-09 | Stafford | Virginia | 51179 | 28902 | 141 |
2194700 | 2194700 | 2022-02-08 | Stafford | Kansas | 20185 | 1104 | 26 |
2196759 | 2196759 | 2022-02-08 | Stafford | Virginia | 51179 | 28827 | 141 |
2191446 | 2191446 | 2022-02-07 | Stafford | Kansas | 20185 | 1104 | 26 |
2193504 | 2193504 | 2022-02-07 | Stafford | Virginia | 51179 | 28748 | 138 |
2188193 | 2188193 | 2022-02-06 | Stafford | Kansas | 20185 | 1102 | 26 |
2190251 | 2190251 | 2022-02-06 | Stafford | Virginia | 51179 | 28537 | 132 |
2184940 | 2184940 | 2022-02-05 | Stafford | Kansas | 20185 | 1102 | 26 |
2186998 | 2186998 | 2022-02-05 | Stafford | Virginia | 51179 | 28537 | 132 |
2181688 | 2181688 | 2022-02-04 | Stafford | Kansas | 20185 | 1102 | 26 |
2183745 | 2183745 | 2022-02-04 | Stafford | Virginia | 51179 | 28537 | 132 |
2178437 | 2178437 | 2022-02-03 | Stafford | Kansas | 20185 | 1096 | 26 |
2180493 | 2180493 | 2022-02-03 | Stafford | Virginia | 51179 | 28427 | 128 |
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);