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

665 rows where county = "Stonewall" and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Texas · 665 ✖

fips 1

county 1

  • Stonewall · 665 ✖
Link rowid date ▲ county state fips cases deaths
2502424 2502424 2022-05-13 Stonewall Texas 48433 362 7
2499166 2499166 2022-05-12 Stonewall Texas 48433 362 7
2495908 2495908 2022-05-11 Stonewall Texas 48433 362 7
2492650 2492650 2022-05-10 Stonewall Texas 48433 362 7
2489392 2489392 2022-05-09 Stonewall Texas 48433 362 7
2486134 2486134 2022-05-08 Stonewall Texas 48433 362 7
2482876 2482876 2022-05-07 Stonewall Texas 48433 362 7
2479618 2479618 2022-05-06 Stonewall Texas 48433 362 7
2476360 2476360 2022-05-05 Stonewall Texas 48433 362 7
2473103 2473103 2022-05-04 Stonewall Texas 48433 362 7
2469847 2469847 2022-05-03 Stonewall Texas 48433 362 7
2466591 2466591 2022-05-02 Stonewall Texas 48433 362 7
2463336 2463336 2022-05-01 Stonewall Texas 48433 362 7
2460080 2460080 2022-04-30 Stonewall Texas 48433 362 7
2456824 2456824 2022-04-29 Stonewall Texas 48433 359 7
2453568 2453568 2022-04-28 Stonewall Texas 48433 359 7
2450312 2450312 2022-04-27 Stonewall Texas 48433 359 7
2447055 2447055 2022-04-26 Stonewall Texas 48433 359 7
2443800 2443800 2022-04-25 Stonewall Texas 48433 359 7
2440544 2440544 2022-04-24 Stonewall Texas 48433 359 7
2437288 2437288 2022-04-23 Stonewall Texas 48433 359 7
2434032 2434032 2022-04-22 Stonewall Texas 48433 358 7
2430776 2430776 2022-04-21 Stonewall Texas 48433 358 7
2427520 2427520 2022-04-20 Stonewall Texas 48433 358 7
2424264 2424264 2022-04-19 Stonewall Texas 48433 358 7
2421008 2421008 2022-04-18 Stonewall Texas 48433 357 7
2417752 2417752 2022-04-17 Stonewall Texas 48433 357 7
2414496 2414496 2022-04-16 Stonewall Texas 48433 357 7
2411240 2411240 2022-04-15 Stonewall Texas 48433 357 7
2407984 2407984 2022-04-14 Stonewall Texas 48433 357 7
2404728 2404728 2022-04-13 Stonewall Texas 48433 356 7
2401473 2401473 2022-04-12 Stonewall Texas 48433 356 7
2398218 2398218 2022-04-11 Stonewall Texas 48433 356 7
2394963 2394963 2022-04-10 Stonewall Texas 48433 356 7
2391707 2391707 2022-04-09 Stonewall Texas 48433 356 7
2388451 2388451 2022-04-08 Stonewall Texas 48433 356 7
2385196 2385196 2022-04-07 Stonewall Texas 48433 355 7
2381941 2381941 2022-04-06 Stonewall Texas 48433 355 7
2378686 2378686 2022-04-05 Stonewall Texas 48433 355 7
2375432 2375432 2022-04-04 Stonewall Texas 48433 355 7
2372180 2372180 2022-04-03 Stonewall Texas 48433 355 7
2368927 2368927 2022-04-02 Stonewall Texas 48433 354 7
2365674 2365674 2022-04-01 Stonewall Texas 48433 354 7
2362421 2362421 2022-03-31 Stonewall Texas 48433 354 7
2359167 2359167 2022-03-30 Stonewall Texas 48433 354 7
2355913 2355913 2022-03-29 Stonewall Texas 48433 354 7
2352660 2352660 2022-03-28 Stonewall Texas 48433 354 7
2349408 2349408 2022-03-27 Stonewall Texas 48433 354 7
2346155 2346155 2022-03-26 Stonewall Texas 48433 354 7
2342902 2342902 2022-03-25 Stonewall Texas 48433 353 7
2339649 2339649 2022-03-24 Stonewall Texas 48433 352 7
2336395 2336395 2022-03-23 Stonewall Texas 48433 352 7
2333141 2333141 2022-03-22 Stonewall Texas 48433 352 7
2329888 2329888 2022-03-21 Stonewall Texas 48433 352 7
2326636 2326636 2022-03-20 Stonewall Texas 48433 352 7
2323383 2323383 2022-03-19 Stonewall Texas 48433 352 7
2320129 2320129 2022-03-18 Stonewall Texas 48433 352 7
2316875 2316875 2022-03-17 Stonewall Texas 48433 352 7
2313622 2313622 2022-03-16 Stonewall Texas 48433 352 7
2310369 2310369 2022-03-15 Stonewall Texas 48433 352 7
2307116 2307116 2022-03-14 Stonewall Texas 48433 352 7
2303865 2303865 2022-03-13 Stonewall Texas 48433 352 7
2300613 2300613 2022-03-12 Stonewall Texas 48433 352 7
2297361 2297361 2022-03-11 Stonewall Texas 48433 352 7
2294109 2294109 2022-03-10 Stonewall Texas 48433 352 7
2290857 2290857 2022-03-09 Stonewall Texas 48433 352 7
2287605 2287605 2022-03-08 Stonewall Texas 48433 352 7
2284353 2284353 2022-03-07 Stonewall Texas 48433 352 7
2281101 2281101 2022-03-06 Stonewall Texas 48433 352 7
2277848 2277848 2022-03-05 Stonewall Texas 48433 352 7
2274595 2274595 2022-03-04 Stonewall Texas 48433 352 7
2271342 2271342 2022-03-03 Stonewall Texas 48433 352 7
2268090 2268090 2022-03-02 Stonewall Texas 48433 351 7
2264837 2264837 2022-03-01 Stonewall Texas 48433 351 7
2261587 2261587 2022-02-28 Stonewall Texas 48433 351 7
2258336 2258336 2022-02-27 Stonewall Texas 48433 351 7
2255085 2255085 2022-02-26 Stonewall Texas 48433 351 7
2251834 2251834 2022-02-25 Stonewall Texas 48433 351 7
2248583 2248583 2022-02-24 Stonewall Texas 48433 349 7
2245332 2245332 2022-02-23 Stonewall Texas 48433 349 7
2242081 2242081 2022-02-22 Stonewall Texas 48433 349 7
2238830 2238830 2022-02-21 Stonewall Texas 48433 348 7
2235579 2235579 2022-02-20 Stonewall Texas 48433 346 7
2232328 2232328 2022-02-19 Stonewall Texas 48433 346 7
2229077 2229077 2022-02-18 Stonewall Texas 48433 345 7
2225826 2225826 2022-02-17 Stonewall Texas 48433 344 7
2222575 2222575 2022-02-16 Stonewall Texas 48433 343 7
2219324 2219324 2022-02-15 Stonewall Texas 48433 343 7
2216073 2216073 2022-02-14 Stonewall Texas 48433 343 7
2212822 2212822 2022-02-13 Stonewall Texas 48433 342 7
2209569 2209569 2022-02-12 Stonewall Texas 48433 341 7
2206316 2206316 2022-02-11 Stonewall Texas 48433 339 7
2203063 2203063 2022-02-10 Stonewall Texas 48433 336 7
2199809 2199809 2022-02-09 Stonewall Texas 48433 334 7
2196555 2196555 2022-02-08 Stonewall Texas 48433 334 7
2193301 2193301 2022-02-07 Stonewall Texas 48433 334 7
2190047 2190047 2022-02-06 Stonewall Texas 48433 333 7
2186794 2186794 2022-02-05 Stonewall Texas 48433 333 7
2183542 2183542 2022-02-04 Stonewall Texas 48433 331 7
2180290 2180290 2022-02-03 Stonewall Texas 48433 330 7

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