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

785 rows where county = "Brown", fips = 48049 and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Texas · 785 ✖

fips 1

  • 48049 · 785 ✖

county 1

  • Brown · 785 ✖
Link rowid date ▲ county state fips cases deaths
2502231 2502231 2022-05-13 Brown Texas 48049 12056 253
2498973 2498973 2022-05-12 Brown Texas 48049 12038 253
2495715 2495715 2022-05-11 Brown Texas 48049 12002 253
2492457 2492457 2022-05-10 Brown Texas 48049 11997 253
2489199 2489199 2022-05-09 Brown Texas 48049 11997 253
2485942 2485942 2022-05-08 Brown Texas 48049 11997 253
2482684 2482684 2022-05-07 Brown Texas 48049 11995 253
2479426 2479426 2022-05-06 Brown Texas 48049 11993 253
2476168 2476168 2022-05-05 Brown Texas 48049 11992 253
2472911 2472911 2022-05-04 Brown Texas 48049 11989 253
2469655 2469655 2022-05-03 Brown Texas 48049 11989 253
2466399 2466399 2022-05-02 Brown Texas 48049 11985 253
2463144 2463144 2022-05-01 Brown Texas 48049 11985 253
2459888 2459888 2022-04-30 Brown Texas 48049 11985 253
2456632 2456632 2022-04-29 Brown Texas 48049 11979 253
2453376 2453376 2022-04-28 Brown Texas 48049 11978 253
2450120 2450120 2022-04-27 Brown Texas 48049 11978 253
2446863 2446863 2022-04-26 Brown Texas 48049 11956 253
2443608 2443608 2022-04-25 Brown Texas 48049 11956 253
2440352 2440352 2022-04-24 Brown Texas 48049 11956 253
2437096 2437096 2022-04-23 Brown Texas 48049 11953 253
2433840 2433840 2022-04-22 Brown Texas 48049 11924 253
2430584 2430584 2022-04-21 Brown Texas 48049 11900 253
2427328 2427328 2022-04-20 Brown Texas 48049 11863 253
2424072 2424072 2022-04-19 Brown Texas 48049 11803 253
2420816 2420816 2022-04-18 Brown Texas 48049 11803 253
2417560 2417560 2022-04-17 Brown Texas 48049 11787 253
2414304 2414304 2022-04-16 Brown Texas 48049 11787 253
2411048 2411048 2022-04-15 Brown Texas 48049 11787 253
2407792 2407792 2022-04-14 Brown Texas 48049 11787 253
2404536 2404536 2022-04-13 Brown Texas 48049 11759 253
2401281 2401281 2022-04-12 Brown Texas 48049 11714 253
2398026 2398026 2022-04-11 Brown Texas 48049 11695 253
2394771 2394771 2022-04-10 Brown Texas 48049 11695 253
2391515 2391515 2022-04-09 Brown Texas 48049 11695 253
2388259 2388259 2022-04-08 Brown Texas 48049 11650 253
2385004 2385004 2022-04-07 Brown Texas 48049 11618 253
2381749 2381749 2022-04-06 Brown Texas 48049 11595 253
2378494 2378494 2022-04-05 Brown Texas 48049 11530 253
2375240 2375240 2022-04-04 Brown Texas 48049 11530 253
2371988 2371988 2022-04-03 Brown Texas 48049 11530 253
2368735 2368735 2022-04-02 Brown Texas 48049 11530 253
2365482 2365482 2022-04-01 Brown Texas 48049 11507 253
2362229 2362229 2022-03-31 Brown Texas 48049 11400 253
2358975 2358975 2022-03-30 Brown Texas 48049 11400 251
2355721 2355721 2022-03-29 Brown Texas 48049 11394 251
2352468 2352468 2022-03-28 Brown Texas 48049 11394 251
2349216 2349216 2022-03-27 Brown Texas 48049 11394 251
2345963 2345963 2022-03-26 Brown Texas 48049 11394 251
2342710 2342710 2022-03-25 Brown Texas 48049 11394 251
2339457 2339457 2022-03-24 Brown Texas 48049 11394 251
2336203 2336203 2022-03-23 Brown Texas 48049 11390 250
2332949 2332949 2022-03-22 Brown Texas 48049 11390 250
2329696 2329696 2022-03-21 Brown Texas 48049 11390 250
2326444 2326444 2022-03-20 Brown Texas 48049 11390 250
2323191 2323191 2022-03-19 Brown Texas 48049 11390 250
2319937 2319937 2022-03-18 Brown Texas 48049 11390 250
2316683 2316683 2022-03-17 Brown Texas 48049 11385 248
2313430 2313430 2022-03-16 Brown Texas 48049 11385 248
2310177 2310177 2022-03-15 Brown Texas 48049 11385 248
2306924 2306924 2022-03-14 Brown Texas 48049 11385 248
2303673 2303673 2022-03-13 Brown Texas 48049 11385 248
2300421 2300421 2022-03-12 Brown Texas 48049 11385 248
2297169 2297169 2022-03-11 Brown Texas 48049 11385 248
2293917 2293917 2022-03-10 Brown Texas 48049 11385 248
2290665 2290665 2022-03-09 Brown Texas 48049 11377 244
2287413 2287413 2022-03-08 Brown Texas 48049 11377 244
2284161 2284161 2022-03-07 Brown Texas 48049 11377 244
2280909 2280909 2022-03-06 Brown Texas 48049 11377 244
2277656 2277656 2022-03-05 Brown Texas 48049 11377 244
2274403 2274403 2022-03-04 Brown Texas 48049 11377 244
2271150 2271150 2022-03-03 Brown Texas 48049 11377 244
2267898 2267898 2022-03-02 Brown Texas 48049 11361 241
2264645 2264645 2022-03-01 Brown Texas 48049 11361 241
2261395 2261395 2022-02-28 Brown Texas 48049 11361 241
2258144 2258144 2022-02-27 Brown Texas 48049 11361 241
2254893 2254893 2022-02-26 Brown Texas 48049 11361 241
2251642 2251642 2022-02-25 Brown Texas 48049 11361 241
2248391 2248391 2022-02-24 Brown Texas 48049 11317 231
2245140 2245140 2022-02-23 Brown Texas 48049 11317 231
2241889 2241889 2022-02-22 Brown Texas 48049 11317 231
2238638 2238638 2022-02-21 Brown Texas 48049 11317 231
2235387 2235387 2022-02-20 Brown Texas 48049 11317 231
2232136 2232136 2022-02-19 Brown Texas 48049 11317 231
2228885 2228885 2022-02-18 Brown Texas 48049 11317 231
2225634 2225634 2022-02-17 Brown Texas 48049 11317 231
2222383 2222383 2022-02-16 Brown Texas 48049 11317 231
2219132 2219132 2022-02-15 Brown Texas 48049 11317 231
2215881 2215881 2022-02-14 Brown Texas 48049 11317 231
2212630 2212630 2022-02-13 Brown Texas 48049 11317 231
2209377 2209377 2022-02-12 Brown Texas 48049 11317 231
2206124 2206124 2022-02-11 Brown Texas 48049 11317 231
2202871 2202871 2022-02-10 Brown Texas 48049 11237 219
2199617 2199617 2022-02-09 Brown Texas 48049 11237 219
2196363 2196363 2022-02-08 Brown Texas 48049 11237 219
2193109 2193109 2022-02-07 Brown Texas 48049 11237 219
2189855 2189855 2022-02-06 Brown Texas 48049 11237 219
2186602 2186602 2022-02-05 Brown Texas 48049 11237 219
2183350 2183350 2022-02-04 Brown Texas 48049 11237 219
2180098 2180098 2022-02-03 Brown Texas 48049 10946 214

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