ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Ottawa" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194420 | 1194420 | 2021-04-06 | Ottawa | Michigan | 26139 | 25982 | 373 |
1191171 | 1191171 | 2021-04-05 | Ottawa | Michigan | 26139 | 25765 | 372 |
1187923 | 1187923 | 2021-04-04 | Ottawa | Michigan | 26139 | 25478 | 370 |
1184676 | 1184676 | 2021-04-03 | Ottawa | Michigan | 26139 | 25478 | 370 |
1181430 | 1181430 | 2021-04-02 | Ottawa | Michigan | 26139 | 25253 | 367 |
1178183 | 1178183 | 2021-04-01 | Ottawa | Michigan | 26139 | 25045 | 365 |
1174936 | 1174936 | 2021-03-31 | Ottawa | Michigan | 26139 | 24830 | 364 |
1171689 | 1171689 | 2021-03-30 | Ottawa | Michigan | 26139 | 24619 | 364 |
1168441 | 1168441 | 2021-03-29 | Ottawa | Michigan | 26139 | 24433 | 362 |
1165193 | 1165193 | 2021-03-28 | Ottawa | Michigan | 26139 | 24182 | 361 |
1161945 | 1161945 | 2021-03-27 | Ottawa | Michigan | 26139 | 24182 | 361 |
1158697 | 1158697 | 2021-03-26 | Ottawa | Michigan | 26139 | 24049 | 360 |
1155450 | 1155450 | 2021-03-25 | Ottawa | Michigan | 26139 | 23885 | 360 |
1152203 | 1152203 | 2021-03-24 | Ottawa | Michigan | 26139 | 23722 | 360 |
1148956 | 1148956 | 2021-03-23 | Ottawa | Michigan | 26139 | 23571 | 360 |
1145709 | 1145709 | 2021-03-22 | Ottawa | Michigan | 26139 | 23477 | 360 |
1142462 | 1142462 | 2021-03-21 | Ottawa | Michigan | 26139 | 23430 | 361 |
1139215 | 1139215 | 2021-03-20 | Ottawa | Michigan | 26139 | 23371 | 361 |
1135969 | 1135969 | 2021-03-19 | Ottawa | Michigan | 26139 | 23276 | 360 |
1132723 | 1132723 | 2021-03-18 | Ottawa | Michigan | 26139 | 23208 | 360 |
1129475 | 1129475 | 2021-03-17 | Ottawa | Michigan | 26139 | 23113 | 360 |
1126228 | 1126228 | 2021-03-16 | Ottawa | Michigan | 26139 | 23008 | 360 |
1122982 | 1122982 | 2021-03-15 | Ottawa | Michigan | 26139 | 22949 | 359 |
1119735 | 1119735 | 2021-03-14 | Ottawa | Michigan | 26139 | 22887 | 359 |
1116488 | 1116488 | 2021-03-13 | Ottawa | Michigan | 26139 | 22887 | 359 |
1113242 | 1113242 | 2021-03-12 | Ottawa | Michigan | 26139 | 22834 | 358 |
1109996 | 1109996 | 2021-03-11 | Ottawa | Michigan | 26139 | 22778 | 358 |
1106750 | 1106750 | 2021-03-10 | Ottawa | Michigan | 26139 | 22706 | 357 |
1103504 | 1103504 | 2021-03-09 | Ottawa | Michigan | 26139 | 22628 | 357 |
1100258 | 1100258 | 2021-03-08 | Ottawa | Michigan | 26139 | 22651 | 357 |
1097011 | 1097011 | 2021-03-07 | Ottawa | Michigan | 26139 | 22619 | 357 |
1093764 | 1093764 | 2021-03-06 | Ottawa | Michigan | 26139 | 22595 | 357 |
1090518 | 1090518 | 2021-03-05 | Ottawa | Michigan | 26139 | 22556 | 357 |
1087273 | 1087273 | 2021-03-04 | Ottawa | Michigan | 26139 | 22516 | 356 |
1084028 | 1084028 | 2021-03-03 | Ottawa | Michigan | 26139 | 22478 | 354 |
1080782 | 1080782 | 2021-03-02 | Ottawa | Michigan | 26139 | 22428 | 353 |
1077536 | 1077536 | 2021-03-01 | Ottawa | Michigan | 26139 | 22391 | 352 |
1074290 | 1074290 | 2021-02-28 | Ottawa | Michigan | 26139 | 22368 | 352 |
1071044 | 1071044 | 2021-02-27 | Ottawa | Michigan | 26139 | 22359 | 352 |
1067799 | 1067799 | 2021-02-26 | Ottawa | Michigan | 26139 | 22322 | 350 |
1064554 | 1064554 | 2021-02-25 | Ottawa | Michigan | 26139 | 22280 | 350 |
1061310 | 1061310 | 2021-02-24 | Ottawa | Michigan | 26139 | 22246 | 347 |
1058064 | 1058064 | 2021-02-23 | Ottawa | Michigan | 26139 | 22218 | 347 |
1054818 | 1054818 | 2021-02-22 | Ottawa | Michigan | 26139 | 22166 | 347 |
1051571 | 1051571 | 2021-02-21 | Ottawa | Michigan | 26139 | 22114 | 347 |
1048324 | 1048324 | 2021-02-20 | Ottawa | Michigan | 26139 | 22106 | 347 |
1045078 | 1045078 | 2021-02-19 | Ottawa | Michigan | 26139 | 22129 | 347 |
1041833 | 1041833 | 2021-02-18 | Ottawa | Michigan | 26139 | 22087 | 347 |
1038588 | 1038588 | 2021-02-17 | Ottawa | Michigan | 26139 | 22048 | 344 |
1035343 | 1035343 | 2021-02-16 | Ottawa | Michigan | 26139 | 22013 | 344 |
1032098 | 1032098 | 2021-02-15 | Ottawa | Michigan | 26139 | 21944 | 344 |
1028851 | 1028851 | 2021-02-14 | Ottawa | Michigan | 26139 | 21908 | 344 |
1025605 | 1025605 | 2021-02-13 | Ottawa | Michigan | 26139 | 21867 | 344 |
1022360 | 1022360 | 2021-02-12 | Ottawa | Michigan | 26139 | 21839 | 344 |
1019115 | 1019115 | 2021-02-11 | Ottawa | Michigan | 26139 | 21785 | 344 |
1015870 | 1015870 | 2021-02-10 | Ottawa | Michigan | 26139 | 21729 | 341 |
1012625 | 1012625 | 2021-02-09 | Ottawa | Michigan | 26139 | 21673 | 340 |
1009380 | 1009380 | 2021-02-08 | Ottawa | Michigan | 26139 | 21633 | 338 |
1006133 | 1006133 | 2021-02-07 | Ottawa | Michigan | 26139 | 21607 | 338 |
1002887 | 1002887 | 2021-02-06 | Ottawa | Michigan | 26139 | 21571 | 338 |
999642 | 999642 | 2021-02-05 | Ottawa | Michigan | 26139 | 21535 | 337 |
996396 | 996396 | 2021-02-04 | Ottawa | Michigan | 26139 | 21486 | 337 |
993150 | 993150 | 2021-02-03 | Ottawa | Michigan | 26139 | 21411 | 336 |
989904 | 989904 | 2021-02-02 | Ottawa | Michigan | 26139 | 21370 | 336 |
986657 | 986657 | 2021-02-01 | Ottawa | Michigan | 26139 | 21288 | 335 |
983410 | 983410 | 2021-01-31 | Ottawa | Michigan | 26139 | 21288 | 334 |
980164 | 980164 | 2021-01-30 | Ottawa | Michigan | 26139 | 21255 | 334 |
976918 | 976918 | 2021-01-29 | Ottawa | Michigan | 26139 | 21204 | 330 |
973673 | 973673 | 2021-01-28 | Ottawa | Michigan | 26139 | 21144 | 329 |
970428 | 970428 | 2021-01-27 | Ottawa | Michigan | 26139 | 21058 | 327 |
967183 | 967183 | 2021-01-26 | Ottawa | Michigan | 26139 | 20960 | 327 |
963939 | 963939 | 2021-01-25 | Ottawa | Michigan | 26139 | 20877 | 325 |
960694 | 960694 | 2021-01-24 | Ottawa | Michigan | 26139 | 20776 | 324 |
957448 | 957448 | 2021-01-23 | Ottawa | Michigan | 26139 | 20776 | 324 |
954203 | 954203 | 2021-01-22 | Ottawa | Michigan | 26139 | 20715 | 317 |
950958 | 950958 | 2021-01-21 | Ottawa | Michigan | 26139 | 20626 | 317 |
947712 | 947712 | 2021-01-20 | Ottawa | Michigan | 26139 | 20512 | 312 |
944465 | 944465 | 2021-01-19 | Ottawa | Michigan | 26139 | 20473 | 312 |
941220 | 941220 | 2021-01-18 | Ottawa | Michigan | 26139 | 20367 | 311 |
937975 | 937975 | 2021-01-17 | Ottawa | Michigan | 26139 | 20285 | 308 |
934730 | 934730 | 2021-01-16 | Ottawa | Michigan | 26139 | 20239 | 308 |
931485 | 931485 | 2021-01-15 | Ottawa | Michigan | 26139 | 20112 | 307 |
928240 | 928240 | 2021-01-14 | Ottawa | Michigan | 26139 | 20050 | 307 |
924994 | 924994 | 2021-01-13 | Ottawa | Michigan | 26139 | 19926 | 304 |
921749 | 921749 | 2021-01-12 | Ottawa | Michigan | 26139 | 19781 | 302 |
918504 | 918504 | 2021-01-11 | Ottawa | Michigan | 26139 | 19712 | 297 |
915259 | 915259 | 2021-01-10 | Ottawa | Michigan | 26139 | 19552 | 296 |
912014 | 912014 | 2021-01-09 | Ottawa | Michigan | 26139 | 19552 | 296 |
908769 | 908769 | 2021-01-08 | Ottawa | Michigan | 26139 | 19437 | 291 |
905523 | 905523 | 2021-01-07 | Ottawa | Michigan | 26139 | 19314 | 290 |
902278 | 902278 | 2021-01-06 | Ottawa | Michigan | 26139 | 19160 | 287 |
899033 | 899033 | 2021-01-05 | Ottawa | Michigan | 26139 | 19104 | 285 |
895788 | 895788 | 2021-01-04 | Ottawa | Michigan | 26139 | 18997 | 281 |
892541 | 892541 | 2021-01-03 | Ottawa | Michigan | 26139 | 18869 | 277 |
889295 | 889295 | 2021-01-02 | Ottawa | Michigan | 26139 | 18732 | 277 |
886049 | 886049 | 2021-01-01 | Ottawa | Michigan | 26139 | 18732 | 272 |
882804 | 882804 | 2020-12-31 | Ottawa | Michigan | 26139 | 18640 | 272 |
879559 | 879559 | 2020-12-30 | Ottawa | Michigan | 26139 | 18516 | 272 |
876314 | 876314 | 2020-12-29 | Ottawa | Michigan | 26139 | 18346 | 271 |
873069 | 873069 | 2020-12-28 | Ottawa | Michigan | 26139 | 18265 | 264 |
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);