ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
453 rows where cases = 1062 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 39
- Georgia 26
- Missouri 26
- Oklahoma 25
- Iowa 23
- Kentucky 22
- Mississippi 22
- Texas 21
- North Dakota 20
- Michigan 16
- Alabama 15
- Idaho 15
- Virginia 14
- Vermont 13
- Arkansas 11
- Florida 11
- Minnesota 11
- Louisiana 10
- Kansas 8
- Puerto Rico 8
- North Carolina 7
- South Dakota 7
- West Virginia 7
- Illinois 6
- Indiana 6
- Maine 6
- Ohio 6
- Oregon 6
- Tennessee 5
- Wyoming 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498362 | 2498362 | 2022-05-12 | Pierce | North Dakota | 38069 | 1062 | 32 |
2495104 | 2495104 | 2022-05-11 | Pierce | North Dakota | 38069 | 1062 | 32 |
2490341 | 2490341 | 2022-05-10 | Warren | Georgia | 13301 | 1062 | 30 |
2491846 | 2491846 | 2022-05-10 | Pierce | North Dakota | 38069 | 1062 | 32 |
2487084 | 2487084 | 2022-05-09 | Warren | Georgia | 13301 | 1062 | 30 |
2488588 | 2488588 | 2022-05-09 | Pierce | North Dakota | 38069 | 1062 | 32 |
2483826 | 2483826 | 2022-05-08 | Warren | Georgia | 13301 | 1062 | 30 |
2485331 | 2485331 | 2022-05-08 | Pierce | North Dakota | 38069 | 1062 | 32 |
2480568 | 2480568 | 2022-05-07 | Warren | Georgia | 13301 | 1062 | 30 |
2482073 | 2482073 | 2022-05-07 | Pierce | North Dakota | 38069 | 1062 | 32 |
2477310 | 2477310 | 2022-05-06 | Warren | Georgia | 13301 | 1062 | 30 |
2478815 | 2478815 | 2022-05-06 | Pierce | North Dakota | 38069 | 1062 | 32 |
2474052 | 2474052 | 2022-05-05 | Warren | Georgia | 13301 | 1062 | 30 |
2475557 | 2475557 | 2022-05-05 | Pierce | North Dakota | 38069 | 1062 | 32 |
2470795 | 2470795 | 2022-05-04 | Warren | Georgia | 13301 | 1062 | 30 |
2472300 | 2472300 | 2022-05-04 | Pierce | North Dakota | 38069 | 1062 | 32 |
2469044 | 2469044 | 2022-05-03 | Pierce | North Dakota | 38069 | 1062 | 32 |
2465788 | 2465788 | 2022-05-02 | Pierce | North Dakota | 38069 | 1062 | 32 |
2462533 | 2462533 | 2022-05-01 | Pierce | North Dakota | 38069 | 1062 | 32 |
2459277 | 2459277 | 2022-04-30 | Pierce | North Dakota | 38069 | 1062 | 32 |
2456021 | 2456021 | 2022-04-29 | Pierce | North Dakota | 38069 | 1062 | 32 |
2449117 | 2449117 | 2022-04-27 | Phillips | Montana | 30071 | 1062 | 28 |
2449643 | 2449643 | 2022-04-27 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2445860 | 2445860 | 2022-04-26 | Phillips | Montana | 30071 | 1062 | 28 |
2446386 | 2446386 | 2022-04-26 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2442605 | 2442605 | 2022-04-25 | Phillips | Montana | 30071 | 1062 | 28 |
2443131 | 2443131 | 2022-04-25 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2439349 | 2439349 | 2022-04-24 | Phillips | Montana | 30071 | 1062 | 28 |
2439875 | 2439875 | 2022-04-24 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2436093 | 2436093 | 2022-04-23 | Phillips | Montana | 30071 | 1062 | 28 |
2436619 | 2436619 | 2022-04-23 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2432837 | 2432837 | 2022-04-22 | Phillips | Montana | 30071 | 1062 | 28 |
2433363 | 2433363 | 2022-04-22 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2429581 | 2429581 | 2022-04-21 | Phillips | Montana | 30071 | 1062 | 28 |
2430107 | 2430107 | 2022-04-21 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2426325 | 2426325 | 2022-04-20 | Phillips | Montana | 30071 | 1062 | 28 |
2423069 | 2423069 | 2022-04-19 | Phillips | Montana | 30071 | 1062 | 28 |
2419812 | 2419812 | 2022-04-18 | Phillips | Montana | 30071 | 1062 | 28 |
2416557 | 2416557 | 2022-04-17 | Phillips | Montana | 30071 | 1062 | 28 |
2413301 | 2413301 | 2022-04-16 | Phillips | Montana | 30071 | 1062 | 28 |
2410045 | 2410045 | 2022-04-15 | Phillips | Montana | 30071 | 1062 | 28 |
2406789 | 2406789 | 2022-04-14 | Phillips | Montana | 30071 | 1062 | 28 |
2403533 | 2403533 | 2022-04-13 | Phillips | Montana | 30071 | 1062 | 28 |
2400278 | 2400278 | 2022-04-12 | Phillips | Montana | 30071 | 1062 | 28 |
2397023 | 2397023 | 2022-04-11 | Phillips | Montana | 30071 | 1062 | 28 |
2393768 | 2393768 | 2022-04-10 | Phillips | Montana | 30071 | 1062 | 28 |
2390512 | 2390512 | 2022-04-09 | Phillips | Montana | 30071 | 1062 | 28 |
2387256 | 2387256 | 2022-04-08 | Phillips | Montana | 30071 | 1062 | 28 |
2388256 | 2388256 | 2022-04-08 | Brewster | Texas | 48043 | 1062 | 29 |
2384001 | 2384001 | 2022-04-07 | Phillips | Montana | 30071 | 1062 | 28 |
2385001 | 2385001 | 2022-04-07 | Brewster | Texas | 48043 | 1062 | 29 |
2380746 | 2380746 | 2022-04-06 | Phillips | Montana | 30071 | 1062 | 28 |
2381272 | 2381272 | 2022-04-06 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2381746 | 2381746 | 2022-04-06 | Brewster | Texas | 48043 | 1062 | 29 |
2377491 | 2377491 | 2022-04-05 | Phillips | Montana | 30071 | 1062 | 28 |
2378017 | 2378017 | 2022-04-05 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2378491 | 2378491 | 2022-04-05 | Brewster | Texas | 48043 | 1062 | 29 |
2374238 | 2374238 | 2022-04-04 | Phillips | Montana | 30071 | 1062 | 28 |
2374763 | 2374763 | 2022-04-04 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2375237 | 2375237 | 2022-04-04 | Brewster | Texas | 48043 | 1062 | 29 |
2370986 | 2370986 | 2022-04-03 | Phillips | Montana | 30071 | 1062 | 28 |
2371511 | 2371511 | 2022-04-03 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2371985 | 2371985 | 2022-04-03 | Brewster | Texas | 48043 | 1062 | 29 |
2367733 | 2367733 | 2022-04-02 | Phillips | Montana | 30071 | 1062 | 28 |
2368258 | 2368258 | 2022-04-02 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2368732 | 2368732 | 2022-04-02 | Brewster | Texas | 48043 | 1062 | 29 |
2364480 | 2364480 | 2022-04-01 | Phillips | Montana | 30071 | 1062 | 28 |
2365005 | 2365005 | 2022-04-01 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2361226 | 2361226 | 2022-03-31 | Phillips | Montana | 30071 | 1062 | 28 |
2361752 | 2361752 | 2022-03-31 | Dewey | Oklahoma | 40043 | 1062 | 29 |
2357972 | 2357972 | 2022-03-30 | Phillips | Montana | 30071 | 1062 | 28 |
2338455 | 2338455 | 2022-03-24 | Phillips | Montana | 30071 | 1062 | 28 |
2335201 | 2335201 | 2022-03-23 | Phillips | Montana | 30071 | 1062 | 28 |
2325197 | 2325197 | 2022-03-20 | Unknown | Minnesota | 1062 | 210 | |
2321943 | 2321943 | 2022-03-19 | Unknown | Minnesota | 1062 | 210 | |
2318689 | 2318689 | 2022-03-18 | Unknown | Minnesota | 1062 | 210 | |
2288578 | 2288578 | 2022-03-09 | Boise | Idaho | 16015 | 1062 | 13 |
2285327 | 2285327 | 2022-03-08 | Boise | Idaho | 16015 | 1062 | 13 |
2267921 | 2267921 | 2022-03-02 | Concho | Texas | 48095 | 1062 | 11 |
2248431 | 2248431 | 2022-02-24 | Donley | Texas | 48129 | 1062 | 24 |
2219655 | 2219655 | 2022-02-15 | Florence | Wisconsin | 55037 | 1062 | 15 |
2150351 | 2150351 | 2022-01-25 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2147099 | 2147099 | 2022-01-24 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2143845 | 2143845 | 2022-01-23 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2140590 | 2140590 | 2022-01-22 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2137334 | 2137334 | 2022-01-21 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2134080 | 2134080 | 2022-01-20 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2130828 | 2130828 | 2022-01-19 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2125005 | 2125005 | 2022-01-17 | Wheeler | Texas | 48483 | 1062 | 15 |
2099615 | 2099615 | 2022-01-10 | Trinity | California | 6105 | 1062 | 19 |
2088896 | 2088896 | 2022-01-06 | Walworth | South Dakota | 46129 | 1062 | 19 |
2086125 | 2086125 | 2022-01-05 | Mathews | Virginia | 51115 | 1062 | 24 |
2062390 | 2062390 | 2021-12-29 | McHenry | North Dakota | 38049 | 1062 | 28 |
2032197 | 2032197 | 2021-12-20 | Menifee | Kentucky | 21165 | 1062 | 25 |
2026654 | 2026654 | 2021-12-18 | Ransom | North Dakota | 38073 | 1062 | 23 |
2023403 | 2023403 | 2021-12-17 | Ransom | North Dakota | 38073 | 1062 | 23 |
2014243 | 2014243 | 2021-12-14 | Bailey | Texas | 48017 | 1062 | 28 |
1986983 | 1986983 | 2021-12-06 | Norman | Minnesota | 27107 | 1062 | 10 |
1982924 | 1982924 | 2021-12-05 | Caribou | Idaho | 16029 | 1062 | 23 |
1979674 | 1979674 | 2021-12-04 | Caribou | Idaho | 16029 | 1062 | 23 |
Advanced export
JSON shape: default, array, newline-delimited
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);