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

105 rows where date = "2021-05-15" and state = "Kansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Kansas · 105 ✖
Link rowid date ▲ county state fips cases deaths
1320644 1320644 2021-05-15 Allen Kansas 20001 1245 19
1320645 1320645 2021-05-15 Anderson Kansas 20003 837 18
1320646 1320646 2021-05-15 Atchison Kansas 20005 1632 14
1320647 1320647 2021-05-15 Barber Kansas 20007 374 6
1320648 1320648 2021-05-15 Barton Kansas 20009 2614 49
1320649 1320649 2021-05-15 Bourbon Kansas 20011 1414 26
1320650 1320650 2021-05-15 Brown Kansas 20013 1239 38
1320651 1320651 2021-05-15 Butler Kansas 20015 7554 87
1320652 1320652 2021-05-15 Chase Kansas 20017 270 3
1320653 1320653 2021-05-15 Chautauqua Kansas 20019 267 6
1320654 1320654 2021-05-15 Cherokee Kansas 20021 2486 52
1320655 1320655 2021-05-15 Cheyenne Kansas 20023 362 14
1320656 1320656 2021-05-15 Clark Kansas 20025 253 7
1320657 1320657 2021-05-15 Clay Kansas 20027 826 29
1320658 1320658 2021-05-15 Cloud Kansas 20029 985 23
1320659 1320659 2021-05-15 Coffey Kansas 20031 736 23
1320660 1320660 2021-05-15 Comanche Kansas 20033 170 9
1320661 1320661 2021-05-15 Cowley Kansas 20035 3977 108
1320662 1320662 2021-05-15 Crawford Kansas 20037 4735 83
1320663 1320663 2021-05-15 Decatur Kansas 20039 267 12
1320664 1320664 2021-05-15 Dickinson Kansas 20041 1773 45
1320665 1320665 2021-05-15 Doniphan Kansas 20043 971 23
1320666 1320666 2021-05-15 Douglas Kansas 20045 9279 87
1320667 1320667 2021-05-15 Edwards Kansas 20047 267 12
1320668 1320668 2021-05-15 Elk Kansas 20049 179 5
1320669 1320669 2021-05-15 Ellis Kansas 20051 3747 71
1320670 1320670 2021-05-15 Ellsworth Kansas 20053 1222 26
1320671 1320671 2021-05-15 Finney Kansas 20055 6065 71
1320672 1320672 2021-05-15 Ford Kansas 20057 5761 75
1320673 1320673 2021-05-15 Franklin Kansas 20059 2563 43
1320674 1320674 2021-05-15 Geary Kansas 20061 3419 40
1320675 1320675 2021-05-15 Gove Kansas 20063 386 19
1320676 1320676 2021-05-15 Graham Kansas 20065 265 9
1320677 1320677 2021-05-15 Grant Kansas 20067 978 18
1320678 1320678 2021-05-15 Gray Kansas 20069 611 14
1320679 1320679 2021-05-15 Greeley Kansas 20071 104 1
1320680 1320680 2021-05-15 Greenwood Kansas 20073 589 11
1320681 1320681 2021-05-15 Hamilton Kansas 20075 202 1
1320682 1320682 2021-05-15 Harper Kansas 20077 626 18
1320683 1320683 2021-05-15 Harvey Kansas 20079 3648 68
1320684 1320684 2021-05-15 Haskell Kansas 20081 419 9
1320685 1320685 2021-05-15 Hodgeman Kansas 20083 212 8
1320686 1320686 2021-05-15 Jackson Kansas 20085 1407 16
1320687 1320687 2021-05-15 Jefferson Kansas 20087 1729 35
1320688 1320688 2021-05-15 Jewell Kansas 20089 211 6
1320689 1320689 2021-05-15 Johnson Kansas 20091 58499 763
1320690 1320690 2021-05-15 Kearny Kansas 20093 570 10
1320691 1320691 2021-05-15 Kingman Kansas 20095 763 15
1320692 1320692 2021-05-15 Kiowa Kansas 20097 271 5
1320693 1320693 2021-05-15 Labette Kansas 20099 2743 50
1320694 1320694 2021-05-15 Lane Kansas 20101 143 7
1320695 1320695 2021-05-15 Leavenworth Kansas 20103 7232 91
1320696 1320696 2021-05-15 Lincoln Kansas 20105 263 5
1320697 1320697 2021-05-15 Linn Kansas 20107 818 12
1320698 1320698 2021-05-15 Logan Kansas 20109 289 6
1320699 1320699 2021-05-15 Lyon Kansas 20111 4287 85
1320700 1320700 2021-05-15 Marion Kansas 20115 1104 24
1320701 1320701 2021-05-15 Marshall Kansas 20117 1093 25
1320702 1320702 2021-05-15 McPherson Kansas 20113 3325 89
1320703 1320703 2021-05-15 Meade Kansas 20119 514 12
1320704 1320704 2021-05-15 Miami Kansas 20121 2755 42
1320705 1320705 2021-05-15 Mitchell Kansas 20123 562 18
1320706 1320706 2021-05-15 Montgomery Kansas 20125 3463 80
1320707 1320707 2021-05-15 Morris Kansas 20127 613 22
1320708 1320708 2021-05-15 Morton Kansas 20129 263 9
1320709 1320709 2021-05-15 Nemaha Kansas 20131 1514 55
1320710 1320710 2021-05-15 Neosho Kansas 20133 1806 35
1320711 1320711 2021-05-15 Ness Kansas 20135 372 16
1320712 1320712 2021-05-15 Norton Kansas 20137 1221 27
1320713 1320713 2021-05-15 Osage Kansas 20139 1248 25
1320714 1320714 2021-05-15 Osborne Kansas 20141 290 12
1320715 1320715 2021-05-15 Ottawa Kansas 20143 551 13
1320716 1320716 2021-05-15 Pawnee Kansas 20145 1168 13
1320717 1320717 2021-05-15 Phillips Kansas 20147 714 24
1320718 1320718 2021-05-15 Pottawatomie Kansas 20149 1900 30
1320719 1320719 2021-05-15 Pratt Kansas 20151 816 25
1320720 1320720 2021-05-15 Rawlins Kansas 20153 360 7
1320721 1320721 2021-05-15 Reno Kansas 20155 8539 139
1320722 1320722 2021-05-15 Republic Kansas 20157 680 15
1320723 1320723 2021-05-15 Rice Kansas 20159 1076 12
1320724 1320724 2021-05-15 Riley Kansas 20161 6497 43
1320725 1320725 2021-05-15 Rooks Kansas 20163 660 11
1320726 1320726 2021-05-15 Rush Kansas 20165 431 14
1320727 1320727 2021-05-15 Russell Kansas 20167 860 29
1320728 1320728 2021-05-15 Saline Kansas 20169 6270 140
1320729 1320729 2021-05-15 Scott Kansas 20171 621 24
1320730 1320730 2021-05-15 Sedgwick Kansas 20173 56770 756
1320731 1320731 2021-05-15 Seward Kansas 20175 3979 41
1320732 1320732 2021-05-15 Shawnee Kansas 20177 17505 363
1320733 1320733 2021-05-15 Sheridan Kansas 20179 432 13
1320734 1320734 2021-05-15 Sherman Kansas 20181 639 12
1320735 1320735 2021-05-15 Smith Kansas 20183 270 3
1320736 1320736 2021-05-15 Stafford Kansas 20185 352 9
1320737 1320737 2021-05-15 Stanton Kansas 20187 185 6
1320738 1320738 2021-05-15 Stevens Kansas 20189 586 10
1320739 1320739 2021-05-15 Sumner Kansas 20191 2168 51
1320740 1320740 2021-05-15 Thomas Kansas 20193 1135 20
1320741 1320741 2021-05-15 Trego Kansas 20195 407 8
1320742 1320742 2021-05-15 Wabaunsee Kansas 20197 681 14
1320743 1320743 2021-05-15 Wallace Kansas 20199 179 4

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