ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48273 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 |
---|---|---|---|---|---|---|---|
2502343 | 2502343 | 2022-05-13 | Kleberg | Texas | 48273 | 7304 | 147 |
2499085 | 2499085 | 2022-05-12 | Kleberg | Texas | 48273 | 7302 | 147 |
2495827 | 2495827 | 2022-05-11 | Kleberg | Texas | 48273 | 7296 | 147 |
2492569 | 2492569 | 2022-05-10 | Kleberg | Texas | 48273 | 7296 | 147 |
2489311 | 2489311 | 2022-05-09 | Kleberg | Texas | 48273 | 7295 | 147 |
2486054 | 2486054 | 2022-05-08 | Kleberg | Texas | 48273 | 7294 | 147 |
2482796 | 2482796 | 2022-05-07 | Kleberg | Texas | 48273 | 7293 | 147 |
2479538 | 2479538 | 2022-05-06 | Kleberg | Texas | 48273 | 7293 | 147 |
2476280 | 2476280 | 2022-05-05 | Kleberg | Texas | 48273 | 7291 | 147 |
2473023 | 2473023 | 2022-05-04 | Kleberg | Texas | 48273 | 7291 | 147 |
2469767 | 2469767 | 2022-05-03 | Kleberg | Texas | 48273 | 7288 | 147 |
2466511 | 2466511 | 2022-05-02 | Kleberg | Texas | 48273 | 7281 | 147 |
2463256 | 2463256 | 2022-05-01 | Kleberg | Texas | 48273 | 7281 | 147 |
2460000 | 2460000 | 2022-04-30 | Kleberg | Texas | 48273 | 7281 | 147 |
2456744 | 2456744 | 2022-04-29 | Kleberg | Texas | 48273 | 7274 | 147 |
2453488 | 2453488 | 2022-04-28 | Kleberg | Texas | 48273 | 7264 | 147 |
2450232 | 2450232 | 2022-04-27 | Kleberg | Texas | 48273 | 7259 | 147 |
2446975 | 2446975 | 2022-04-26 | Kleberg | Texas | 48273 | 7251 | 147 |
2443720 | 2443720 | 2022-04-25 | Kleberg | Texas | 48273 | 7247 | 147 |
2440464 | 2440464 | 2022-04-24 | Kleberg | Texas | 48273 | 7247 | 147 |
2437208 | 2437208 | 2022-04-23 | Kleberg | Texas | 48273 | 7247 | 147 |
2433952 | 2433952 | 2022-04-22 | Kleberg | Texas | 48273 | 7241 | 147 |
2430696 | 2430696 | 2022-04-21 | Kleberg | Texas | 48273 | 7234 | 147 |
2427440 | 2427440 | 2022-04-20 | Kleberg | Texas | 48273 | 7234 | 147 |
2424184 | 2424184 | 2022-04-19 | Kleberg | Texas | 48273 | 7230 | 147 |
2420928 | 2420928 | 2022-04-18 | Kleberg | Texas | 48273 | 7227 | 147 |
2417672 | 2417672 | 2022-04-17 | Kleberg | Texas | 48273 | 7207 | 147 |
2414416 | 2414416 | 2022-04-16 | Kleberg | Texas | 48273 | 7207 | 147 |
2411160 | 2411160 | 2022-04-15 | Kleberg | Texas | 48273 | 7207 | 147 |
2407904 | 2407904 | 2022-04-14 | Kleberg | Texas | 48273 | 7207 | 147 |
2404648 | 2404648 | 2022-04-13 | Kleberg | Texas | 48273 | 7205 | 147 |
2401393 | 2401393 | 2022-04-12 | Kleberg | Texas | 48273 | 7203 | 147 |
2398138 | 2398138 | 2022-04-11 | Kleberg | Texas | 48273 | 7203 | 147 |
2394883 | 2394883 | 2022-04-10 | Kleberg | Texas | 48273 | 7203 | 147 |
2391627 | 2391627 | 2022-04-09 | Kleberg | Texas | 48273 | 7203 | 147 |
2388371 | 2388371 | 2022-04-08 | Kleberg | Texas | 48273 | 7199 | 147 |
2385116 | 2385116 | 2022-04-07 | Kleberg | Texas | 48273 | 7199 | 146 |
2381861 | 2381861 | 2022-04-06 | Kleberg | Texas | 48273 | 7199 | 146 |
2378606 | 2378606 | 2022-04-05 | Kleberg | Texas | 48273 | 7199 | 146 |
2375352 | 2375352 | 2022-04-04 | Kleberg | Texas | 48273 | 7189 | 146 |
2372100 | 2372100 | 2022-04-03 | Kleberg | Texas | 48273 | 7189 | 146 |
2368847 | 2368847 | 2022-04-02 | Kleberg | Texas | 48273 | 7189 | 146 |
2365594 | 2365594 | 2022-04-01 | Kleberg | Texas | 48273 | 7184 | 146 |
2362341 | 2362341 | 2022-03-31 | Kleberg | Texas | 48273 | 7183 | 146 |
2359087 | 2359087 | 2022-03-30 | Kleberg | Texas | 48273 | 7181 | 146 |
2355833 | 2355833 | 2022-03-29 | Kleberg | Texas | 48273 | 7178 | 146 |
2352580 | 2352580 | 2022-03-28 | Kleberg | Texas | 48273 | 7172 | 146 |
2349328 | 2349328 | 2022-03-27 | Kleberg | Texas | 48273 | 7171 | 146 |
2346075 | 2346075 | 2022-03-26 | Kleberg | Texas | 48273 | 7171 | 146 |
2342822 | 2342822 | 2022-03-25 | Kleberg | Texas | 48273 | 7171 | 145 |
2339569 | 2339569 | 2022-03-24 | Kleberg | Texas | 48273 | 7169 | 145 |
2336315 | 2336315 | 2022-03-23 | Kleberg | Texas | 48273 | 7168 | 145 |
2333061 | 2333061 | 2022-03-22 | Kleberg | Texas | 48273 | 7167 | 145 |
2329808 | 2329808 | 2022-03-21 | Kleberg | Texas | 48273 | 7164 | 145 |
2326556 | 2326556 | 2022-03-20 | Kleberg | Texas | 48273 | 7164 | 145 |
2323303 | 2323303 | 2022-03-19 | Kleberg | Texas | 48273 | 7164 | 145 |
2320049 | 2320049 | 2022-03-18 | Kleberg | Texas | 48273 | 7162 | 145 |
2316795 | 2316795 | 2022-03-17 | Kleberg | Texas | 48273 | 7156 | 145 |
2313542 | 2313542 | 2022-03-16 | Kleberg | Texas | 48273 | 7152 | 145 |
2310289 | 2310289 | 2022-03-15 | Kleberg | Texas | 48273 | 7149 | 145 |
2307036 | 2307036 | 2022-03-14 | Kleberg | Texas | 48273 | 7148 | 144 |
2303785 | 2303785 | 2022-03-13 | Kleberg | Texas | 48273 | 7147 | 144 |
2300533 | 2300533 | 2022-03-12 | Kleberg | Texas | 48273 | 7147 | 144 |
2297281 | 2297281 | 2022-03-11 | Kleberg | Texas | 48273 | 7144 | 144 |
2294029 | 2294029 | 2022-03-10 | Kleberg | Texas | 48273 | 7138 | 144 |
2290777 | 2290777 | 2022-03-09 | Kleberg | Texas | 48273 | 7134 | 143 |
2287525 | 2287525 | 2022-03-08 | Kleberg | Texas | 48273 | 7127 | 143 |
2284273 | 2284273 | 2022-03-07 | Kleberg | Texas | 48273 | 7124 | 142 |
2281021 | 2281021 | 2022-03-06 | Kleberg | Texas | 48273 | 7124 | 142 |
2277768 | 2277768 | 2022-03-05 | Kleberg | Texas | 48273 | 7121 | 142 |
2274515 | 2274515 | 2022-03-04 | Kleberg | Texas | 48273 | 7114 | 142 |
2271262 | 2271262 | 2022-03-03 | Kleberg | Texas | 48273 | 7111 | 141 |
2268010 | 2268010 | 2022-03-02 | Kleberg | Texas | 48273 | 7091 | 141 |
2264757 | 2264757 | 2022-03-01 | Kleberg | Texas | 48273 | 7071 | 140 |
2261507 | 2261507 | 2022-02-28 | Kleberg | Texas | 48273 | 7067 | 140 |
2258256 | 2258256 | 2022-02-27 | Kleberg | Texas | 48273 | 7057 | 140 |
2255005 | 2255005 | 2022-02-26 | Kleberg | Texas | 48273 | 7055 | 140 |
2251754 | 2251754 | 2022-02-25 | Kleberg | Texas | 48273 | 7028 | 140 |
2248503 | 2248503 | 2022-02-24 | Kleberg | Texas | 48273 | 6996 | 140 |
2245252 | 2245252 | 2022-02-23 | Kleberg | Texas | 48273 | 6978 | 140 |
2242001 | 2242001 | 2022-02-22 | Kleberg | Texas | 48273 | 6932 | 140 |
2238750 | 2238750 | 2022-02-21 | Kleberg | Texas | 48273 | 6929 | 139 |
2235499 | 2235499 | 2022-02-20 | Kleberg | Texas | 48273 | 6926 | 139 |
2232248 | 2232248 | 2022-02-19 | Kleberg | Texas | 48273 | 6922 | 138 |
2228997 | 2228997 | 2022-02-18 | Kleberg | Texas | 48273 | 6900 | 137 |
2225746 | 2225746 | 2022-02-17 | Kleberg | Texas | 48273 | 6877 | 137 |
2222495 | 2222495 | 2022-02-16 | Kleberg | Texas | 48273 | 6856 | 137 |
2219244 | 2219244 | 2022-02-15 | Kleberg | Texas | 48273 | 6831 | 137 |
2215993 | 2215993 | 2022-02-14 | Kleberg | Texas | 48273 | 6812 | 137 |
2212742 | 2212742 | 2022-02-13 | Kleberg | Texas | 48273 | 6799 | 137 |
2209489 | 2209489 | 2022-02-12 | Kleberg | Texas | 48273 | 6789 | 137 |
2206236 | 2206236 | 2022-02-11 | Kleberg | Texas | 48273 | 6744 | 137 |
2202983 | 2202983 | 2022-02-10 | Kleberg | Texas | 48273 | 6701 | 137 |
2199729 | 2199729 | 2022-02-09 | Kleberg | Texas | 48273 | 6646 | 137 |
2196475 | 2196475 | 2022-02-08 | Kleberg | Texas | 48273 | 6616 | 136 |
2193221 | 2193221 | 2022-02-07 | Kleberg | Texas | 48273 | 6580 | 136 |
2189967 | 2189967 | 2022-02-06 | Kleberg | Texas | 48273 | 6549 | 136 |
2186714 | 2186714 | 2022-02-05 | Kleberg | Texas | 48273 | 6508 | 136 |
2183462 | 2183462 | 2022-02-04 | Kleberg | Texas | 48273 | 6481 | 136 |
2180210 | 2180210 | 2022-02-03 | Kleberg | Texas | 48273 | 6417 | 136 |
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);