ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

765 rows where fips = 48403 and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Texas · 765 ✖

fips 1

  • 48403 · 765 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502409 2502409 2022-05-13 Sabine Texas 48403 1254 89
2499151 2499151 2022-05-12 Sabine Texas 48403 1254 89
2495893 2495893 2022-05-11 Sabine Texas 48403 1254 89
2492635 2492635 2022-05-10 Sabine Texas 48403 1252 89
2489377 2489377 2022-05-09 Sabine Texas 48403 1249 89
2486119 2486119 2022-05-08 Sabine Texas 48403 1248 89
2482861 2482861 2022-05-07 Sabine Texas 48403 1248 89
2479603 2479603 2022-05-06 Sabine Texas 48403 1248 89
2476345 2476345 2022-05-05 Sabine Texas 48403 1248 89
2473088 2473088 2022-05-04 Sabine Texas 48403 1248 89
2469832 2469832 2022-05-03 Sabine Texas 48403 1247 89
2466576 2466576 2022-05-02 Sabine Texas 48403 1247 89
2463321 2463321 2022-05-01 Sabine Texas 48403 1247 89
2460065 2460065 2022-04-30 Sabine Texas 48403 1247 89
2456809 2456809 2022-04-29 Sabine Texas 48403 1247 89
2453553 2453553 2022-04-28 Sabine Texas 48403 1244 89
2450297 2450297 2022-04-27 Sabine Texas 48403 1243 89
2447040 2447040 2022-04-26 Sabine Texas 48403 1243 89
2443785 2443785 2022-04-25 Sabine Texas 48403 1243 89
2440529 2440529 2022-04-24 Sabine Texas 48403 1243 89
2437273 2437273 2022-04-23 Sabine Texas 48403 1243 89
2434017 2434017 2022-04-22 Sabine Texas 48403 1243 89
2430761 2430761 2022-04-21 Sabine Texas 48403 1243 89
2427505 2427505 2022-04-20 Sabine Texas 48403 1243 89
2424249 2424249 2022-04-19 Sabine Texas 48403 1242 89
2420993 2420993 2022-04-18 Sabine Texas 48403 1242 89
2417737 2417737 2022-04-17 Sabine Texas 48403 1242 89
2414481 2414481 2022-04-16 Sabine Texas 48403 1242 89
2411225 2411225 2022-04-15 Sabine Texas 48403 1242 89
2407969 2407969 2022-04-14 Sabine Texas 48403 1242 89
2404713 2404713 2022-04-13 Sabine Texas 48403 1242 89
2401458 2401458 2022-04-12 Sabine Texas 48403 1242 88
2398203 2398203 2022-04-11 Sabine Texas 48403 1242 88
2394948 2394948 2022-04-10 Sabine Texas 48403 1242 88
2391692 2391692 2022-04-09 Sabine Texas 48403 1241 88
2388436 2388436 2022-04-08 Sabine Texas 48403 1241 88
2385181 2385181 2022-04-07 Sabine Texas 48403 1241 88
2381926 2381926 2022-04-06 Sabine Texas 48403 1241 88
2378671 2378671 2022-04-05 Sabine Texas 48403 1241 88
2375417 2375417 2022-04-04 Sabine Texas 48403 1241 88
2372165 2372165 2022-04-03 Sabine Texas 48403 1241 88
2368912 2368912 2022-04-02 Sabine Texas 48403 1240 88
2365659 2365659 2022-04-01 Sabine Texas 48403 1240 88
2362406 2362406 2022-03-31 Sabine Texas 48403 1240 88
2359152 2359152 2022-03-30 Sabine Texas 48403 1240 88
2355898 2355898 2022-03-29 Sabine Texas 48403 1239 88
2352645 2352645 2022-03-28 Sabine Texas 48403 1238 88
2349393 2349393 2022-03-27 Sabine Texas 48403 1238 88
2346140 2346140 2022-03-26 Sabine Texas 48403 1238 88
2342887 2342887 2022-03-25 Sabine Texas 48403 1238 88
2339634 2339634 2022-03-24 Sabine Texas 48403 1237 88
2336380 2336380 2022-03-23 Sabine Texas 48403 1236 88
2333126 2333126 2022-03-22 Sabine Texas 48403 1234 88
2329873 2329873 2022-03-21 Sabine Texas 48403 1234 88
2326621 2326621 2022-03-20 Sabine Texas 48403 1234 88
2323368 2323368 2022-03-19 Sabine Texas 48403 1233 88
2320114 2320114 2022-03-18 Sabine Texas 48403 1233 88
2316860 2316860 2022-03-17 Sabine Texas 48403 1232 88
2313607 2313607 2022-03-16 Sabine Texas 48403 1232 88
2310354 2310354 2022-03-15 Sabine Texas 48403 1232 88
2307101 2307101 2022-03-14 Sabine Texas 48403 1232 88
2303850 2303850 2022-03-13 Sabine Texas 48403 1232 88
2300598 2300598 2022-03-12 Sabine Texas 48403 1232 88
2297346 2297346 2022-03-11 Sabine Texas 48403 1232 88
2294094 2294094 2022-03-10 Sabine Texas 48403 1232 88
2290842 2290842 2022-03-09 Sabine Texas 48403 1231 87
2287590 2287590 2022-03-08 Sabine Texas 48403 1231 87
2284338 2284338 2022-03-07 Sabine Texas 48403 1230 87
2281086 2281086 2022-03-06 Sabine Texas 48403 1229 87
2277833 2277833 2022-03-05 Sabine Texas 48403 1229 87
2274580 2274580 2022-03-04 Sabine Texas 48403 1229 87
2271327 2271327 2022-03-03 Sabine Texas 48403 1229 86
2268075 2268075 2022-03-02 Sabine Texas 48403 1229 86
2264822 2264822 2022-03-01 Sabine Texas 48403 1229 86
2261572 2261572 2022-02-28 Sabine Texas 48403 1227 85
2258321 2258321 2022-02-27 Sabine Texas 48403 1227 85
2255070 2255070 2022-02-26 Sabine Texas 48403 1227 84
2251819 2251819 2022-02-25 Sabine Texas 48403 1227 83
2248568 2248568 2022-02-24 Sabine Texas 48403 1224 83
2245317 2245317 2022-02-23 Sabine Texas 48403 1224 83
2242066 2242066 2022-02-22 Sabine Texas 48403 1223 83
2238815 2238815 2022-02-21 Sabine Texas 48403 1222 82
2235564 2235564 2022-02-20 Sabine Texas 48403 1222 82
2232313 2232313 2022-02-19 Sabine Texas 48403 1222 82
2229062 2229062 2022-02-18 Sabine Texas 48403 1222 81
2225811 2225811 2022-02-17 Sabine Texas 48403 1222 81
2222560 2222560 2022-02-16 Sabine Texas 48403 1222 81
2219309 2219309 2022-02-15 Sabine Texas 48403 1221 81
2216058 2216058 2022-02-14 Sabine Texas 48403 1219 81
2212807 2212807 2022-02-13 Sabine Texas 48403 1218 81
2209554 2209554 2022-02-12 Sabine Texas 48403 1218 81
2206301 2206301 2022-02-11 Sabine Texas 48403 1217 80
2203048 2203048 2022-02-10 Sabine Texas 48403 1214 79
2199794 2199794 2022-02-09 Sabine Texas 48403 1213 79
2196540 2196540 2022-02-08 Sabine Texas 48403 1213 78
2193286 2193286 2022-02-07 Sabine Texas 48403 1211 78
2190032 2190032 2022-02-06 Sabine Texas 48403 1211 78
2186779 2186779 2022-02-05 Sabine Texas 48403 1204 78
2183527 2183527 2022-02-04 Sabine Texas 48403 1200 78
2180275 2180275 2022-02-03 Sabine Texas 48403 1193 78

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);