ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 48055 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502234 | 2502234 | 2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 |
2498976 | 2498976 | 2022-05-12 | Caldwell | Texas | 48055 | 14331 | 176 |
2495718 | 2495718 | 2022-05-11 | Caldwell | Texas | 48055 | 14320 | 176 |
2492460 | 2492460 | 2022-05-10 | Caldwell | Texas | 48055 | 14313 | 176 |
2489202 | 2489202 | 2022-05-09 | Caldwell | Texas | 48055 | 14306 | 176 |
2485945 | 2485945 | 2022-05-08 | Caldwell | Texas | 48055 | 14305 | 176 |
2482687 | 2482687 | 2022-05-07 | Caldwell | Texas | 48055 | 14298 | 176 |
2479429 | 2479429 | 2022-05-06 | Caldwell | Texas | 48055 | 14290 | 176 |
2476171 | 2476171 | 2022-05-05 | Caldwell | Texas | 48055 | 14285 | 176 |
2472914 | 2472914 | 2022-05-04 | Caldwell | Texas | 48055 | 14279 | 176 |
2469658 | 2469658 | 2022-05-03 | Caldwell | Texas | 48055 | 14275 | 176 |
2466402 | 2466402 | 2022-05-02 | Caldwell | Texas | 48055 | 14272 | 175 |
2463147 | 2463147 | 2022-05-01 | Caldwell | Texas | 48055 | 14268 | 175 |
2459891 | 2459891 | 2022-04-30 | Caldwell | Texas | 48055 | 14259 | 175 |
2456635 | 2456635 | 2022-04-29 | Caldwell | Texas | 48055 | 14259 | 175 |
2453379 | 2453379 | 2022-04-28 | Caldwell | Texas | 48055 | 14255 | 175 |
2450123 | 2450123 | 2022-04-27 | Caldwell | Texas | 48055 | 14251 | 175 |
2446866 | 2446866 | 2022-04-26 | Caldwell | Texas | 48055 | 14246 | 175 |
2443611 | 2443611 | 2022-04-25 | Caldwell | Texas | 48055 | 14242 | 175 |
2440355 | 2440355 | 2022-04-24 | Caldwell | Texas | 48055 | 14236 | 175 |
2437099 | 2437099 | 2022-04-23 | Caldwell | Texas | 48055 | 14232 | 175 |
2433843 | 2433843 | 2022-04-22 | Caldwell | Texas | 48055 | 14230 | 175 |
2430587 | 2430587 | 2022-04-21 | Caldwell | Texas | 48055 | 14222 | 175 |
2427331 | 2427331 | 2022-04-20 | Caldwell | Texas | 48055 | 14221 | 175 |
2424075 | 2424075 | 2022-04-19 | Caldwell | Texas | 48055 | 14219 | 175 |
2420819 | 2420819 | 2022-04-18 | Caldwell | Texas | 48055 | 14216 | 175 |
2417563 | 2417563 | 2022-04-17 | Caldwell | Texas | 48055 | 14205 | 175 |
2414307 | 2414307 | 2022-04-16 | Caldwell | Texas | 48055 | 14205 | 175 |
2411051 | 2411051 | 2022-04-15 | Caldwell | Texas | 48055 | 14205 | 175 |
2407795 | 2407795 | 2022-04-14 | Caldwell | Texas | 48055 | 14205 | 175 |
2404539 | 2404539 | 2022-04-13 | Caldwell | Texas | 48055 | 14200 | 175 |
2401284 | 2401284 | 2022-04-12 | Caldwell | Texas | 48055 | 14199 | 175 |
2398029 | 2398029 | 2022-04-11 | Caldwell | Texas | 48055 | 14195 | 175 |
2394774 | 2394774 | 2022-04-10 | Caldwell | Texas | 48055 | 14194 | 175 |
2391518 | 2391518 | 2022-04-09 | Caldwell | Texas | 48055 | 14192 | 175 |
2388262 | 2388262 | 2022-04-08 | Caldwell | Texas | 48055 | 14192 | 175 |
2385007 | 2385007 | 2022-04-07 | Caldwell | Texas | 48055 | 14188 | 175 |
2381752 | 2381752 | 2022-04-06 | Caldwell | Texas | 48055 | 14187 | 175 |
2378497 | 2378497 | 2022-04-05 | Caldwell | Texas | 48055 | 14182 | 175 |
2375243 | 2375243 | 2022-04-04 | Caldwell | Texas | 48055 | 14182 | 175 |
2371991 | 2371991 | 2022-04-03 | Caldwell | Texas | 48055 | 14179 | 175 |
2368738 | 2368738 | 2022-04-02 | Caldwell | Texas | 48055 | 14174 | 175 |
2365485 | 2365485 | 2022-04-01 | Caldwell | Texas | 48055 | 14169 | 175 |
2362232 | 2362232 | 2022-03-31 | Caldwell | Texas | 48055 | 14161 | 175 |
2358978 | 2358978 | 2022-03-30 | Caldwell | Texas | 48055 | 14160 | 175 |
2355724 | 2355724 | 2022-03-29 | Caldwell | Texas | 48055 | 14158 | 175 |
2352471 | 2352471 | 2022-03-28 | Caldwell | Texas | 48055 | 14144 | 175 |
2349219 | 2349219 | 2022-03-27 | Caldwell | Texas | 48055 | 14142 | 175 |
2345966 | 2345966 | 2022-03-26 | Caldwell | Texas | 48055 | 14142 | 175 |
2342713 | 2342713 | 2022-03-25 | Caldwell | Texas | 48055 | 14138 | 175 |
2339460 | 2339460 | 2022-03-24 | Caldwell | Texas | 48055 | 14138 | 175 |
2336206 | 2336206 | 2022-03-23 | Caldwell | Texas | 48055 | 14137 | 175 |
2332952 | 2332952 | 2022-03-22 | Caldwell | Texas | 48055 | 14132 | 175 |
2329699 | 2329699 | 2022-03-21 | Caldwell | Texas | 48055 | 14130 | 175 |
2326447 | 2326447 | 2022-03-20 | Caldwell | Texas | 48055 | 14130 | 175 |
2323194 | 2323194 | 2022-03-19 | Caldwell | Texas | 48055 | 14129 | 175 |
2319940 | 2319940 | 2022-03-18 | Caldwell | Texas | 48055 | 14128 | 175 |
2316686 | 2316686 | 2022-03-17 | Caldwell | Texas | 48055 | 14128 | 175 |
2313433 | 2313433 | 2022-03-16 | Caldwell | Texas | 48055 | 14125 | 175 |
2310180 | 2310180 | 2022-03-15 | Caldwell | Texas | 48055 | 14121 | 174 |
2306927 | 2306927 | 2022-03-14 | Caldwell | Texas | 48055 | 14115 | 174 |
2303676 | 2303676 | 2022-03-13 | Caldwell | Texas | 48055 | 14112 | 173 |
2300424 | 2300424 | 2022-03-12 | Caldwell | Texas | 48055 | 14109 | 173 |
2297172 | 2297172 | 2022-03-11 | Caldwell | Texas | 48055 | 14104 | 173 |
2293920 | 2293920 | 2022-03-10 | Caldwell | Texas | 48055 | 14091 | 173 |
2290668 | 2290668 | 2022-03-09 | Caldwell | Texas | 48055 | 14083 | 173 |
2287416 | 2287416 | 2022-03-08 | Caldwell | Texas | 48055 | 14079 | 173 |
2284164 | 2284164 | 2022-03-07 | Caldwell | Texas | 48055 | 14065 | 172 |
2280912 | 2280912 | 2022-03-06 | Caldwell | Texas | 48055 | 14062 | 172 |
2277659 | 2277659 | 2022-03-05 | Caldwell | Texas | 48055 | 14061 | 172 |
2274406 | 2274406 | 2022-03-04 | Caldwell | Texas | 48055 | 14061 | 172 |
2271153 | 2271153 | 2022-03-03 | Caldwell | Texas | 48055 | 14055 | 172 |
2267901 | 2267901 | 2022-03-02 | Caldwell | Texas | 48055 | 14051 | 172 |
2264648 | 2264648 | 2022-03-01 | Caldwell | Texas | 48055 | 14050 | 172 |
2261398 | 2261398 | 2022-02-28 | Caldwell | Texas | 48055 | 14040 | 172 |
2258147 | 2258147 | 2022-02-27 | Caldwell | Texas | 48055 | 14033 | 172 |
2254896 | 2254896 | 2022-02-26 | Caldwell | Texas | 48055 | 14029 | 172 |
2251645 | 2251645 | 2022-02-25 | Caldwell | Texas | 48055 | 14022 | 172 |
2248394 | 2248394 | 2022-02-24 | Caldwell | Texas | 48055 | 14017 | 172 |
2245143 | 2245143 | 2022-02-23 | Caldwell | Texas | 48055 | 14012 | 170 |
2241892 | 2241892 | 2022-02-22 | Caldwell | Texas | 48055 | 14006 | 170 |
2238641 | 2238641 | 2022-02-21 | Caldwell | Texas | 48055 | 13997 | 169 |
2235390 | 2235390 | 2022-02-20 | Caldwell | Texas | 48055 | 13991 | 169 |
2232139 | 2232139 | 2022-02-19 | Caldwell | Texas | 48055 | 13987 | 169 |
2228888 | 2228888 | 2022-02-18 | Caldwell | Texas | 48055 | 13977 | 169 |
2225637 | 2225637 | 2022-02-17 | Caldwell | Texas | 48055 | 13965 | 169 |
2222386 | 2222386 | 2022-02-16 | Caldwell | Texas | 48055 | 13949 | 168 |
2219135 | 2219135 | 2022-02-15 | Caldwell | Texas | 48055 | 13928 | 167 |
2215884 | 2215884 | 2022-02-14 | Caldwell | Texas | 48055 | 13903 | 167 |
2212633 | 2212633 | 2022-02-13 | Caldwell | Texas | 48055 | 13895 | 167 |
2209380 | 2209380 | 2022-02-12 | Caldwell | Texas | 48055 | 13874 | 167 |
2206127 | 2206127 | 2022-02-11 | Caldwell | Texas | 48055 | 13848 | 167 |
2202874 | 2202874 | 2022-02-10 | Caldwell | Texas | 48055 | 13795 | 167 |
2199620 | 2199620 | 2022-02-09 | Caldwell | Texas | 48055 | 13744 | 167 |
2196366 | 2196366 | 2022-02-08 | Caldwell | Texas | 48055 | 13707 | 167 |
2193112 | 2193112 | 2022-02-07 | Caldwell | Texas | 48055 | 13687 | 167 |
2189858 | 2189858 | 2022-02-06 | Caldwell | Texas | 48055 | 13671 | 167 |
2186605 | 2186605 | 2022-02-05 | Caldwell | Texas | 48055 | 13629 | 167 |
2183353 | 2183353 | 2022-02-04 | Caldwell | Texas | 48055 | 13311 | 167 |
2180101 | 2180101 | 2022-02-03 | Caldwell | Texas | 48055 | 13259 | 167 |
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);