ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48185 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 |
---|---|---|---|---|---|---|---|
2502299 | 2502299 | 2022-05-13 | Grimes | Texas | 48185 | 8511 | 120 |
2499041 | 2499041 | 2022-05-12 | Grimes | Texas | 48185 | 8507 | 120 |
2495783 | 2495783 | 2022-05-11 | Grimes | Texas | 48185 | 8505 | 120 |
2492525 | 2492525 | 2022-05-10 | Grimes | Texas | 48185 | 8504 | 120 |
2489267 | 2489267 | 2022-05-09 | Grimes | Texas | 48185 | 8502 | 120 |
2486010 | 2486010 | 2022-05-08 | Grimes | Texas | 48185 | 8500 | 120 |
2482752 | 2482752 | 2022-05-07 | Grimes | Texas | 48185 | 8498 | 120 |
2479494 | 2479494 | 2022-05-06 | Grimes | Texas | 48185 | 8497 | 120 |
2476236 | 2476236 | 2022-05-05 | Grimes | Texas | 48185 | 8496 | 120 |
2472979 | 2472979 | 2022-05-04 | Grimes | Texas | 48185 | 8496 | 120 |
2469723 | 2469723 | 2022-05-03 | Grimes | Texas | 48185 | 8494 | 120 |
2466467 | 2466467 | 2022-05-02 | Grimes | Texas | 48185 | 8494 | 120 |
2463212 | 2463212 | 2022-05-01 | Grimes | Texas | 48185 | 8492 | 120 |
2459956 | 2459956 | 2022-04-30 | Grimes | Texas | 48185 | 8489 | 120 |
2456700 | 2456700 | 2022-04-29 | Grimes | Texas | 48185 | 8484 | 120 |
2453444 | 2453444 | 2022-04-28 | Grimes | Texas | 48185 | 8482 | 120 |
2450188 | 2450188 | 2022-04-27 | Grimes | Texas | 48185 | 8480 | 120 |
2446931 | 2446931 | 2022-04-26 | Grimes | Texas | 48185 | 8479 | 120 |
2443676 | 2443676 | 2022-04-25 | Grimes | Texas | 48185 | 8478 | 120 |
2440420 | 2440420 | 2022-04-24 | Grimes | Texas | 48185 | 8477 | 120 |
2437164 | 2437164 | 2022-04-23 | Grimes | Texas | 48185 | 8477 | 120 |
2433908 | 2433908 | 2022-04-22 | Grimes | Texas | 48185 | 8476 | 120 |
2430652 | 2430652 | 2022-04-21 | Grimes | Texas | 48185 | 8475 | 120 |
2427396 | 2427396 | 2022-04-20 | Grimes | Texas | 48185 | 8475 | 120 |
2424140 | 2424140 | 2022-04-19 | Grimes | Texas | 48185 | 8475 | 120 |
2420884 | 2420884 | 2022-04-18 | Grimes | Texas | 48185 | 8474 | 120 |
2417628 | 2417628 | 2022-04-17 | Grimes | Texas | 48185 | 8472 | 119 |
2414372 | 2414372 | 2022-04-16 | Grimes | Texas | 48185 | 8472 | 119 |
2411116 | 2411116 | 2022-04-15 | Grimes | Texas | 48185 | 8472 | 119 |
2407860 | 2407860 | 2022-04-14 | Grimes | Texas | 48185 | 8472 | 119 |
2404604 | 2404604 | 2022-04-13 | Grimes | Texas | 48185 | 8472 | 119 |
2401349 | 2401349 | 2022-04-12 | Grimes | Texas | 48185 | 8470 | 119 |
2398094 | 2398094 | 2022-04-11 | Grimes | Texas | 48185 | 8470 | 119 |
2394839 | 2394839 | 2022-04-10 | Grimes | Texas | 48185 | 8468 | 119 |
2391583 | 2391583 | 2022-04-09 | Grimes | Texas | 48185 | 8467 | 119 |
2388327 | 2388327 | 2022-04-08 | Grimes | Texas | 48185 | 8467 | 119 |
2385072 | 2385072 | 2022-04-07 | Grimes | Texas | 48185 | 8466 | 119 |
2381817 | 2381817 | 2022-04-06 | Grimes | Texas | 48185 | 8466 | 119 |
2378562 | 2378562 | 2022-04-05 | Grimes | Texas | 48185 | 8462 | 119 |
2375308 | 2375308 | 2022-04-04 | Grimes | Texas | 48185 | 8462 | 119 |
2372056 | 2372056 | 2022-04-03 | Grimes | Texas | 48185 | 8461 | 119 |
2368803 | 2368803 | 2022-04-02 | Grimes | Texas | 48185 | 8460 | 119 |
2365550 | 2365550 | 2022-04-01 | Grimes | Texas | 48185 | 8459 | 119 |
2362297 | 2362297 | 2022-03-31 | Grimes | Texas | 48185 | 8457 | 119 |
2359043 | 2359043 | 2022-03-30 | Grimes | Texas | 48185 | 8452 | 119 |
2355789 | 2355789 | 2022-03-29 | Grimes | Texas | 48185 | 8451 | 119 |
2352536 | 2352536 | 2022-03-28 | Grimes | Texas | 48185 | 8449 | 119 |
2349284 | 2349284 | 2022-03-27 | Grimes | Texas | 48185 | 8449 | 119 |
2346031 | 2346031 | 2022-03-26 | Grimes | Texas | 48185 | 8448 | 119 |
2342778 | 2342778 | 2022-03-25 | Grimes | Texas | 48185 | 8448 | 119 |
2339525 | 2339525 | 2022-03-24 | Grimes | Texas | 48185 | 8446 | 119 |
2336271 | 2336271 | 2022-03-23 | Grimes | Texas | 48185 | 8444 | 119 |
2333017 | 2333017 | 2022-03-22 | Grimes | Texas | 48185 | 8439 | 119 |
2329764 | 2329764 | 2022-03-21 | Grimes | Texas | 48185 | 8439 | 119 |
2326512 | 2326512 | 2022-03-20 | Grimes | Texas | 48185 | 8435 | 119 |
2323259 | 2323259 | 2022-03-19 | Grimes | Texas | 48185 | 8434 | 119 |
2320005 | 2320005 | 2022-03-18 | Grimes | Texas | 48185 | 8434 | 119 |
2316751 | 2316751 | 2022-03-17 | Grimes | Texas | 48185 | 8434 | 119 |
2313498 | 2313498 | 2022-03-16 | Grimes | Texas | 48185 | 8432 | 119 |
2310245 | 2310245 | 2022-03-15 | Grimes | Texas | 48185 | 8432 | 119 |
2306992 | 2306992 | 2022-03-14 | Grimes | Texas | 48185 | 8431 | 119 |
2303741 | 2303741 | 2022-03-13 | Grimes | Texas | 48185 | 8430 | 119 |
2300489 | 2300489 | 2022-03-12 | Grimes | Texas | 48185 | 8428 | 119 |
2297237 | 2297237 | 2022-03-11 | Grimes | Texas | 48185 | 8426 | 119 |
2293985 | 2293985 | 2022-03-10 | Grimes | Texas | 48185 | 8426 | 119 |
2290733 | 2290733 | 2022-03-09 | Grimes | Texas | 48185 | 8424 | 119 |
2287481 | 2287481 | 2022-03-08 | Grimes | Texas | 48185 | 8423 | 119 |
2284229 | 2284229 | 2022-03-07 | Grimes | Texas | 48185 | 8423 | 119 |
2280977 | 2280977 | 2022-03-06 | Grimes | Texas | 48185 | 8418 | 119 |
2277724 | 2277724 | 2022-03-05 | Grimes | Texas | 48185 | 8418 | 119 |
2274471 | 2274471 | 2022-03-04 | Grimes | Texas | 48185 | 8418 | 118 |
2271218 | 2271218 | 2022-03-03 | Grimes | Texas | 48185 | 8415 | 116 |
2267966 | 2267966 | 2022-03-02 | Grimes | Texas | 48185 | 8410 | 116 |
2264713 | 2264713 | 2022-03-01 | Grimes | Texas | 48185 | 8409 | 116 |
2261463 | 2261463 | 2022-02-28 | Grimes | Texas | 48185 | 8403 | 116 |
2258212 | 2258212 | 2022-02-27 | Grimes | Texas | 48185 | 8402 | 116 |
2254961 | 2254961 | 2022-02-26 | Grimes | Texas | 48185 | 8401 | 116 |
2251710 | 2251710 | 2022-02-25 | Grimes | Texas | 48185 | 8396 | 116 |
2248459 | 2248459 | 2022-02-24 | Grimes | Texas | 48185 | 8391 | 116 |
2245208 | 2245208 | 2022-02-23 | Grimes | Texas | 48185 | 8390 | 116 |
2241957 | 2241957 | 2022-02-22 | Grimes | Texas | 48185 | 8383 | 116 |
2238706 | 2238706 | 2022-02-21 | Grimes | Texas | 48185 | 8375 | 116 |
2235455 | 2235455 | 2022-02-20 | Grimes | Texas | 48185 | 8374 | 116 |
2232204 | 2232204 | 2022-02-19 | Grimes | Texas | 48185 | 8373 | 116 |
2228953 | 2228953 | 2022-02-18 | Grimes | Texas | 48185 | 8365 | 116 |
2225702 | 2225702 | 2022-02-17 | Grimes | Texas | 48185 | 8354 | 116 |
2222451 | 2222451 | 2022-02-16 | Grimes | Texas | 48185 | 8349 | 116 |
2219200 | 2219200 | 2022-02-15 | Grimes | Texas | 48185 | 8344 | 115 |
2215949 | 2215949 | 2022-02-14 | Grimes | Texas | 48185 | 8336 | 115 |
2212698 | 2212698 | 2022-02-13 | Grimes | Texas | 48185 | 8324 | 115 |
2209445 | 2209445 | 2022-02-12 | Grimes | Texas | 48185 | 8314 | 115 |
2206192 | 2206192 | 2022-02-11 | Grimes | Texas | 48185 | 8294 | 115 |
2202939 | 2202939 | 2022-02-10 | Grimes | Texas | 48185 | 8277 | 115 |
2199685 | 2199685 | 2022-02-09 | Grimes | Texas | 48185 | 8262 | 115 |
2196431 | 2196431 | 2022-02-08 | Grimes | Texas | 48185 | 8236 | 115 |
2193177 | 2193177 | 2022-02-07 | Grimes | Texas | 48185 | 8224 | 114 |
2189923 | 2189923 | 2022-02-06 | Grimes | Texas | 48185 | 8214 | 114 |
2186670 | 2186670 | 2022-02-05 | Grimes | Texas | 48185 | 8178 | 114 |
2183418 | 2183418 | 2022-02-04 | Grimes | Texas | 48185 | 8151 | 114 |
2180166 | 2180166 | 2022-02-03 | Grimes | Texas | 48185 | 8108 | 114 |
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);