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

7,446 rows where county = "Logan" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 10

fips 10

county 1

  • Logan · 7,446 ✖
Link rowid date ▲ county state fips cases deaths
2499727 2499727 2022-05-13 Logan Arkansas 5083 5130 80
2499858 2499858 2022-05-13 Logan Colorado 8075 7480 109
2500230 2500230 2022-05-13 Logan Illinois 17107 9922 100
2500527 2500527 2022-05-13 Logan Kansas 20109 844 13
2500649 2500649 2022-05-13 Logan Kentucky 21141 8369 126
2501305 2501305 2022-05-13 Logan Nebraska 31113 138 0
2501609 2501609 2022-05-13 Logan North Dakota 38047 435 12
2501689 2501689 2022-05-13 Logan Ohio 39091 10333 173
2501774 2501774 2022-05-13 Logan Oklahoma 40083 10911 160
2502705 2502705 2022-05-13 Logan West Virginia 54045 9747 186
2496469 2496469 2022-05-12 Logan Arkansas 5083 5130 80
2496600 2496600 2022-05-12 Logan Colorado 8075 7477 109
2496972 2496972 2022-05-12 Logan Illinois 17107 9896 100
2497269 2497269 2022-05-12 Logan Kansas 20109 844 13
2497391 2497391 2022-05-12 Logan Kentucky 21141 8369 126
2498047 2498047 2022-05-12 Logan Nebraska 31113 138 0
2498351 2498351 2022-05-12 Logan North Dakota 38047 436 12
2498431 2498431 2022-05-12 Logan Ohio 39091 10333 173
2498516 2498516 2022-05-12 Logan Oklahoma 40083 10911 160
2499447 2499447 2022-05-12 Logan West Virginia 54045 9737 186
2493211 2493211 2022-05-11 Logan Arkansas 5083 5129 80
2493342 2493342 2022-05-11 Logan Colorado 8075 7468 109
2493714 2493714 2022-05-11 Logan Illinois 17107 9872 100
2494011 2494011 2022-05-11 Logan Kansas 20109 844 13
2494133 2494133 2022-05-11 Logan Kentucky 21141 8369 126
2494789 2494789 2022-05-11 Logan Nebraska 31113 138 0
2495093 2495093 2022-05-11 Logan North Dakota 38047 436 12
2495173 2495173 2022-05-11 Logan Ohio 39091 10291 172
2495258 2495258 2022-05-11 Logan Oklahoma 40083 10884 160
2496189 2496189 2022-05-11 Logan West Virginia 54045 9722 186
2489953 2489953 2022-05-10 Logan Arkansas 5083 5128 80
2490084 2490084 2022-05-10 Logan Colorado 8075 7466 109
2490456 2490456 2022-05-10 Logan Illinois 17107 9839 100
2490753 2490753 2022-05-10 Logan Kansas 20109 844 13
2490875 2490875 2022-05-10 Logan Kentucky 21141 8369 126
2491531 2491531 2022-05-10 Logan Nebraska 31113 149 0
2491835 2491835 2022-05-10 Logan North Dakota 38047 436 12
2491915 2491915 2022-05-10 Logan Ohio 39091 10291 172
2492000 2492000 2022-05-10 Logan Oklahoma 40083 10884 160
2492931 2492931 2022-05-10 Logan West Virginia 54045 9706 186
2486696 2486696 2022-05-09 Logan Arkansas 5083 5127 80
2486827 2486827 2022-05-09 Logan Colorado 8075 7463 109
2487199 2487199 2022-05-09 Logan Illinois 17107 9818 100
2487496 2487496 2022-05-09 Logan Kansas 20109 844 13
2487618 2487618 2022-05-09 Logan Kentucky 21141 8369 126
2488273 2488273 2022-05-09 Logan Nebraska 31113 149 0
2488577 2488577 2022-05-09 Logan North Dakota 38047 436 12
2488657 2488657 2022-05-09 Logan Ohio 39091 10291 172
2488742 2488742 2022-05-09 Logan Oklahoma 40083 10884 160
2489673 2489673 2022-05-09 Logan West Virginia 54045 9706 186
2483438 2483438 2022-05-08 Logan Arkansas 5083 5126 80
2483569 2483569 2022-05-08 Logan Colorado 8075 7458 109
2483941 2483941 2022-05-08 Logan Illinois 17107 9767 100
2484238 2484238 2022-05-08 Logan Kansas 20109 844 13
2484360 2484360 2022-05-08 Logan Kentucky 21141 8366 126
2485016 2485016 2022-05-08 Logan Nebraska 31113 149 0
2485320 2485320 2022-05-08 Logan North Dakota 38047 436 12
2485400 2485400 2022-05-08 Logan Ohio 39091 10291 172
2485485 2485485 2022-05-08 Logan Oklahoma 40083 10884 160
2486416 2486416 2022-05-08 Logan West Virginia 54045 9695 186
2480180 2480180 2022-05-07 Logan Arkansas 5083 5126 80
2480311 2480311 2022-05-07 Logan Colorado 8075 7458 109
2480683 2480683 2022-05-07 Logan Illinois 17107 9767 100
2480980 2480980 2022-05-07 Logan Kansas 20109 844 13
2481102 2481102 2022-05-07 Logan Kentucky 21141 8366 126
2481758 2481758 2022-05-07 Logan Nebraska 31113 149 0
2482062 2482062 2022-05-07 Logan North Dakota 38047 436 12
2482142 2482142 2022-05-07 Logan Ohio 39091 10291 172
2482227 2482227 2022-05-07 Logan Oklahoma 40083 10884 160
2483158 2483158 2022-05-07 Logan West Virginia 54045 9695 186
2476922 2476922 2022-05-06 Logan Arkansas 5083 5126 80
2477053 2477053 2022-05-06 Logan Colorado 8075 7458 109
2477425 2477425 2022-05-06 Logan Illinois 17107 9767 100
2477722 2477722 2022-05-06 Logan Kansas 20109 844 13
2477844 2477844 2022-05-06 Logan Kentucky 21141 8366 126
2478500 2478500 2022-05-06 Logan Nebraska 31113 149 0
2478804 2478804 2022-05-06 Logan North Dakota 38047 436 12
2478884 2478884 2022-05-06 Logan Ohio 39091 10291 172
2478969 2478969 2022-05-06 Logan Oklahoma 40083 10884 160
2479900 2479900 2022-05-06 Logan West Virginia 54045 9695 186
2473664 2473664 2022-05-05 Logan Arkansas 5083 5124 80
2473795 2473795 2022-05-05 Logan Colorado 8075 7455 109
2474167 2474167 2022-05-05 Logan Illinois 17107 9731 100
2474464 2474464 2022-05-05 Logan Kansas 20109 843 13
2474586 2474586 2022-05-05 Logan Kentucky 21141 8366 126
2475242 2475242 2022-05-05 Logan Nebraska 31113 149 0
2475546 2475546 2022-05-05 Logan North Dakota 38047 434 12
2475626 2475626 2022-05-05 Logan Ohio 39091 10291 172
2475711 2475711 2022-05-05 Logan Oklahoma 40083 10884 160
2476642 2476642 2022-05-05 Logan West Virginia 54045 9685 186
2470407 2470407 2022-05-04 Logan Arkansas 5083 5122 80
2470538 2470538 2022-05-04 Logan Colorado 8075 7454 109
2470910 2470910 2022-05-04 Logan Illinois 17107 9714 100
2471207 2471207 2022-05-04 Logan Kansas 20109 843 13
2471329 2471329 2022-05-04 Logan Kentucky 21141 8366 126
2471985 2471985 2022-05-04 Logan Nebraska 31113 149 0
2472289 2472289 2022-05-04 Logan North Dakota 38047 434 12
2472369 2472369 2022-05-04 Logan Ohio 39091 10267 171
2472454 2472454 2022-05-04 Logan Oklahoma 40083 10870 160
2473384 2473384 2022-05-04 Logan West Virginia 54045 9680 186

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