ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8101 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277839 | 1277839 | 2021-05-02 | Pueblo | Colorado | 8101 | 17982 | 377 |
1274592 | 1274592 | 2021-05-01 | Pueblo | Colorado | 8101 | 17906 | 377 |
1271345 | 1271345 | 2021-04-30 | Pueblo | Colorado | 8101 | 17799 | 376 |
1268098 | 1268098 | 2021-04-29 | Pueblo | Colorado | 8101 | 17717 | 374 |
1264851 | 1264851 | 2021-04-28 | Pueblo | Colorado | 8101 | 17563 | 371 |
1261604 | 1261604 | 2021-04-27 | Pueblo | Colorado | 8101 | 17475 | 371 |
1258357 | 1258357 | 2021-04-26 | Pueblo | Colorado | 8101 | 17382 | 369 |
1255110 | 1255110 | 2021-04-25 | Pueblo | Colorado | 8101 | 17382 | 369 |
1251863 | 1251863 | 2021-04-24 | Pueblo | Colorado | 8101 | 17316 | 369 |
1248616 | 1248616 | 2021-04-23 | Pueblo | Colorado | 8101 | 17218 | 367 |
1245369 | 1245369 | 2021-04-22 | Pueblo | Colorado | 8101 | 17135 | 367 |
1242122 | 1242122 | 2021-04-21 | Pueblo | Colorado | 8101 | 16978 | 367 |
1238875 | 1238875 | 2021-04-20 | Pueblo | Colorado | 8101 | 16921 | 366 |
1235628 | 1235628 | 2021-04-19 | Pueblo | Colorado | 8101 | 16867 | 365 |
1232381 | 1232381 | 2021-04-18 | Pueblo | Colorado | 8101 | 16825 | 365 |
1229132 | 1229132 | 2021-04-17 | Pueblo | Colorado | 8101 | 16788 | 365 |
1225884 | 1225884 | 2021-04-16 | Pueblo | Colorado | 8101 | 16716 | 365 |
1222637 | 1222637 | 2021-04-15 | Pueblo | Colorado | 8101 | 16640 | 365 |
1219389 | 1219389 | 2021-04-14 | Pueblo | Colorado | 8101 | 16607 | 366 |
1216141 | 1216141 | 2021-04-13 | Pueblo | Colorado | 8101 | 16540 | 366 |
1212894 | 1212894 | 2021-04-12 | Pueblo | Colorado | 8101 | 16449 | 366 |
1209646 | 1209646 | 2021-04-11 | Pueblo | Colorado | 8101 | 16399 | 366 |
1206397 | 1206397 | 2021-04-10 | Pueblo | Colorado | 8101 | 16338 | 366 |
1203149 | 1203149 | 2021-04-09 | Pueblo | Colorado | 8101 | 16263 | 366 |
1199901 | 1199901 | 2021-04-08 | Pueblo | Colorado | 8101 | 16216 | 366 |
1196652 | 1196652 | 2021-04-07 | Pueblo | Colorado | 8101 | 16093 | 366 |
1193404 | 1193404 | 2021-04-06 | Pueblo | Colorado | 8101 | 16093 | 366 |
1190154 | 1190154 | 2021-04-05 | Pueblo | Colorado | 8101 | 16075 | 365 |
1186907 | 1186907 | 2021-04-04 | Pueblo | Colorado | 8101 | 16045 | 365 |
1183660 | 1183660 | 2021-04-03 | Pueblo | Colorado | 8101 | 15986 | 365 |
1180413 | 1180413 | 2021-04-02 | Pueblo | Colorado | 8101 | 15945 | 365 |
1177166 | 1177166 | 2021-04-01 | Pueblo | Colorado | 8101 | 15876 | 365 |
1173919 | 1173919 | 2021-03-31 | Pueblo | Colorado | 8101 | 15830 | 364 |
1170672 | 1170672 | 2021-03-30 | Pueblo | Colorado | 8101 | 15766 | 364 |
1167424 | 1167424 | 2021-03-29 | Pueblo | Colorado | 8101 | 15748 | 364 |
1164176 | 1164176 | 2021-03-28 | Pueblo | Colorado | 8101 | 15691 | 364 |
1160928 | 1160928 | 2021-03-27 | Pueblo | Colorado | 8101 | 15651 | 364 |
1157680 | 1157680 | 2021-03-26 | Pueblo | Colorado | 8101 | 15614 | 364 |
1154433 | 1154433 | 2021-03-25 | Pueblo | Colorado | 8101 | 15578 | 364 |
1151186 | 1151186 | 2021-03-24 | Pueblo | Colorado | 8101 | 15552 | 364 |
1147939 | 1147939 | 2021-03-23 | Pueblo | Colorado | 8101 | 15518 | 364 |
1144692 | 1144692 | 2021-03-22 | Pueblo | Colorado | 8101 | 15498 | 364 |
1141445 | 1141445 | 2021-03-21 | Pueblo | Colorado | 8101 | 15495 | 364 |
1138199 | 1138199 | 2021-03-20 | Pueblo | Colorado | 8101 | 15479 | 365 |
1134953 | 1134953 | 2021-03-19 | Pueblo | Colorado | 8101 | 15453 | 365 |
1131706 | 1131706 | 2021-03-18 | Pueblo | Colorado | 8101 | 15427 | 365 |
1128458 | 1128458 | 2021-03-17 | Pueblo | Colorado | 8101 | 15399 | 365 |
1125212 | 1125212 | 2021-03-16 | Pueblo | Colorado | 8101 | 15364 | 365 |
1121966 | 1121966 | 2021-03-15 | Pueblo | Colorado | 8101 | 15357 | 365 |
1118719 | 1118719 | 2021-03-14 | Pueblo | Colorado | 8101 | 15350 | 365 |
1115472 | 1115472 | 2021-03-13 | Pueblo | Colorado | 8101 | 15328 | 365 |
1112226 | 1112226 | 2021-03-12 | Pueblo | Colorado | 8101 | 15306 | 365 |
1108980 | 1108980 | 2021-03-11 | Pueblo | Colorado | 8101 | 15279 | 366 |
1105734 | 1105734 | 2021-03-10 | Pueblo | Colorado | 8101 | 15266 | 365 |
1102488 | 1102488 | 2021-03-09 | Pueblo | Colorado | 8101 | 15250 | 364 |
1099242 | 1099242 | 2021-03-08 | Pueblo | Colorado | 8101 | 15195 | 363 |
1095994 | 1095994 | 2021-03-07 | Pueblo | Colorado | 8101 | 15177 | 363 |
1092748 | 1092748 | 2021-03-06 | Pueblo | Colorado | 8101 | 15177 | 363 |
1089502 | 1089502 | 2021-03-05 | Pueblo | Colorado | 8101 | 15167 | 363 |
1086257 | 1086257 | 2021-03-04 | Pueblo | Colorado | 8101 | 15134 | 363 |
1083011 | 1083011 | 2021-03-03 | Pueblo | Colorado | 8101 | 15110 | 364 |
1079765 | 1079765 | 2021-03-02 | Pueblo | Colorado | 8101 | 15058 | 363 |
1076520 | 1076520 | 2021-03-01 | Pueblo | Colorado | 8101 | 15046 | 363 |
1073274 | 1073274 | 2021-02-28 | Pueblo | Colorado | 8101 | 15007 | 363 |
1070028 | 1070028 | 2021-02-27 | Pueblo | Colorado | 8101 | 14995 | 363 |
1066783 | 1066783 | 2021-02-26 | Pueblo | Colorado | 8101 | 14945 | 363 |
1063538 | 1063538 | 2021-02-25 | Pueblo | Colorado | 8101 | 14945 | 363 |
1060293 | 1060293 | 2021-02-24 | Pueblo | Colorado | 8101 | 14907 | 361 |
1057047 | 1057047 | 2021-02-23 | Pueblo | Colorado | 8101 | 14900 | 361 |
1053801 | 1053801 | 2021-02-22 | Pueblo | Colorado | 8101 | 14881 | 362 |
1050554 | 1050554 | 2021-02-21 | Pueblo | Colorado | 8101 | 14879 | 362 |
1047307 | 1047307 | 2021-02-20 | Pueblo | Colorado | 8101 | 14874 | 362 |
1044062 | 1044062 | 2021-02-19 | Pueblo | Colorado | 8101 | 14853 | 363 |
1040817 | 1040817 | 2021-02-18 | Pueblo | Colorado | 8101 | 14839 | 362 |
1037572 | 1037572 | 2021-02-17 | Pueblo | Colorado | 8101 | 14814 | 362 |
1034327 | 1034327 | 2021-02-16 | Pueblo | Colorado | 8101 | 14802 | 362 |
1031081 | 1031081 | 2021-02-15 | Pueblo | Colorado | 8101 | 14796 | 362 |
1027834 | 1027834 | 2021-02-14 | Pueblo | Colorado | 8101 | 14794 | 362 |
1024589 | 1024589 | 2021-02-13 | Pueblo | Colorado | 8101 | 14787 | 361 |
1021344 | 1021344 | 2021-02-12 | Pueblo | Colorado | 8101 | 14727 | 361 |
1018099 | 1018099 | 2021-02-11 | Pueblo | Colorado | 8101 | 14461 | 361 |
1014854 | 1014854 | 2021-02-10 | Pueblo | Colorado | 8101 | 14451 | 361 |
1011609 | 1011609 | 2021-02-09 | Pueblo | Colorado | 8101 | 14452 | 360 |
1008363 | 1008363 | 2021-02-08 | Pueblo | Colorado | 8101 | 14449 | 360 |
1005117 | 1005117 | 2021-02-07 | Pueblo | Colorado | 8101 | 14441 | 360 |
1001871 | 1001871 | 2021-02-06 | Pueblo | Colorado | 8101 | 14426 | 359 |
998625 | 998625 | 2021-02-05 | Pueblo | Colorado | 8101 | 14407 | 359 |
995379 | 995379 | 2021-02-04 | Pueblo | Colorado | 8101 | 14389 | 360 |
992133 | 992133 | 2021-02-03 | Pueblo | Colorado | 8101 | 14381 | 359 |
988887 | 988887 | 2021-02-02 | Pueblo | Colorado | 8101 | 14353 | 355 |
985640 | 985640 | 2021-02-01 | Pueblo | Colorado | 8101 | 14353 | 356 |
982393 | 982393 | 2021-01-31 | Pueblo | Colorado | 8101 | 14302 | 356 |
979147 | 979147 | 2021-01-30 | Pueblo | Colorado | 8101 | 14302 | 356 |
975902 | 975902 | 2021-01-29 | Pueblo | Colorado | 8101 | 14302 | 356 |
972657 | 972657 | 2021-01-28 | Pueblo | Colorado | 8101 | 14246 | 356 |
969412 | 969412 | 2021-01-27 | Pueblo | Colorado | 8101 | 14230 | 355 |
966168 | 966168 | 2021-01-26 | Pueblo | Colorado | 8101 | 14199 | 357 |
962923 | 962923 | 2021-01-25 | Pueblo | Colorado | 8101 | 14177 | 356 |
959678 | 959678 | 2021-01-24 | Pueblo | Colorado | 8101 | 14177 | 356 |
956432 | 956432 | 2021-01-23 | Pueblo | Colorado | 8101 | 14159 | 354 |
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);