ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where fips = 48399 and state = "Texas" 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 |
---|---|---|---|---|---|---|---|
2502407 | 2502407 | 2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 |
2499149 | 2499149 | 2022-05-12 | Runnels | Texas | 48399 | 2393 | 66 |
2495891 | 2495891 | 2022-05-11 | Runnels | Texas | 48399 | 2393 | 66 |
2492633 | 2492633 | 2022-05-10 | Runnels | Texas | 48399 | 2393 | 66 |
2489375 | 2489375 | 2022-05-09 | Runnels | Texas | 48399 | 2390 | 66 |
2486117 | 2486117 | 2022-05-08 | Runnels | Texas | 48399 | 2390 | 66 |
2482859 | 2482859 | 2022-05-07 | Runnels | Texas | 48399 | 2390 | 66 |
2479601 | 2479601 | 2022-05-06 | Runnels | Texas | 48399 | 2388 | 66 |
2476343 | 2476343 | 2022-05-05 | Runnels | Texas | 48399 | 2388 | 66 |
2473086 | 2473086 | 2022-05-04 | Runnels | Texas | 48399 | 2388 | 66 |
2469830 | 2469830 | 2022-05-03 | Runnels | Texas | 48399 | 2388 | 66 |
2466574 | 2466574 | 2022-05-02 | Runnels | Texas | 48399 | 2388 | 66 |
2463319 | 2463319 | 2022-05-01 | Runnels | Texas | 48399 | 2388 | 66 |
2460063 | 2460063 | 2022-04-30 | Runnels | Texas | 48399 | 2388 | 66 |
2456807 | 2456807 | 2022-04-29 | Runnels | Texas | 48399 | 2385 | 66 |
2453551 | 2453551 | 2022-04-28 | Runnels | Texas | 48399 | 2385 | 66 |
2450295 | 2450295 | 2022-04-27 | Runnels | Texas | 48399 | 2385 | 66 |
2447038 | 2447038 | 2022-04-26 | Runnels | Texas | 48399 | 2385 | 66 |
2443783 | 2443783 | 2022-04-25 | Runnels | Texas | 48399 | 2383 | 66 |
2440527 | 2440527 | 2022-04-24 | Runnels | Texas | 48399 | 2383 | 66 |
2437271 | 2437271 | 2022-04-23 | Runnels | Texas | 48399 | 2383 | 66 |
2434015 | 2434015 | 2022-04-22 | Runnels | Texas | 48399 | 2383 | 66 |
2430759 | 2430759 | 2022-04-21 | Runnels | Texas | 48399 | 2378 | 66 |
2427503 | 2427503 | 2022-04-20 | Runnels | Texas | 48399 | 2364 | 66 |
2424247 | 2424247 | 2022-04-19 | Runnels | Texas | 48399 | 2344 | 66 |
2420991 | 2420991 | 2022-04-18 | Runnels | Texas | 48399 | 2333 | 66 |
2417735 | 2417735 | 2022-04-17 | Runnels | Texas | 48399 | 2310 | 66 |
2414479 | 2414479 | 2022-04-16 | Runnels | Texas | 48399 | 2310 | 66 |
2411223 | 2411223 | 2022-04-15 | Runnels | Texas | 48399 | 2310 | 66 |
2407967 | 2407967 | 2022-04-14 | Runnels | Texas | 48399 | 2310 | 66 |
2404711 | 2404711 | 2022-04-13 | Runnels | Texas | 48399 | 2304 | 66 |
2401456 | 2401456 | 2022-04-12 | Runnels | Texas | 48399 | 2296 | 66 |
2398201 | 2398201 | 2022-04-11 | Runnels | Texas | 48399 | 2293 | 66 |
2394946 | 2394946 | 2022-04-10 | Runnels | Texas | 48399 | 2293 | 66 |
2391690 | 2391690 | 2022-04-09 | Runnels | Texas | 48399 | 2293 | 66 |
2388434 | 2388434 | 2022-04-08 | Runnels | Texas | 48399 | 2292 | 66 |
2385179 | 2385179 | 2022-04-07 | Runnels | Texas | 48399 | 2291 | 66 |
2381924 | 2381924 | 2022-04-06 | Runnels | Texas | 48399 | 2291 | 66 |
2378669 | 2378669 | 2022-04-05 | Runnels | Texas | 48399 | 2291 | 66 |
2375415 | 2375415 | 2022-04-04 | Runnels | Texas | 48399 | 2291 | 66 |
2372163 | 2372163 | 2022-04-03 | Runnels | Texas | 48399 | 2291 | 66 |
2368910 | 2368910 | 2022-04-02 | Runnels | Texas | 48399 | 2291 | 66 |
2365657 | 2365657 | 2022-04-01 | Runnels | Texas | 48399 | 2289 | 66 |
2362404 | 2362404 | 2022-03-31 | Runnels | Texas | 48399 | 2288 | 66 |
2359150 | 2359150 | 2022-03-30 | Runnels | Texas | 48399 | 2286 | 66 |
2355896 | 2355896 | 2022-03-29 | Runnels | Texas | 48399 | 2285 | 66 |
2352643 | 2352643 | 2022-03-28 | Runnels | Texas | 48399 | 2285 | 66 |
2349391 | 2349391 | 2022-03-27 | Runnels | Texas | 48399 | 2285 | 66 |
2346138 | 2346138 | 2022-03-26 | Runnels | Texas | 48399 | 2285 | 66 |
2342885 | 2342885 | 2022-03-25 | Runnels | Texas | 48399 | 2285 | 66 |
2339632 | 2339632 | 2022-03-24 | Runnels | Texas | 48399 | 2284 | 66 |
2336378 | 2336378 | 2022-03-23 | Runnels | Texas | 48399 | 2284 | 66 |
2333124 | 2333124 | 2022-03-22 | Runnels | Texas | 48399 | 2282 | 66 |
2329871 | 2329871 | 2022-03-21 | Runnels | Texas | 48399 | 2282 | 66 |
2326619 | 2326619 | 2022-03-20 | Runnels | Texas | 48399 | 2282 | 66 |
2323366 | 2323366 | 2022-03-19 | Runnels | Texas | 48399 | 2282 | 66 |
2320112 | 2320112 | 2022-03-18 | Runnels | Texas | 48399 | 2281 | 65 |
2316858 | 2316858 | 2022-03-17 | Runnels | Texas | 48399 | 2280 | 65 |
2313605 | 2313605 | 2022-03-16 | Runnels | Texas | 48399 | 2279 | 65 |
2310352 | 2310352 | 2022-03-15 | Runnels | Texas | 48399 | 2279 | 64 |
2307099 | 2307099 | 2022-03-14 | Runnels | Texas | 48399 | 2278 | 64 |
2303848 | 2303848 | 2022-03-13 | Runnels | Texas | 48399 | 2278 | 64 |
2300596 | 2300596 | 2022-03-12 | Runnels | Texas | 48399 | 2278 | 64 |
2297344 | 2297344 | 2022-03-11 | Runnels | Texas | 48399 | 2277 | 64 |
2294092 | 2294092 | 2022-03-10 | Runnels | Texas | 48399 | 2277 | 64 |
2290840 | 2290840 | 2022-03-09 | Runnels | Texas | 48399 | 2275 | 64 |
2287588 | 2287588 | 2022-03-08 | Runnels | Texas | 48399 | 2275 | 64 |
2284336 | 2284336 | 2022-03-07 | Runnels | Texas | 48399 | 2275 | 64 |
2281084 | 2281084 | 2022-03-06 | Runnels | Texas | 48399 | 2273 | 64 |
2277831 | 2277831 | 2022-03-05 | Runnels | Texas | 48399 | 2273 | 64 |
2274578 | 2274578 | 2022-03-04 | Runnels | Texas | 48399 | 2272 | 63 |
2271325 | 2271325 | 2022-03-03 | Runnels | Texas | 48399 | 2269 | 63 |
2268073 | 2268073 | 2022-03-02 | Runnels | Texas | 48399 | 2269 | 63 |
2264820 | 2264820 | 2022-03-01 | Runnels | Texas | 48399 | 2268 | 63 |
2261570 | 2261570 | 2022-02-28 | Runnels | Texas | 48399 | 2263 | 62 |
2258319 | 2258319 | 2022-02-27 | Runnels | Texas | 48399 | 2263 | 62 |
2255068 | 2255068 | 2022-02-26 | Runnels | Texas | 48399 | 2263 | 62 |
2251817 | 2251817 | 2022-02-25 | Runnels | Texas | 48399 | 2261 | 62 |
2248566 | 2248566 | 2022-02-24 | Runnels | Texas | 48399 | 2258 | 62 |
2245315 | 2245315 | 2022-02-23 | Runnels | Texas | 48399 | 2253 | 62 |
2242064 | 2242064 | 2022-02-22 | Runnels | Texas | 48399 | 2250 | 62 |
2238813 | 2238813 | 2022-02-21 | Runnels | Texas | 48399 | 2249 | 62 |
2235562 | 2235562 | 2022-02-20 | Runnels | Texas | 48399 | 2249 | 62 |
2232311 | 2232311 | 2022-02-19 | Runnels | Texas | 48399 | 2247 | 62 |
2229060 | 2229060 | 2022-02-18 | Runnels | Texas | 48399 | 2240 | 62 |
2225809 | 2225809 | 2022-02-17 | Runnels | Texas | 48399 | 2229 | 62 |
2222558 | 2222558 | 2022-02-16 | Runnels | Texas | 48399 | 2219 | 62 |
2219307 | 2219307 | 2022-02-15 | Runnels | Texas | 48399 | 2215 | 62 |
2216056 | 2216056 | 2022-02-14 | Runnels | Texas | 48399 | 2207 | 61 |
2212805 | 2212805 | 2022-02-13 | Runnels | Texas | 48399 | 2207 | 61 |
2209552 | 2209552 | 2022-02-12 | Runnels | Texas | 48399 | 2207 | 61 |
2206299 | 2206299 | 2022-02-11 | Runnels | Texas | 48399 | 2207 | 61 |
2203046 | 2203046 | 2022-02-10 | Runnels | Texas | 48399 | 2207 | 61 |
2199792 | 2199792 | 2022-02-09 | Runnels | Texas | 48399 | 2207 | 61 |
2196538 | 2196538 | 2022-02-08 | Runnels | Texas | 48399 | 2202 | 61 |
2193284 | 2193284 | 2022-02-07 | Runnels | Texas | 48399 | 2201 | 61 |
2190030 | 2190030 | 2022-02-06 | Runnels | Texas | 48399 | 2201 | 61 |
2186777 | 2186777 | 2022-02-05 | Runnels | Texas | 48399 | 2201 | 61 |
2183525 | 2183525 | 2022-02-04 | Runnels | Texas | 48399 | 2198 | 61 |
2180273 | 2180273 | 2022-02-03 | Runnels | Texas | 48399 | 2194 | 61 |
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);