ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 8067 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277821 | 1277821 | 2021-05-02 | La Plata | Colorado | 8067 | 3846 | 39 |
1274574 | 1274574 | 2021-05-01 | La Plata | Colorado | 8067 | 3844 | 39 |
1271327 | 1271327 | 2021-04-30 | La Plata | Colorado | 8067 | 3835 | 39 |
1268080 | 1268080 | 2021-04-29 | La Plata | Colorado | 8067 | 3821 | 39 |
1264833 | 1264833 | 2021-04-28 | La Plata | Colorado | 8067 | 3803 | 39 |
1261586 | 1261586 | 2021-04-27 | La Plata | Colorado | 8067 | 3782 | 39 |
1258339 | 1258339 | 2021-04-26 | La Plata | Colorado | 8067 | 3756 | 38 |
1255092 | 1255092 | 2021-04-25 | La Plata | Colorado | 8067 | 3756 | 38 |
1251845 | 1251845 | 2021-04-24 | La Plata | Colorado | 8067 | 3744 | 38 |
1248598 | 1248598 | 2021-04-23 | La Plata | Colorado | 8067 | 3734 | 38 |
1245351 | 1245351 | 2021-04-22 | La Plata | Colorado | 8067 | 3709 | 38 |
1242104 | 1242104 | 2021-04-21 | La Plata | Colorado | 8067 | 3685 | 38 |
1238857 | 1238857 | 2021-04-20 | La Plata | Colorado | 8067 | 3670 | 38 |
1235610 | 1235610 | 2021-04-19 | La Plata | Colorado | 8067 | 3657 | 38 |
1232363 | 1232363 | 2021-04-18 | La Plata | Colorado | 8067 | 3651 | 38 |
1229114 | 1229114 | 2021-04-17 | La Plata | Colorado | 8067 | 3641 | 38 |
1225866 | 1225866 | 2021-04-16 | La Plata | Colorado | 8067 | 3621 | 38 |
1222619 | 1222619 | 2021-04-15 | La Plata | Colorado | 8067 | 3601 | 38 |
1219371 | 1219371 | 2021-04-14 | La Plata | Colorado | 8067 | 3584 | 37 |
1216123 | 1216123 | 2021-04-13 | La Plata | Colorado | 8067 | 3568 | 37 |
1212876 | 1212876 | 2021-04-12 | La Plata | Colorado | 8067 | 3555 | 37 |
1209628 | 1209628 | 2021-04-11 | La Plata | Colorado | 8067 | 3553 | 37 |
1206379 | 1206379 | 2021-04-10 | La Plata | Colorado | 8067 | 3537 | 37 |
1203131 | 1203131 | 2021-04-09 | La Plata | Colorado | 8067 | 3504 | 37 |
1199883 | 1199883 | 2021-04-08 | La Plata | Colorado | 8067 | 3473 | 37 |
1196634 | 1196634 | 2021-04-07 | La Plata | Colorado | 8067 | 3430 | 37 |
1193386 | 1193386 | 2021-04-06 | La Plata | Colorado | 8067 | 3430 | 37 |
1190136 | 1190136 | 2021-04-05 | La Plata | Colorado | 8067 | 3420 | 37 |
1186889 | 1186889 | 2021-04-04 | La Plata | Colorado | 8067 | 3416 | 37 |
1183642 | 1183642 | 2021-04-03 | La Plata | Colorado | 8067 | 3399 | 37 |
1180395 | 1180395 | 2021-04-02 | La Plata | Colorado | 8067 | 3378 | 37 |
1177148 | 1177148 | 2021-04-01 | La Plata | Colorado | 8067 | 3347 | 37 |
1173901 | 1173901 | 2021-03-31 | La Plata | Colorado | 8067 | 3330 | 37 |
1170654 | 1170654 | 2021-03-30 | La Plata | Colorado | 8067 | 3313 | 37 |
1167406 | 1167406 | 2021-03-29 | La Plata | Colorado | 8067 | 3306 | 37 |
1164158 | 1164158 | 2021-03-28 | La Plata | Colorado | 8067 | 3300 | 37 |
1160910 | 1160910 | 2021-03-27 | La Plata | Colorado | 8067 | 3296 | 37 |
1157662 | 1157662 | 2021-03-26 | La Plata | Colorado | 8067 | 3280 | 37 |
1154415 | 1154415 | 2021-03-25 | La Plata | Colorado | 8067 | 3269 | 37 |
1151168 | 1151168 | 2021-03-24 | La Plata | Colorado | 8067 | 3250 | 37 |
1147921 | 1147921 | 2021-03-23 | La Plata | Colorado | 8067 | 3239 | 37 |
1144674 | 1144674 | 2021-03-22 | La Plata | Colorado | 8067 | 3234 | 37 |
1141427 | 1141427 | 2021-03-21 | La Plata | Colorado | 8067 | 3231 | 37 |
1138181 | 1138181 | 2021-03-20 | La Plata | Colorado | 8067 | 3220 | 37 |
1134935 | 1134935 | 2021-03-19 | La Plata | Colorado | 8067 | 3210 | 37 |
1131688 | 1131688 | 2021-03-18 | La Plata | Colorado | 8067 | 3198 | 37 |
1128440 | 1128440 | 2021-03-17 | La Plata | Colorado | 8067 | 3187 | 37 |
1125194 | 1125194 | 2021-03-16 | La Plata | Colorado | 8067 | 3169 | 37 |
1121948 | 1121948 | 2021-03-15 | La Plata | Colorado | 8067 | 3161 | 37 |
1118701 | 1118701 | 2021-03-14 | La Plata | Colorado | 8067 | 3158 | 37 |
1115454 | 1115454 | 2021-03-13 | La Plata | Colorado | 8067 | 3141 | 37 |
1112208 | 1112208 | 2021-03-12 | La Plata | Colorado | 8067 | 3120 | 37 |
1108962 | 1108962 | 2021-03-11 | La Plata | Colorado | 8067 | 3103 | 37 |
1105716 | 1105716 | 2021-03-10 | La Plata | Colorado | 8067 | 3082 | 37 |
1102470 | 1102470 | 2021-03-09 | La Plata | Colorado | 8067 | 3057 | 37 |
1099224 | 1099224 | 2021-03-08 | La Plata | Colorado | 8067 | 3052 | 37 |
1095976 | 1095976 | 2021-03-07 | La Plata | Colorado | 8067 | 3024 | 37 |
1092730 | 1092730 | 2021-03-06 | La Plata | Colorado | 8067 | 3024 | 37 |
1089484 | 1089484 | 2021-03-05 | La Plata | Colorado | 8067 | 3016 | 37 |
1086239 | 1086239 | 2021-03-04 | La Plata | Colorado | 8067 | 3009 | 37 |
1082993 | 1082993 | 2021-03-03 | La Plata | Colorado | 8067 | 2987 | 37 |
1079747 | 1079747 | 2021-03-02 | La Plata | Colorado | 8067 | 2982 | 37 |
1076502 | 1076502 | 2021-03-01 | La Plata | Colorado | 8067 | 2980 | 37 |
1073256 | 1073256 | 2021-02-28 | La Plata | Colorado | 8067 | 2968 | 37 |
1070010 | 1070010 | 2021-02-27 | La Plata | Colorado | 8067 | 2957 | 37 |
1066765 | 1066765 | 2021-02-26 | La Plata | Colorado | 8067 | 2936 | 37 |
1063520 | 1063520 | 2021-02-25 | La Plata | Colorado | 8067 | 2936 | 37 |
1060275 | 1060275 | 2021-02-24 | La Plata | Colorado | 8067 | 2914 | 37 |
1057029 | 1057029 | 2021-02-23 | La Plata | Colorado | 8067 | 2899 | 37 |
1053783 | 1053783 | 2021-02-22 | La Plata | Colorado | 8067 | 2890 | 37 |
1050536 | 1050536 | 2021-02-21 | La Plata | Colorado | 8067 | 2879 | 37 |
1047289 | 1047289 | 2021-02-20 | La Plata | Colorado | 8067 | 2876 | 36 |
1044044 | 1044044 | 2021-02-19 | La Plata | Colorado | 8067 | 2865 | 36 |
1040799 | 1040799 | 2021-02-18 | La Plata | Colorado | 8067 | 2858 | 36 |
1037554 | 1037554 | 2021-02-17 | La Plata | Colorado | 8067 | 2852 | 36 |
1034309 | 1034309 | 2021-02-16 | La Plata | Colorado | 8067 | 2851 | 37 |
1031063 | 1031063 | 2021-02-15 | La Plata | Colorado | 8067 | 2850 | 36 |
1027816 | 1027816 | 2021-02-14 | La Plata | Colorado | 8067 | 2842 | 36 |
1024571 | 1024571 | 2021-02-13 | La Plata | Colorado | 8067 | 2839 | 36 |
1021326 | 1021326 | 2021-02-12 | La Plata | Colorado | 8067 | 2830 | 35 |
1018081 | 1018081 | 2021-02-11 | La Plata | Colorado | 8067 | 2816 | 35 |
1014836 | 1014836 | 2021-02-10 | La Plata | Colorado | 8067 | 2799 | 35 |
1011591 | 1011591 | 2021-02-09 | La Plata | Colorado | 8067 | 2781 | 35 |
1008345 | 1008345 | 2021-02-08 | La Plata | Colorado | 8067 | 2770 | 35 |
1005099 | 1005099 | 2021-02-07 | La Plata | Colorado | 8067 | 2765 | 35 |
1001853 | 1001853 | 2021-02-06 | La Plata | Colorado | 8067 | 2758 | 35 |
998607 | 998607 | 2021-02-05 | La Plata | Colorado | 8067 | 2733 | 35 |
995361 | 995361 | 2021-02-04 | La Plata | Colorado | 8067 | 2715 | 35 |
992115 | 992115 | 2021-02-03 | La Plata | Colorado | 8067 | 2710 | 35 |
988869 | 988869 | 2021-02-02 | La Plata | Colorado | 8067 | 2706 | 35 |
985622 | 985622 | 2021-02-01 | La Plata | Colorado | 8067 | 2702 | 34 |
982375 | 982375 | 2021-01-31 | La Plata | Colorado | 8067 | 2693 | 34 |
979129 | 979129 | 2021-01-30 | La Plata | Colorado | 8067 | 2693 | 34 |
975884 | 975884 | 2021-01-29 | La Plata | Colorado | 8067 | 2693 | 34 |
972639 | 972639 | 2021-01-28 | La Plata | Colorado | 8067 | 2673 | 34 |
969394 | 969394 | 2021-01-27 | La Plata | Colorado | 8067 | 2662 | 34 |
966150 | 966150 | 2021-01-26 | La Plata | Colorado | 8067 | 2658 | 33 |
962905 | 962905 | 2021-01-25 | La Plata | Colorado | 8067 | 2646 | 31 |
959660 | 959660 | 2021-01-24 | La Plata | Colorado | 8067 | 2646 | 31 |
956414 | 956414 | 2021-01-23 | La Plata | Colorado | 8067 | 2639 | 30 |
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);