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

787 rows where county = "Brown" and state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Wisconsin · 787 ✖

fips 1

county 1

  • Brown · 787 ✖
Link rowid date ▲ county state fips cases deaths
2502742 2502742 2022-05-13 Brown Wisconsin 55009 85688 557
2499484 2499484 2022-05-12 Brown Wisconsin 55009 85571 557
2496226 2496226 2022-05-11 Brown Wisconsin 55009 85472 556
2492968 2492968 2022-05-10 Brown Wisconsin 55009 85368 556
2489710 2489710 2022-05-09 Brown Wisconsin 55009 85261 556
2486453 2486453 2022-05-08 Brown Wisconsin 55009 85071 556
2483195 2483195 2022-05-07 Brown Wisconsin 55009 85071 556
2479937 2479937 2022-05-06 Brown Wisconsin 55009 85071 556
2476679 2476679 2022-05-05 Brown Wisconsin 55009 84992 555
2473421 2473421 2022-05-04 Brown Wisconsin 55009 84922 555
2470164 2470164 2022-05-03 Brown Wisconsin 55009 84855 554
2466908 2466908 2022-05-02 Brown Wisconsin 55009 84794 552
2463653 2463653 2022-05-01 Brown Wisconsin 55009 84667 552
2460397 2460397 2022-04-30 Brown Wisconsin 55009 84667 552
2457141 2457141 2022-04-29 Brown Wisconsin 55009 84667 552
2453885 2453885 2022-04-28 Brown Wisconsin 55009 84607 552
2450629 2450629 2022-04-27 Brown Wisconsin 55009 84560 552
2447373 2447373 2022-04-26 Brown Wisconsin 55009 84511 553
2444117 2444117 2022-04-25 Brown Wisconsin 55009 84474 551
2440861 2440861 2022-04-24 Brown Wisconsin 55009 84380 551
2437605 2437605 2022-04-23 Brown Wisconsin 55009 84380 551
2434349 2434349 2022-04-22 Brown Wisconsin 55009 84380 551
2431093 2431093 2022-04-21 Brown Wisconsin 55009 84331 551
2427837 2427837 2022-04-20 Brown Wisconsin 55009 84291 551
2424581 2424581 2022-04-19 Brown Wisconsin 55009 84268 549
2421325 2421325 2022-04-18 Brown Wisconsin 55009 84242 549
2418069 2418069 2022-04-17 Brown Wisconsin 55009 84190 549
2414813 2414813 2022-04-16 Brown Wisconsin 55009 84190 549
2411557 2411557 2022-04-15 Brown Wisconsin 55009 84190 549
2408301 2408301 2022-04-14 Brown Wisconsin 55009 84152 549
2405045 2405045 2022-04-13 Brown Wisconsin 55009 84125 549
2401790 2401790 2022-04-12 Brown Wisconsin 55009 84093 548
2398535 2398535 2022-04-11 Brown Wisconsin 55009 84077 545
2395280 2395280 2022-04-10 Brown Wisconsin 55009 84019 545
2392024 2392024 2022-04-09 Brown Wisconsin 55009 84019 545
2388768 2388768 2022-04-08 Brown Wisconsin 55009 84019 545
2385513 2385513 2022-04-07 Brown Wisconsin 55009 83958 545
2382258 2382258 2022-04-06 Brown Wisconsin 55009 83925 545
2379003 2379003 2022-04-05 Brown Wisconsin 55009 83893 545
2375749 2375749 2022-04-04 Brown Wisconsin 55009 83877 544
2372497 2372497 2022-04-03 Brown Wisconsin 55009 83856 544
2369244 2369244 2022-04-02 Brown Wisconsin 55009 83856 544
2365991 2365991 2022-04-01 Brown Wisconsin 55009 83856 544
2362738 2362738 2022-03-31 Brown Wisconsin 55009 83846 543
2359484 2359484 2022-03-30 Brown Wisconsin 55009 83825 543
2356230 2356230 2022-03-29 Brown Wisconsin 55009 83812 543
2352977 2352977 2022-03-28 Brown Wisconsin 55009 83803 543
2349725 2349725 2022-03-27 Brown Wisconsin 55009 83784 534
2346472 2346472 2022-03-26 Brown Wisconsin 55009 83784 534
2343219 2343219 2022-03-25 Brown Wisconsin 55009 83784 534
2339966 2339966 2022-03-24 Brown Wisconsin 55009 83768 530
2336713 2336713 2022-03-23 Brown Wisconsin 55009 83750 525
2333459 2333459 2022-03-22 Brown Wisconsin 55009 83736 520
2330205 2330205 2022-03-21 Brown Wisconsin 55009 83733 512
2326953 2326953 2022-03-20 Brown Wisconsin 55009 83709 510
2323700 2323700 2022-03-19 Brown Wisconsin 55009 83709 510
2320446 2320446 2022-03-18 Brown Wisconsin 55009 83709 510
2317192 2317192 2022-03-17 Brown Wisconsin 55009 83694 505
2313939 2313939 2022-03-16 Brown Wisconsin 55009 83675 505
2310686 2310686 2022-03-15 Brown Wisconsin 55009 83647 503
2307433 2307433 2022-03-14 Brown Wisconsin 55009 83634 500
2304182 2304182 2022-03-13 Brown Wisconsin 55009 83614 499
2300930 2300930 2022-03-12 Brown Wisconsin 55009 83614 499
2297678 2297678 2022-03-11 Brown Wisconsin 55009 83614 499
2294426 2294426 2022-03-10 Brown Wisconsin 55009 83600 495
2291174 2291174 2022-03-09 Brown Wisconsin 55009 83585 495
2287922 2287922 2022-03-08 Brown Wisconsin 55009 83575 493
2284670 2284670 2022-03-07 Brown Wisconsin 55009 83557 490
2281418 2281418 2022-03-06 Brown Wisconsin 55009 83520 490
2278165 2278165 2022-03-05 Brown Wisconsin 55009 83520 490
2274912 2274912 2022-03-04 Brown Wisconsin 55009 83520 490
2271659 2271659 2022-03-03 Brown Wisconsin 55009 83498 490
2268407 2268407 2022-03-02 Brown Wisconsin 55009 83473 487
2265154 2265154 2022-03-01 Brown Wisconsin 55009 83445 481
2261904 2261904 2022-02-28 Brown Wisconsin 55009 83417 476
2258653 2258653 2022-02-27 Brown Wisconsin 55009 83339 474
2255402 2255402 2022-02-26 Brown Wisconsin 55009 83339 474
2252151 2252151 2022-02-25 Brown Wisconsin 55009 83339 474
2248900 2248900 2022-02-24 Brown Wisconsin 55009 83303 470
2245649 2245649 2022-02-23 Brown Wisconsin 55009 83266 470
2242398 2242398 2022-02-22 Brown Wisconsin 55009 83219 464
2239147 2239147 2022-02-21 Brown Wisconsin 55009 83169 464
2235896 2235896 2022-02-20 Brown Wisconsin 55009 83084 464
2232645 2232645 2022-02-19 Brown Wisconsin 55009 83084 464
2229394 2229394 2022-02-18 Brown Wisconsin 55009 83084 464
2226143 2226143 2022-02-17 Brown Wisconsin 55009 83029 464
2222892 2222892 2022-02-16 Brown Wisconsin 55009 82959 463
2219641 2219641 2022-02-15 Brown Wisconsin 55009 82915 460
2216391 2216391 2022-02-14 Brown Wisconsin 55009 82858 458
2213140 2213140 2022-02-13 Brown Wisconsin 55009 82667 455
2209887 2209887 2022-02-12 Brown Wisconsin 55009 82667 455
2206634 2206634 2022-02-11 Brown Wisconsin 55009 82667 455
2203381 2203381 2022-02-10 Brown Wisconsin 55009 82571 453
2200127 2200127 2022-02-09 Brown Wisconsin 55009 82428 449
2196873 2196873 2022-02-08 Brown Wisconsin 55009 82300 444
2193618 2193618 2022-02-07 Brown Wisconsin 55009 82199 443
2190365 2190365 2022-02-06 Brown Wisconsin 55009 81897 434
2187112 2187112 2022-02-05 Brown Wisconsin 55009 81897 434
2183859 2183859 2022-02-04 Brown Wisconsin 55009 81897 434
2180607 2180607 2022-02-03 Brown Wisconsin 55009 81603 430

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