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

6,807 rows where county = "Brown" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 9

fips 9

county 1

  • Brown · 6,807 ✖
Link rowid date ▲ county state fips cases deaths
2500181 2500181 2022-05-13 Brown Illinois 17009 2430 21
2500286 2500286 2022-05-13 Brown Indiana 18013 2608 62
2500479 2500479 2022-05-13 Brown Kansas 20013 2735 46
2500912 2500912 2022-05-13 Brown Minnesota 27015 6624 81
2501257 2501257 2022-05-13 Brown Nebraska 31017 515 4
2501651 2501651 2022-05-13 Brown Ohio 39015 11248 180
2502050 2502050 2022-05-13 Brown South Dakota 46013 10344 121
2502231 2502231 2022-05-13 Brown Texas 48049 12056 253
2502742 2502742 2022-05-13 Brown Wisconsin 55009 85688 557
2496923 2496923 2022-05-12 Brown Illinois 17009 2428 21
2497028 2497028 2022-05-12 Brown Indiana 18013 2607 62
2497221 2497221 2022-05-12 Brown Kansas 20013 2710 46
2497654 2497654 2022-05-12 Brown Minnesota 27015 6618 81
2497999 2497999 2022-05-12 Brown Nebraska 31017 512 4
2498393 2498393 2022-05-12 Brown Ohio 39015 11248 180
2498792 2498792 2022-05-12 Brown South Dakota 46013 10344 121
2498973 2498973 2022-05-12 Brown Texas 48049 12038 253
2499484 2499484 2022-05-12 Brown Wisconsin 55009 85571 557
2493665 2493665 2022-05-11 Brown Illinois 17009 2428 21
2493770 2493770 2022-05-11 Brown Indiana 18013 2607 62
2493963 2493963 2022-05-11 Brown Kansas 20013 2710 46
2494396 2494396 2022-05-11 Brown Minnesota 27015 6601 81
2494741 2494741 2022-05-11 Brown Nebraska 31017 512 4
2495135 2495135 2022-05-11 Brown Ohio 39015 11216 180
2495534 2495534 2022-05-11 Brown South Dakota 46013 10344 121
2495715 2495715 2022-05-11 Brown Texas 48049 12002 253
2496226 2496226 2022-05-11 Brown Wisconsin 55009 85472 556
2490407 2490407 2022-05-10 Brown Illinois 17009 2427 21
2490512 2490512 2022-05-10 Brown Indiana 18013 2603 62
2490705 2490705 2022-05-10 Brown Kansas 20013 2710 46
2491138 2491138 2022-05-10 Brown Minnesota 27015 6591 81
2491483 2491483 2022-05-10 Brown Nebraska 31017 523 4
2491877 2491877 2022-05-10 Brown Ohio 39015 11216 180
2492276 2492276 2022-05-10 Brown South Dakota 46013 10327 121
2492457 2492457 2022-05-10 Brown Texas 48049 11997 253
2492968 2492968 2022-05-10 Brown Wisconsin 55009 85368 556
2487150 2487150 2022-05-09 Brown Illinois 17009 2426 21
2487255 2487255 2022-05-09 Brown Indiana 18013 2603 62
2487448 2487448 2022-05-09 Brown Kansas 20013 2710 46
2487881 2487881 2022-05-09 Brown Minnesota 27015 6582 81
2488225 2488225 2022-05-09 Brown Nebraska 31017 523 4
2488619 2488619 2022-05-09 Brown Ohio 39015 11216 180
2489018 2489018 2022-05-09 Brown South Dakota 46013 10327 121
2489199 2489199 2022-05-09 Brown Texas 48049 11997 253
2489710 2489710 2022-05-09 Brown Wisconsin 55009 85261 556
2483892 2483892 2022-05-08 Brown Illinois 17009 2425 21
2483997 2483997 2022-05-08 Brown Indiana 18013 2593 62
2484190 2484190 2022-05-08 Brown Kansas 20013 2710 46
2484623 2484623 2022-05-08 Brown Minnesota 27015 6576 81
2484968 2484968 2022-05-08 Brown Nebraska 31017 523 4
2485362 2485362 2022-05-08 Brown Ohio 39015 11216 180
2485761 2485761 2022-05-08 Brown South Dakota 46013 10327 121
2485942 2485942 2022-05-08 Brown Texas 48049 11997 253
2486453 2486453 2022-05-08 Brown Wisconsin 55009 85071 556
2480634 2480634 2022-05-07 Brown Illinois 17009 2425 21
2480739 2480739 2022-05-07 Brown Indiana 18013 2593 62
2480932 2480932 2022-05-07 Brown Kansas 20013 2710 46
2481365 2481365 2022-05-07 Brown Minnesota 27015 6576 81
2481710 2481710 2022-05-07 Brown Nebraska 31017 523 4
2482104 2482104 2022-05-07 Brown Ohio 39015 11216 180
2482503 2482503 2022-05-07 Brown South Dakota 46013 10327 121
2482684 2482684 2022-05-07 Brown Texas 48049 11995 253
2483195 2483195 2022-05-07 Brown Wisconsin 55009 85071 556
2477376 2477376 2022-05-06 Brown Illinois 17009 2425 21
2477481 2477481 2022-05-06 Brown Indiana 18013 2593 62
2477674 2477674 2022-05-06 Brown Kansas 20013 2710 46
2478107 2478107 2022-05-06 Brown Minnesota 27015 6576 81
2478452 2478452 2022-05-06 Brown Nebraska 31017 523 4
2478846 2478846 2022-05-06 Brown Ohio 39015 11216 180
2479245 2479245 2022-05-06 Brown South Dakota 46013 10327 121
2479426 2479426 2022-05-06 Brown Texas 48049 11993 253
2479937 2479937 2022-05-06 Brown Wisconsin 55009 85071 556
2474118 2474118 2022-05-05 Brown Illinois 17009 2424 21
2474223 2474223 2022-05-05 Brown Indiana 18013 2593 62
2474416 2474416 2022-05-05 Brown Kansas 20013 2687 46
2474849 2474849 2022-05-05 Brown Minnesota 27015 6571 81
2475194 2475194 2022-05-05 Brown Nebraska 31017 523 4
2475588 2475588 2022-05-05 Brown Ohio 39015 11216 180
2475987 2475987 2022-05-05 Brown South Dakota 46013 10327 121
2476168 2476168 2022-05-05 Brown Texas 48049 11992 253
2476679 2476679 2022-05-05 Brown Wisconsin 55009 84992 555
2470861 2470861 2022-05-04 Brown Illinois 17009 2422 21
2470966 2470966 2022-05-04 Brown Indiana 18013 2593 62
2471159 2471159 2022-05-04 Brown Kansas 20013 2687 46
2471592 2471592 2022-05-04 Brown Minnesota 27015 6563 81
2471937 2471937 2022-05-04 Brown Nebraska 31017 523 4
2472331 2472331 2022-05-04 Brown Ohio 39015 11200 180
2472730 2472730 2022-05-04 Brown South Dakota 46013 10327 121
2472911 2472911 2022-05-04 Brown Texas 48049 11989 253
2473421 2473421 2022-05-04 Brown Wisconsin 55009 84922 555
2467605 2467605 2022-05-03 Brown Illinois 17009 2422 21
2467710 2467710 2022-05-03 Brown Indiana 18013 2593 62
2467903 2467903 2022-05-03 Brown Kansas 20013 2687 46
2468336 2468336 2022-05-03 Brown Minnesota 27015 6560 81
2468681 2468681 2022-05-03 Brown Nebraska 31017 523 4
2469075 2469075 2022-05-03 Brown Ohio 39015 11200 180
2469474 2469474 2022-05-03 Brown South Dakota 46013 10320 121
2469655 2469655 2022-05-03 Brown Texas 48049 11989 253
2470164 2470164 2022-05-03 Brown Wisconsin 55009 84855 554
2464350 2464350 2022-05-02 Brown Illinois 17009 2420 21

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