ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
840 rows where fips = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277759 | 1277759 | 2021-05-02 | Orange | California | 6059 | 270284 | 4969 |
1274512 | 1274512 | 2021-05-01 | Orange | California | 6059 | 270194 | 4965 |
1271265 | 1271265 | 2021-04-30 | Orange | California | 6059 | 270101 | 4957 |
1268018 | 1268018 | 2021-04-29 | Orange | California | 6059 | 270014 | 4948 |
1264771 | 1264771 | 2021-04-28 | Orange | California | 6059 | 269949 | 4944 |
1261524 | 1261524 | 2021-04-27 | Orange | California | 6059 | 269838 | 4939 |
1258277 | 1258277 | 2021-04-26 | Orange | California | 6059 | 269724 | 4933 |
1255030 | 1255030 | 2021-04-25 | Orange | California | 6059 | 269633 | 4933 |
1251783 | 1251783 | 2021-04-24 | Orange | California | 6059 | 269549 | 4924 |
1248536 | 1248536 | 2021-04-23 | Orange | California | 6059 | 269433 | 4918 |
1245289 | 1245289 | 2021-04-22 | Orange | California | 6059 | 269352 | 4910 |
1242042 | 1242042 | 2021-04-21 | Orange | California | 6059 | 269258 | 4902 |
1238795 | 1238795 | 2021-04-20 | Orange | California | 6059 | 269176 | 4900 |
1235548 | 1235548 | 2021-04-19 | Orange | California | 6059 | 269036 | 4896 |
1232301 | 1232301 | 2021-04-18 | Orange | California | 6059 | 268962 | 4896 |
1229052 | 1229052 | 2021-04-17 | Orange | California | 6059 | 268869 | 4891 |
1225804 | 1225804 | 2021-04-16 | Orange | California | 6059 | 268762 | 4886 |
1222557 | 1222557 | 2021-04-15 | Orange | California | 6059 | 268622 | 4869 |
1219309 | 1219309 | 2021-04-14 | Orange | California | 6059 | 268521 | 4862 |
1216061 | 1216061 | 2021-04-13 | Orange | California | 6059 | 268414 | 4849 |
1212814 | 1212814 | 2021-04-12 | Orange | California | 6059 | 268304 | 4839 |
1209566 | 1209566 | 2021-04-11 | Orange | California | 6059 | 268175 | 4839 |
1206317 | 1206317 | 2021-04-10 | Orange | California | 6059 | 267957 | 4831 |
1203069 | 1203069 | 2021-04-09 | Orange | California | 6059 | 267492 | 4826 |
1199821 | 1199821 | 2021-04-08 | Orange | California | 6059 | 267383 | 4810 |
1196572 | 1196572 | 2021-04-07 | Orange | California | 6059 | 267253 | 4791 |
1193324 | 1193324 | 2021-04-06 | Orange | California | 6059 | 267143 | 4784 |
1190074 | 1190074 | 2021-04-05 | Orange | California | 6059 | 267001 | 4772 |
1186827 | 1186827 | 2021-04-04 | Orange | California | 6059 | 266766 | 4768 |
1183580 | 1183580 | 2021-04-03 | Orange | California | 6059 | 266766 | 4768 |
1180333 | 1180333 | 2021-04-02 | Orange | California | 6059 | 266464 | 4761 |
1177086 | 1177086 | 2021-04-01 | Orange | California | 6059 | 266353 | 4755 |
1173839 | 1173839 | 2021-03-31 | Orange | California | 6059 | 266233 | 4744 |
1170592 | 1170592 | 2021-03-30 | Orange | California | 6059 | 266057 | 4740 |
1167344 | 1167344 | 2021-03-29 | Orange | California | 6059 | 265926 | 4726 |
1164096 | 1164096 | 2021-03-28 | Orange | California | 6059 | 265787 | 4725 |
1160848 | 1160848 | 2021-03-27 | Orange | California | 6059 | 265653 | 4711 |
1157600 | 1157600 | 2021-03-26 | Orange | California | 6059 | 265536 | 4684 |
1154353 | 1154353 | 2021-03-25 | Orange | California | 6059 | 265356 | 4665 |
1151106 | 1151106 | 2021-03-24 | Orange | California | 6059 | 265219 | 4646 |
1147859 | 1147859 | 2021-03-23 | Orange | California | 6059 | 264989 | 4635 |
1144612 | 1144612 | 2021-03-22 | Orange | California | 6059 | 264849 | 4608 |
1141365 | 1141365 | 2021-03-21 | Orange | California | 6059 | 264721 | 4607 |
1138119 | 1138119 | 2021-03-20 | Orange | California | 6059 | 264600 | 4562 |
1134873 | 1134873 | 2021-03-19 | Orange | California | 6059 | 264478 | 4536 |
1131626 | 1131626 | 2021-03-18 | Orange | California | 6059 | 264335 | 4522 |
1128378 | 1128378 | 2021-03-17 | Orange | California | 6059 | 264216 | 4511 |
1125132 | 1125132 | 2021-03-16 | Orange | California | 6059 | 264033 | 4486 |
1121886 | 1121886 | 2021-03-15 | Orange | California | 6059 | 263994 | 4486 |
1118639 | 1118639 | 2021-03-14 | Orange | California | 6059 | 263823 | 4465 |
1115392 | 1115392 | 2021-03-13 | Orange | California | 6059 | 263653 | 4434 |
1112146 | 1112146 | 2021-03-12 | Orange | California | 6059 | 263471 | 4408 |
1108900 | 1108900 | 2021-03-11 | Orange | California | 6059 | 263279 | 4379 |
1105654 | 1105654 | 2021-03-10 | Orange | California | 6059 | 263111 | 4346 |
1102408 | 1102408 | 2021-03-09 | Orange | California | 6059 | 262995 | 4313 |
1099162 | 1099162 | 2021-03-08 | Orange | California | 6059 | 262849 | 4252 |
1095914 | 1095914 | 2021-03-07 | Orange | California | 6059 | 262674 | 4226 |
1092668 | 1092668 | 2021-03-06 | Orange | California | 6059 | 262550 | 4173 |
1089422 | 1089422 | 2021-03-05 | Orange | California | 6059 | 262241 | 4075 |
1086177 | 1086177 | 2021-03-04 | Orange | California | 6059 | 261976 | 4013 |
1082931 | 1082931 | 2021-03-03 | Orange | California | 6059 | 261798 | 3966 |
1079685 | 1079685 | 2021-03-02 | Orange | California | 6059 | 261608 | 3952 |
1076440 | 1076440 | 2021-03-01 | Orange | California | 6059 | 261408 | 3921 |
1073194 | 1073194 | 2021-02-28 | Orange | California | 6059 | 261220 | 3917 |
1069948 | 1069948 | 2021-02-27 | Orange | California | 6059 | 261022 | 3904 |
1066703 | 1066703 | 2021-02-26 | Orange | California | 6059 | 260721 | 3892 |
1063458 | 1063458 | 2021-02-25 | Orange | California | 6059 | 260348 | 3889 |
1060213 | 1060213 | 2021-02-24 | Orange | California | 6059 | 260157 | 3848 |
1056967 | 1056967 | 2021-02-23 | Orange | California | 6059 | 259857 | 3848 |
1053721 | 1053721 | 2021-02-22 | Orange | California | 6059 | 259581 | 3848 |
1050474 | 1050474 | 2021-02-21 | Orange | California | 6059 | 259305 | 3810 |
1047227 | 1047227 | 2021-02-20 | Orange | California | 6059 | 258991 | 3770 |
1043982 | 1043982 | 2021-02-19 | Orange | California | 6059 | 258567 | 3726 |
1040737 | 1040737 | 2021-02-18 | Orange | California | 6059 | 258182 | 3685 |
1037492 | 1037492 | 2021-02-17 | Orange | California | 6059 | 257816 | 3644 |
1034247 | 1034247 | 2021-02-16 | Orange | California | 6059 | 257589 | 3617 |
1031001 | 1031001 | 2021-02-15 | Orange | California | 6059 | 256889 | 3577 |
1027754 | 1027754 | 2021-02-14 | Orange | California | 6059 | 256889 | 3577 |
1024509 | 1024509 | 2021-02-13 | Orange | California | 6059 | 256510 | 3544 |
1021264 | 1021264 | 2021-02-12 | Orange | California | 6059 | 255254 | 3493 |
1018019 | 1018019 | 2021-02-11 | Orange | California | 6059 | 255254 | 3493 |
1014774 | 1014774 | 2021-02-10 | Orange | California | 6059 | 254417 | 3451 |
1011529 | 1011529 | 2021-02-09 | Orange | California | 6059 | 253900 | 3416 |
1008283 | 1008283 | 2021-02-08 | Orange | California | 6059 | 253289 | 3383 |
1005037 | 1005037 | 2021-02-07 | Orange | California | 6059 | 252311 | 3358 |
1001791 | 1001791 | 2021-02-06 | Orange | California | 6059 | 251079 | 3312 |
998545 | 998545 | 2021-02-05 | Orange | California | 6059 | 250300 | 3279 |
995299 | 995299 | 2021-02-04 | Orange | California | 6059 | 249195 | 3249 |
992053 | 992053 | 2021-02-03 | Orange | California | 6059 | 248510 | 3199 |
988807 | 988807 | 2021-02-02 | Orange | California | 6059 | 247886 | 3162 |
985560 | 985560 | 2021-02-01 | Orange | California | 6059 | 247035 | 3109 |
982313 | 982313 | 2021-01-31 | Orange | California | 6059 | 245978 | 3062 |
979067 | 979067 | 2021-01-30 | Orange | California | 6059 | 244562 | 3018 |
975822 | 975822 | 2021-01-29 | Orange | California | 6059 | 243212 | 2975 |
972577 | 972577 | 2021-01-28 | Orange | California | 6059 | 241648 | 2868 |
969332 | 969332 | 2021-01-27 | Orange | California | 6059 | 240314 | 2839 |
966088 | 966088 | 2021-01-26 | Orange | California | 6059 | 239175 | 2768 |
962843 | 962843 | 2021-01-25 | Orange | California | 6059 | 237708 | 2704 |
959598 | 959598 | 2021-01-24 | Orange | California | 6059 | 236312 | 2638 |
956352 | 956352 | 2021-01-23 | Orange | California | 6059 | 234427 | 2625 |
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);