ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,446 rows where county = "Logan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Oklahoma 776
- Colorado 772
- Kentucky 772
- Ohio 772
- West Virginia 770
- Illinois 762
- Arkansas 758
- Kansas 679
- North Dakota 662
- Nebraska 623
fips 10
county 1
- Logan · 7,346 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467151 | 2467151 | 2022-05-03 | Logan | Arkansas | 5083 | 5122 | 80 |
2467282 | 2467282 | 2022-05-03 | Logan | Colorado | 8075 | 7454 | 109 |
2467654 | 2467654 | 2022-05-03 | Logan | Illinois | 17107 | 9694 | 100 |
2467951 | 2467951 | 2022-05-03 | Logan | Kansas | 20109 | 843 | 13 |
2468073 | 2468073 | 2022-05-03 | Logan | Kentucky | 21141 | 8366 | 126 |
2468729 | 2468729 | 2022-05-03 | Logan | Nebraska | 31113 | 149 | 0 |
2469033 | 2469033 | 2022-05-03 | Logan | North Dakota | 38047 | 434 | 12 |
2469113 | 2469113 | 2022-05-03 | Logan | Ohio | 39091 | 10267 | 171 |
2469198 | 2469198 | 2022-05-03 | Logan | Oklahoma | 40083 | 10870 | 160 |
2470127 | 2470127 | 2022-05-03 | Logan | West Virginia | 54045 | 9672 | 186 |
2463896 | 2463896 | 2022-05-02 | Logan | Arkansas | 5083 | 5121 | 80 |
2464027 | 2464027 | 2022-05-02 | Logan | Colorado | 8075 | 7454 | 109 |
2464399 | 2464399 | 2022-05-02 | Logan | Illinois | 17107 | 9686 | 100 |
2464696 | 2464696 | 2022-05-02 | Logan | Kansas | 20109 | 843 | 13 |
2464818 | 2464818 | 2022-05-02 | Logan | Kentucky | 21141 | 8366 | 126 |
2465473 | 2465473 | 2022-05-02 | Logan | Nebraska | 31113 | 149 | 0 |
2465777 | 2465777 | 2022-05-02 | Logan | North Dakota | 38047 | 434 | 12 |
2465857 | 2465857 | 2022-05-02 | Logan | Ohio | 39091 | 10267 | 171 |
2465942 | 2465942 | 2022-05-02 | Logan | Oklahoma | 40083 | 10870 | 160 |
2466871 | 2466871 | 2022-05-02 | Logan | West Virginia | 54045 | 9663 | 185 |
2460640 | 2460640 | 2022-05-01 | Logan | Arkansas | 5083 | 5121 | 80 |
2460771 | 2460771 | 2022-05-01 | Logan | Colorado | 8075 | 7458 | 109 |
2461143 | 2461143 | 2022-05-01 | Logan | Illinois | 17107 | 9658 | 100 |
2461440 | 2461440 | 2022-05-01 | Logan | Kansas | 20109 | 843 | 13 |
2461562 | 2461562 | 2022-05-01 | Logan | Kentucky | 21141 | 8360 | 126 |
2462218 | 2462218 | 2022-05-01 | Logan | Nebraska | 31113 | 149 | 0 |
2462522 | 2462522 | 2022-05-01 | Logan | North Dakota | 38047 | 434 | 12 |
2462602 | 2462602 | 2022-05-01 | Logan | Ohio | 39091 | 10267 | 171 |
2462687 | 2462687 | 2022-05-01 | Logan | Oklahoma | 40083 | 10870 | 160 |
2463616 | 2463616 | 2022-05-01 | Logan | West Virginia | 54045 | 9642 | 185 |
2457384 | 2457384 | 2022-04-30 | Logan | Arkansas | 5083 | 5121 | 80 |
2457515 | 2457515 | 2022-04-30 | Logan | Colorado | 8075 | 7458 | 109 |
2457887 | 2457887 | 2022-04-30 | Logan | Illinois | 17107 | 9658 | 100 |
2458184 | 2458184 | 2022-04-30 | Logan | Kansas | 20109 | 843 | 13 |
2458306 | 2458306 | 2022-04-30 | Logan | Kentucky | 21141 | 8360 | 126 |
2458962 | 2458962 | 2022-04-30 | Logan | Nebraska | 31113 | 149 | 0 |
2459266 | 2459266 | 2022-04-30 | Logan | North Dakota | 38047 | 434 | 12 |
2459346 | 2459346 | 2022-04-30 | Logan | Ohio | 39091 | 10267 | 171 |
2459431 | 2459431 | 2022-04-30 | Logan | Oklahoma | 40083 | 10870 | 160 |
2460360 | 2460360 | 2022-04-30 | Logan | West Virginia | 54045 | 9642 | 185 |
2454128 | 2454128 | 2022-04-29 | Logan | Arkansas | 5083 | 5120 | 80 |
2454259 | 2454259 | 2022-04-29 | Logan | Colorado | 8075 | 7458 | 109 |
2454631 | 2454631 | 2022-04-29 | Logan | Illinois | 17107 | 9658 | 100 |
2454928 | 2454928 | 2022-04-29 | Logan | Kansas | 20109 | 843 | 13 |
2455050 | 2455050 | 2022-04-29 | Logan | Kentucky | 21141 | 8360 | 126 |
2455706 | 2455706 | 2022-04-29 | Logan | Nebraska | 31113 | 149 | 0 |
2456010 | 2456010 | 2022-04-29 | Logan | North Dakota | 38047 | 434 | 12 |
2456090 | 2456090 | 2022-04-29 | Logan | Ohio | 39091 | 10267 | 171 |
2456175 | 2456175 | 2022-04-29 | Logan | Oklahoma | 40083 | 10870 | 160 |
2457104 | 2457104 | 2022-04-29 | Logan | West Virginia | 54045 | 9642 | 185 |
2450872 | 2450872 | 2022-04-28 | Logan | Arkansas | 5083 | 5119 | 80 |
2451003 | 2451003 | 2022-04-28 | Logan | Colorado | 8075 | 7458 | 109 |
2451375 | 2451375 | 2022-04-28 | Logan | Illinois | 17107 | 9644 | 100 |
2451672 | 2451672 | 2022-04-28 | Logan | Kansas | 20109 | 841 | 13 |
2451794 | 2451794 | 2022-04-28 | Logan | Kentucky | 21141 | 8360 | 126 |
2452450 | 2452450 | 2022-04-28 | Logan | Nebraska | 31113 | 149 | 0 |
2452754 | 2452754 | 2022-04-28 | Logan | North Dakota | 38047 | 435 | 12 |
2452834 | 2452834 | 2022-04-28 | Logan | Ohio | 39091 | 10267 | 171 |
2452919 | 2452919 | 2022-04-28 | Logan | Oklahoma | 40083 | 10870 | 160 |
2453848 | 2453848 | 2022-04-28 | Logan | West Virginia | 54045 | 9637 | 185 |
2447616 | 2447616 | 2022-04-27 | Logan | Arkansas | 5083 | 5119 | 80 |
2447747 | 2447747 | 2022-04-27 | Logan | Colorado | 8075 | 7456 | 109 |
2448119 | 2448119 | 2022-04-27 | Logan | Illinois | 17107 | 9627 | 100 |
2448416 | 2448416 | 2022-04-27 | Logan | Kansas | 20109 | 841 | 13 |
2448538 | 2448538 | 2022-04-27 | Logan | Kentucky | 21141 | 8360 | 126 |
2449194 | 2449194 | 2022-04-27 | Logan | Nebraska | 31113 | 149 | 0 |
2449498 | 2449498 | 2022-04-27 | Logan | North Dakota | 38047 | 435 | 12 |
2449578 | 2449578 | 2022-04-27 | Logan | Ohio | 39091 | 10252 | 171 |
2449663 | 2449663 | 2022-04-27 | Logan | Oklahoma | 40083 | 10858 | 160 |
2450592 | 2450592 | 2022-04-27 | Logan | West Virginia | 54045 | 9626 | 185 |
2444360 | 2444360 | 2022-04-26 | Logan | Arkansas | 5083 | 5118 | 80 |
2444491 | 2444491 | 2022-04-26 | Logan | Colorado | 8075 | 7455 | 108 |
2444863 | 2444863 | 2022-04-26 | Logan | Illinois | 17107 | 9600 | 100 |
2445160 | 2445160 | 2022-04-26 | Logan | Kansas | 20109 | 841 | 13 |
2445282 | 2445282 | 2022-04-26 | Logan | Kentucky | 21141 | 8360 | 126 |
2445937 | 2445937 | 2022-04-26 | Logan | Nebraska | 31113 | 149 | 0 |
2446241 | 2446241 | 2022-04-26 | Logan | North Dakota | 38047 | 435 | 12 |
2446321 | 2446321 | 2022-04-26 | Logan | Ohio | 39091 | 10252 | 171 |
2446406 | 2446406 | 2022-04-26 | Logan | Oklahoma | 40083 | 10858 | 160 |
2447336 | 2447336 | 2022-04-26 | Logan | West Virginia | 54045 | 9616 | 185 |
2441104 | 2441104 | 2022-04-25 | Logan | Arkansas | 5083 | 5118 | 80 |
2441235 | 2441235 | 2022-04-25 | Logan | Colorado | 8075 | 7456 | 108 |
2441607 | 2441607 | 2022-04-25 | Logan | Illinois | 17107 | 9594 | 100 |
2441904 | 2441904 | 2022-04-25 | Logan | Kansas | 20109 | 841 | 13 |
2442026 | 2442026 | 2022-04-25 | Logan | Kentucky | 21141 | 8360 | 126 |
2442682 | 2442682 | 2022-04-25 | Logan | Nebraska | 31113 | 148 | 0 |
2442986 | 2442986 | 2022-04-25 | Logan | North Dakota | 38047 | 435 | 12 |
2443066 | 2443066 | 2022-04-25 | Logan | Ohio | 39091 | 10252 | 171 |
2443151 | 2443151 | 2022-04-25 | Logan | Oklahoma | 40083 | 10858 | 160 |
2444080 | 2444080 | 2022-04-25 | Logan | West Virginia | 54045 | 9614 | 183 |
2437848 | 2437848 | 2022-04-24 | Logan | Arkansas | 5083 | 5118 | 80 |
2437979 | 2437979 | 2022-04-24 | Logan | Colorado | 8075 | 7454 | 107 |
2438351 | 2438351 | 2022-04-24 | Logan | Illinois | 17107 | 9579 | 100 |
2438648 | 2438648 | 2022-04-24 | Logan | Kansas | 20109 | 841 | 13 |
2438770 | 2438770 | 2022-04-24 | Logan | Kentucky | 21141 | 8354 | 125 |
2439426 | 2439426 | 2022-04-24 | Logan | Nebraska | 31113 | 148 | 0 |
2439730 | 2439730 | 2022-04-24 | Logan | North Dakota | 38047 | 435 | 12 |
2439810 | 2439810 | 2022-04-24 | Logan | Ohio | 39091 | 10252 | 171 |
2439895 | 2439895 | 2022-04-24 | Logan | Oklahoma | 40083 | 10858 | 160 |
2440824 | 2440824 | 2022-04-24 | Logan | West Virginia | 54045 | 9599 | 183 |
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);