ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 48249 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502331 | 2502331 | 2022-05-13 | Jim Wells | Texas | 48249 | 11411 | 208 |
2499073 | 2499073 | 2022-05-12 | Jim Wells | Texas | 48249 | 11403 | 208 |
2495815 | 2495815 | 2022-05-11 | Jim Wells | Texas | 48249 | 11401 | 208 |
2492557 | 2492557 | 2022-05-10 | Jim Wells | Texas | 48249 | 11397 | 208 |
2489299 | 2489299 | 2022-05-09 | Jim Wells | Texas | 48249 | 11392 | 208 |
2486042 | 2486042 | 2022-05-08 | Jim Wells | Texas | 48249 | 11392 | 208 |
2482784 | 2482784 | 2022-05-07 | Jim Wells | Texas | 48249 | 11390 | 208 |
2479526 | 2479526 | 2022-05-06 | Jim Wells | Texas | 48249 | 11388 | 208 |
2476268 | 2476268 | 2022-05-05 | Jim Wells | Texas | 48249 | 11384 | 207 |
2473011 | 2473011 | 2022-05-04 | Jim Wells | Texas | 48249 | 11378 | 207 |
2469755 | 2469755 | 2022-05-03 | Jim Wells | Texas | 48249 | 11374 | 207 |
2466499 | 2466499 | 2022-05-02 | Jim Wells | Texas | 48249 | 11368 | 207 |
2463244 | 2463244 | 2022-05-01 | Jim Wells | Texas | 48249 | 11367 | 207 |
2459988 | 2459988 | 2022-04-30 | Jim Wells | Texas | 48249 | 11366 | 207 |
2456732 | 2456732 | 2022-04-29 | Jim Wells | Texas | 48249 | 11356 | 207 |
2453476 | 2453476 | 2022-04-28 | Jim Wells | Texas | 48249 | 11334 | 207 |
2450220 | 2450220 | 2022-04-27 | Jim Wells | Texas | 48249 | 11324 | 207 |
2446963 | 2446963 | 2022-04-26 | Jim Wells | Texas | 48249 | 11318 | 207 |
2443708 | 2443708 | 2022-04-25 | Jim Wells | Texas | 48249 | 11298 | 207 |
2440452 | 2440452 | 2022-04-24 | Jim Wells | Texas | 48249 | 11297 | 207 |
2437196 | 2437196 | 2022-04-23 | Jim Wells | Texas | 48249 | 11297 | 207 |
2433940 | 2433940 | 2022-04-22 | Jim Wells | Texas | 48249 | 11292 | 207 |
2430684 | 2430684 | 2022-04-21 | Jim Wells | Texas | 48249 | 11283 | 207 |
2427428 | 2427428 | 2022-04-20 | Jim Wells | Texas | 48249 | 11278 | 207 |
2424172 | 2424172 | 2022-04-19 | Jim Wells | Texas | 48249 | 11270 | 207 |
2420916 | 2420916 | 2022-04-18 | Jim Wells | Texas | 48249 | 11266 | 207 |
2417660 | 2417660 | 2022-04-17 | Jim Wells | Texas | 48249 | 11257 | 207 |
2414404 | 2414404 | 2022-04-16 | Jim Wells | Texas | 48249 | 11257 | 207 |
2411148 | 2411148 | 2022-04-15 | Jim Wells | Texas | 48249 | 11257 | 207 |
2407892 | 2407892 | 2022-04-14 | Jim Wells | Texas | 48249 | 11257 | 207 |
2404636 | 2404636 | 2022-04-13 | Jim Wells | Texas | 48249 | 11255 | 207 |
2401381 | 2401381 | 2022-04-12 | Jim Wells | Texas | 48249 | 11252 | 207 |
2398126 | 2398126 | 2022-04-11 | Jim Wells | Texas | 48249 | 11247 | 207 |
2394871 | 2394871 | 2022-04-10 | Jim Wells | Texas | 48249 | 11247 | 207 |
2391615 | 2391615 | 2022-04-09 | Jim Wells | Texas | 48249 | 11247 | 207 |
2388359 | 2388359 | 2022-04-08 | Jim Wells | Texas | 48249 | 11246 | 206 |
2385104 | 2385104 | 2022-04-07 | Jim Wells | Texas | 48249 | 11242 | 206 |
2381849 | 2381849 | 2022-04-06 | Jim Wells | Texas | 48249 | 11240 | 206 |
2378594 | 2378594 | 2022-04-05 | Jim Wells | Texas | 48249 | 11233 | 206 |
2375340 | 2375340 | 2022-04-04 | Jim Wells | Texas | 48249 | 11231 | 205 |
2372088 | 2372088 | 2022-04-03 | Jim Wells | Texas | 48249 | 11230 | 205 |
2368835 | 2368835 | 2022-04-02 | Jim Wells | Texas | 48249 | 11230 | 205 |
2365582 | 2365582 | 2022-04-01 | Jim Wells | Texas | 48249 | 11226 | 205 |
2362329 | 2362329 | 2022-03-31 | Jim Wells | Texas | 48249 | 11219 | 205 |
2359075 | 2359075 | 2022-03-30 | Jim Wells | Texas | 48249 | 11215 | 205 |
2355821 | 2355821 | 2022-03-29 | Jim Wells | Texas | 48249 | 11215 | 205 |
2352568 | 2352568 | 2022-03-28 | Jim Wells | Texas | 48249 | 11207 | 205 |
2349316 | 2349316 | 2022-03-27 | Jim Wells | Texas | 48249 | 11206 | 205 |
2346063 | 2346063 | 2022-03-26 | Jim Wells | Texas | 48249 | 11205 | 205 |
2342810 | 2342810 | 2022-03-25 | Jim Wells | Texas | 48249 | 11188 | 205 |
2339557 | 2339557 | 2022-03-24 | Jim Wells | Texas | 48249 | 11181 | 205 |
2336303 | 2336303 | 2022-03-23 | Jim Wells | Texas | 48249 | 11166 | 205 |
2333049 | 2333049 | 2022-03-22 | Jim Wells | Texas | 48249 | 11151 | 205 |
2329796 | 2329796 | 2022-03-21 | Jim Wells | Texas | 48249 | 11148 | 205 |
2326544 | 2326544 | 2022-03-20 | Jim Wells | Texas | 48249 | 11148 | 205 |
2323291 | 2323291 | 2022-03-19 | Jim Wells | Texas | 48249 | 11146 | 205 |
2320037 | 2320037 | 2022-03-18 | Jim Wells | Texas | 48249 | 11142 | 205 |
2316783 | 2316783 | 2022-03-17 | Jim Wells | Texas | 48249 | 11134 | 205 |
2313530 | 2313530 | 2022-03-16 | Jim Wells | Texas | 48249 | 11111 | 205 |
2310277 | 2310277 | 2022-03-15 | Jim Wells | Texas | 48249 | 11103 | 205 |
2307024 | 2307024 | 2022-03-14 | Jim Wells | Texas | 48249 | 11102 | 205 |
2303773 | 2303773 | 2022-03-13 | Jim Wells | Texas | 48249 | 11101 | 205 |
2300521 | 2300521 | 2022-03-12 | Jim Wells | Texas | 48249 | 11098 | 205 |
2297269 | 2297269 | 2022-03-11 | Jim Wells | Texas | 48249 | 11097 | 205 |
2294017 | 2294017 | 2022-03-10 | Jim Wells | Texas | 48249 | 11089 | 205 |
2290765 | 2290765 | 2022-03-09 | Jim Wells | Texas | 48249 | 11088 | 204 |
2287513 | 2287513 | 2022-03-08 | Jim Wells | Texas | 48249 | 11084 | 203 |
2284261 | 2284261 | 2022-03-07 | Jim Wells | Texas | 48249 | 11080 | 203 |
2281009 | 2281009 | 2022-03-06 | Jim Wells | Texas | 48249 | 11077 | 203 |
2277756 | 2277756 | 2022-03-05 | Jim Wells | Texas | 48249 | 11075 | 202 |
2274503 | 2274503 | 2022-03-04 | Jim Wells | Texas | 48249 | 11069 | 202 |
2271250 | 2271250 | 2022-03-03 | Jim Wells | Texas | 48249 | 11057 | 201 |
2267998 | 2267998 | 2022-03-02 | Jim Wells | Texas | 48249 | 11048 | 201 |
2264745 | 2264745 | 2022-03-01 | Jim Wells | Texas | 48249 | 11041 | 201 |
2261495 | 2261495 | 2022-02-28 | Jim Wells | Texas | 48249 | 11028 | 200 |
2258244 | 2258244 | 2022-02-27 | Jim Wells | Texas | 48249 | 11023 | 200 |
2254993 | 2254993 | 2022-02-26 | Jim Wells | Texas | 48249 | 11018 | 200 |
2251742 | 2251742 | 2022-02-25 | Jim Wells | Texas | 48249 | 11009 | 200 |
2248491 | 2248491 | 2022-02-24 | Jim Wells | Texas | 48249 | 10992 | 199 |
2245240 | 2245240 | 2022-02-23 | Jim Wells | Texas | 48249 | 10968 | 199 |
2241989 | 2241989 | 2022-02-22 | Jim Wells | Texas | 48249 | 10957 | 199 |
2238738 | 2238738 | 2022-02-21 | Jim Wells | Texas | 48249 | 10951 | 198 |
2235487 | 2235487 | 2022-02-20 | Jim Wells | Texas | 48249 | 10944 | 198 |
2232236 | 2232236 | 2022-02-19 | Jim Wells | Texas | 48249 | 10938 | 197 |
2228985 | 2228985 | 2022-02-18 | Jim Wells | Texas | 48249 | 10921 | 197 |
2225734 | 2225734 | 2022-02-17 | Jim Wells | Texas | 48249 | 10899 | 197 |
2222483 | 2222483 | 2022-02-16 | Jim Wells | Texas | 48249 | 10879 | 195 |
2219232 | 2219232 | 2022-02-15 | Jim Wells | Texas | 48249 | 10866 | 194 |
2215981 | 2215981 | 2022-02-14 | Jim Wells | Texas | 48249 | 10853 | 194 |
2212730 | 2212730 | 2022-02-13 | Jim Wells | Texas | 48249 | 10841 | 194 |
2209477 | 2209477 | 2022-02-12 | Jim Wells | Texas | 48249 | 10818 | 193 |
2206224 | 2206224 | 2022-02-11 | Jim Wells | Texas | 48249 | 10797 | 191 |
2202971 | 2202971 | 2022-02-10 | Jim Wells | Texas | 48249 | 10761 | 190 |
2199717 | 2199717 | 2022-02-09 | Jim Wells | Texas | 48249 | 10705 | 188 |
2196463 | 2196463 | 2022-02-08 | Jim Wells | Texas | 48249 | 10682 | 188 |
2193209 | 2193209 | 2022-02-07 | Jim Wells | Texas | 48249 | 10643 | 188 |
2189955 | 2189955 | 2022-02-06 | Jim Wells | Texas | 48249 | 10612 | 188 |
2186702 | 2186702 | 2022-02-05 | Jim Wells | Texas | 48249 | 10587 | 189 |
2183450 | 2183450 | 2022-02-04 | Jim Wells | Texas | 48249 | 10528 | 188 |
2180198 | 2180198 | 2022-02-03 | Jim Wells | Texas | 48249 | 10458 | 188 |
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);