ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277850 | 1277850 | 2021-05-02 | Weld | Colorado | 8123 | 30688 | 334 |
1274603 | 1274603 | 2021-05-01 | Weld | Colorado | 8123 | 30639 | 334 |
1271356 | 1271356 | 2021-04-30 | Weld | Colorado | 8123 | 30521 | 334 |
1268109 | 1268109 | 2021-04-29 | Weld | Colorado | 8123 | 30442 | 334 |
1264862 | 1264862 | 2021-04-28 | Weld | Colorado | 8123 | 30254 | 334 |
1261615 | 1261615 | 2021-04-27 | Weld | Colorado | 8123 | 30185 | 333 |
1258368 | 1258368 | 2021-04-26 | Weld | Colorado | 8123 | 30055 | 333 |
1255121 | 1255121 | 2021-04-25 | Weld | Colorado | 8123 | 29957 | 333 |
1251874 | 1251874 | 2021-04-24 | Weld | Colorado | 8123 | 29860 | 333 |
1248627 | 1248627 | 2021-04-23 | Weld | Colorado | 8123 | 29813 | 333 |
1245380 | 1245380 | 2021-04-22 | Weld | Colorado | 8123 | 29683 | 332 |
1242133 | 1242133 | 2021-04-21 | Weld | Colorado | 8123 | 29552 | 331 |
1238886 | 1238886 | 2021-04-20 | Weld | Colorado | 8123 | 29407 | 331 |
1235639 | 1235639 | 2021-04-19 | Weld | Colorado | 8123 | 29307 | 330 |
1232392 | 1232392 | 2021-04-18 | Weld | Colorado | 8123 | 29172 | 330 |
1229143 | 1229143 | 2021-04-17 | Weld | Colorado | 8123 | 29076 | 329 |
1225895 | 1225895 | 2021-04-16 | Weld | Colorado | 8123 | 29019 | 329 |
1222648 | 1222648 | 2021-04-15 | Weld | Colorado | 8123 | 28897 | 329 |
1219400 | 1219400 | 2021-04-14 | Weld | Colorado | 8123 | 28789 | 329 |
1216152 | 1216152 | 2021-04-13 | Weld | Colorado | 8123 | 28693 | 327 |
1212905 | 1212905 | 2021-04-12 | Weld | Colorado | 8123 | 28589 | 327 |
1209657 | 1209657 | 2021-04-11 | Weld | Colorado | 8123 | 28478 | 327 |
1206408 | 1206408 | 2021-04-10 | Weld | Colorado | 8123 | 28405 | 327 |
1203160 | 1203160 | 2021-04-09 | Weld | Colorado | 8123 | 28365 | 327 |
1199912 | 1199912 | 2021-04-08 | Weld | Colorado | 8123 | 28242 | 327 |
1196663 | 1196663 | 2021-04-07 | Weld | Colorado | 8123 | 28151 | 327 |
1193415 | 1193415 | 2021-04-06 | Weld | Colorado | 8123 | 28000 | 327 |
1190165 | 1190165 | 2021-04-05 | Weld | Colorado | 8123 | 27926 | 326 |
1186918 | 1186918 | 2021-04-04 | Weld | Colorado | 8123 | 27813 | 326 |
1183671 | 1183671 | 2021-04-03 | Weld | Colorado | 8123 | 27742 | 326 |
1180424 | 1180424 | 2021-04-02 | Weld | Colorado | 8123 | 27700 | 326 |
1177177 | 1177177 | 2021-04-01 | Weld | Colorado | 8123 | 27606 | 326 |
1173930 | 1173930 | 2021-03-31 | Weld | Colorado | 8123 | 27531 | 326 |
1170683 | 1170683 | 2021-03-30 | Weld | Colorado | 8123 | 27412 | 323 |
1167435 | 1167435 | 2021-03-29 | Weld | Colorado | 8123 | 27361 | 322 |
1164187 | 1164187 | 2021-03-28 | Weld | Colorado | 8123 | 27274 | 322 |
1160939 | 1160939 | 2021-03-27 | Weld | Colorado | 8123 | 27215 | 321 |
1157691 | 1157691 | 2021-03-26 | Weld | Colorado | 8123 | 27188 | 322 |
1154444 | 1154444 | 2021-03-25 | Weld | Colorado | 8123 | 27101 | 321 |
1151197 | 1151197 | 2021-03-24 | Weld | Colorado | 8123 | 27033 | 321 |
1147950 | 1147950 | 2021-03-23 | Weld | Colorado | 8123 | 26954 | 322 |
1144703 | 1144703 | 2021-03-22 | Weld | Colorado | 8123 | 26889 | 323 |
1141456 | 1141456 | 2021-03-21 | Weld | Colorado | 8123 | 26852 | 323 |
1138210 | 1138210 | 2021-03-20 | Weld | Colorado | 8123 | 26800 | 322 |
1134964 | 1134964 | 2021-03-19 | Weld | Colorado | 8123 | 26759 | 321 |
1131717 | 1131717 | 2021-03-18 | Weld | Colorado | 8123 | 26649 | 321 |
1128469 | 1128469 | 2021-03-17 | Weld | Colorado | 8123 | 26542 | 320 |
1125223 | 1125223 | 2021-03-16 | Weld | Colorado | 8123 | 26481 | 320 |
1121977 | 1121977 | 2021-03-15 | Weld | Colorado | 8123 | 26457 | 319 |
1118730 | 1118730 | 2021-03-14 | Weld | Colorado | 8123 | 26436 | 319 |
1115483 | 1115483 | 2021-03-13 | Weld | Colorado | 8123 | 26367 | 319 |
1112237 | 1112237 | 2021-03-12 | Weld | Colorado | 8123 | 26321 | 319 |
1108991 | 1108991 | 2021-03-11 | Weld | Colorado | 8123 | 26260 | 319 |
1105745 | 1105745 | 2021-03-10 | Weld | Colorado | 8123 | 26191 | 319 |
1102499 | 1102499 | 2021-03-09 | Weld | Colorado | 8123 | 26124 | 319 |
1099253 | 1099253 | 2021-03-08 | Weld | Colorado | 8123 | 26065 | 319 |
1096005 | 1096005 | 2021-03-07 | Weld | Colorado | 8123 | 25926 | 319 |
1092759 | 1092759 | 2021-03-06 | Weld | Colorado | 8123 | 25926 | 319 |
1089513 | 1089513 | 2021-03-05 | Weld | Colorado | 8123 | 25886 | 319 |
1086268 | 1086268 | 2021-03-04 | Weld | Colorado | 8123 | 25826 | 319 |
1083022 | 1083022 | 2021-03-03 | Weld | Colorado | 8123 | 25760 | 319 |
1079776 | 1079776 | 2021-03-02 | Weld | Colorado | 8123 | 25645 | 319 |
1076531 | 1076531 | 2021-03-01 | Weld | Colorado | 8123 | 25585 | 319 |
1073285 | 1073285 | 2021-02-28 | Weld | Colorado | 8123 | 25465 | 319 |
1070039 | 1070039 | 2021-02-27 | Weld | Colorado | 8123 | 25432 | 319 |
1066794 | 1066794 | 2021-02-26 | Weld | Colorado | 8123 | 25432 | 318 |
1063549 | 1063549 | 2021-02-25 | Weld | Colorado | 8123 | 25356 | 318 |
1060304 | 1060304 | 2021-02-24 | Weld | Colorado | 8123 | 25290 | 317 |
1057058 | 1057058 | 2021-02-23 | Weld | Colorado | 8123 | 25205 | 317 |
1053812 | 1053812 | 2021-02-22 | Weld | Colorado | 8123 | 25137 | 316 |
1050565 | 1050565 | 2021-02-21 | Weld | Colorado | 8123 | 25018 | 316 |
1047318 | 1047318 | 2021-02-20 | Weld | Colorado | 8123 | 24974 | 316 |
1044073 | 1044073 | 2021-02-19 | Weld | Colorado | 8123 | 24974 | 316 |
1040828 | 1040828 | 2021-02-18 | Weld | Colorado | 8123 | 24903 | 316 |
1037583 | 1037583 | 2021-02-17 | Weld | Colorado | 8123 | 24824 | 315 |
1034338 | 1034338 | 2021-02-16 | Weld | Colorado | 8123 | 24736 | 314 |
1031092 | 1031092 | 2021-02-15 | Weld | Colorado | 8123 | 24653 | 314 |
1027845 | 1027845 | 2021-02-14 | Weld | Colorado | 8123 | 24632 | 314 |
1024600 | 1024600 | 2021-02-13 | Weld | Colorado | 8123 | 24599 | 314 |
1021355 | 1021355 | 2021-02-12 | Weld | Colorado | 8123 | 24599 | 313 |
1018110 | 1018110 | 2021-02-11 | Weld | Colorado | 8123 | 24520 | 313 |
1014865 | 1014865 | 2021-02-10 | Weld | Colorado | 8123 | 24417 | 313 |
1011620 | 1011620 | 2021-02-09 | Weld | Colorado | 8123 | 24363 | 312 |
1008374 | 1008374 | 2021-02-08 | Weld | Colorado | 8123 | 24309 | 310 |
1005128 | 1005128 | 2021-02-07 | Weld | Colorado | 8123 | 24185 | 310 |
1001882 | 1001882 | 2021-02-06 | Weld | Colorado | 8123 | 24098 | 310 |
998636 | 998636 | 2021-02-05 | Weld | Colorado | 8123 | 24098 | 310 |
995390 | 995390 | 2021-02-04 | Weld | Colorado | 8123 | 24012 | 310 |
992144 | 992144 | 2021-02-03 | Weld | Colorado | 8123 | 23930 | 309 |
988898 | 988898 | 2021-02-02 | Weld | Colorado | 8123 | 23839 | 307 |
985651 | 985651 | 2021-02-01 | Weld | Colorado | 8123 | 23711 | 307 |
982404 | 982404 | 2021-01-31 | Weld | Colorado | 8123 | 23516 | 306 |
979158 | 979158 | 2021-01-30 | Weld | Colorado | 8123 | 23516 | 306 |
975913 | 975913 | 2021-01-29 | Weld | Colorado | 8123 | 23516 | 306 |
972668 | 972668 | 2021-01-28 | Weld | Colorado | 8123 | 23447 | 304 |
969423 | 969423 | 2021-01-27 | Weld | Colorado | 8123 | 23398 | 304 |
966179 | 966179 | 2021-01-26 | Weld | Colorado | 8123 | 23303 | 301 |
962934 | 962934 | 2021-01-25 | Weld | Colorado | 8123 | 23261 | 301 |
959689 | 959689 | 2021-01-24 | Weld | Colorado | 8123 | 23106 | 301 |
956443 | 956443 | 2021-01-23 | Weld | Colorado | 8123 | 23042 | 300 |
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);