ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where county = "Lake", deaths = 6, fips = 41037 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1182363 | 1182363 | 2021-04-02 | Lake | Oregon | 41037 | 405 | 6 |
1179116 | 1179116 | 2021-04-01 | Lake | Oregon | 41037 | 404 | 6 |
1175869 | 1175869 | 2021-03-31 | Lake | Oregon | 41037 | 404 | 6 |
1172622 | 1172622 | 2021-03-30 | Lake | Oregon | 41037 | 403 | 6 |
1169375 | 1169375 | 2021-03-29 | Lake | Oregon | 41037 | 400 | 6 |
1166127 | 1166127 | 2021-03-28 | Lake | Oregon | 41037 | 399 | 6 |
1162879 | 1162879 | 2021-03-27 | Lake | Oregon | 41037 | 399 | 6 |
1159630 | 1159630 | 2021-03-26 | Lake | Oregon | 41037 | 399 | 6 |
1156383 | 1156383 | 2021-03-25 | Lake | Oregon | 41037 | 399 | 6 |
1153136 | 1153136 | 2021-03-24 | Lake | Oregon | 41037 | 396 | 6 |
1149889 | 1149889 | 2021-03-23 | Lake | Oregon | 41037 | 396 | 6 |
1146642 | 1146642 | 2021-03-22 | Lake | Oregon | 41037 | 395 | 6 |
1143395 | 1143395 | 2021-03-21 | Lake | Oregon | 41037 | 394 | 6 |
1140148 | 1140148 | 2021-03-20 | Lake | Oregon | 41037 | 393 | 6 |
1136902 | 1136902 | 2021-03-19 | Lake | Oregon | 41037 | 393 | 6 |
1133656 | 1133656 | 2021-03-18 | Lake | Oregon | 41037 | 392 | 6 |
1130408 | 1130408 | 2021-03-17 | Lake | Oregon | 41037 | 392 | 6 |
1127161 | 1127161 | 2021-03-16 | Lake | Oregon | 41037 | 392 | 6 |
1123915 | 1123915 | 2021-03-15 | Lake | Oregon | 41037 | 390 | 6 |
1120669 | 1120669 | 2021-03-14 | Lake | Oregon | 41037 | 390 | 6 |
1117422 | 1117422 | 2021-03-13 | Lake | Oregon | 41037 | 390 | 6 |
1114175 | 1114175 | 2021-03-12 | Lake | Oregon | 41037 | 390 | 6 |
1110929 | 1110929 | 2021-03-11 | Lake | Oregon | 41037 | 388 | 6 |
1107683 | 1107683 | 2021-03-10 | Lake | Oregon | 41037 | 388 | 6 |
1104437 | 1104437 | 2021-03-09 | Lake | Oregon | 41037 | 388 | 6 |
1101191 | 1101191 | 2021-03-08 | Lake | Oregon | 41037 | 386 | 6 |
1097945 | 1097945 | 2021-03-07 | Lake | Oregon | 41037 | 386 | 6 |
1094697 | 1094697 | 2021-03-06 | Lake | Oregon | 41037 | 383 | 6 |
1091451 | 1091451 | 2021-03-05 | Lake | Oregon | 41037 | 383 | 6 |
1088205 | 1088205 | 2021-03-04 | Lake | Oregon | 41037 | 382 | 6 |
1084960 | 1084960 | 2021-03-03 | Lake | Oregon | 41037 | 378 | 6 |
1081714 | 1081714 | 2021-03-02 | Lake | Oregon | 41037 | 378 | 6 |
1078468 | 1078468 | 2021-03-01 | Lake | Oregon | 41037 | 376 | 6 |
1075223 | 1075223 | 2021-02-28 | Lake | Oregon | 41037 | 376 | 6 |
1071977 | 1071977 | 2021-02-27 | Lake | Oregon | 41037 | 375 | 6 |
1068731 | 1068731 | 2021-02-26 | Lake | Oregon | 41037 | 374 | 6 |
1065486 | 1065486 | 2021-02-25 | Lake | Oregon | 41037 | 374 | 6 |
1062241 | 1062241 | 2021-02-24 | Lake | Oregon | 41037 | 374 | 6 |
1058996 | 1058996 | 2021-02-23 | Lake | Oregon | 41037 | 374 | 6 |
1055750 | 1055750 | 2021-02-22 | Lake | Oregon | 41037 | 374 | 6 |
1052504 | 1052504 | 2021-02-21 | Lake | Oregon | 41037 | 374 | 6 |
1049257 | 1049257 | 2021-02-20 | Lake | Oregon | 41037 | 373 | 6 |
1046010 | 1046010 | 2021-02-19 | Lake | Oregon | 41037 | 368 | 6 |
1042765 | 1042765 | 2021-02-18 | Lake | Oregon | 41037 | 367 | 6 |
1039520 | 1039520 | 2021-02-17 | Lake | Oregon | 41037 | 364 | 6 |
1036275 | 1036275 | 2021-02-16 | Lake | Oregon | 41037 | 358 | 6 |
1033030 | 1033030 | 2021-02-15 | Lake | Oregon | 41037 | 355 | 6 |
1029784 | 1029784 | 2021-02-14 | Lake | Oregon | 41037 | 350 | 6 |
1026537 | 1026537 | 2021-02-13 | Lake | Oregon | 41037 | 350 | 6 |
1023292 | 1023292 | 2021-02-12 | Lake | Oregon | 41037 | 346 | 6 |
1020047 | 1020047 | 2021-02-11 | Lake | Oregon | 41037 | 339 | 6 |
1016802 | 1016802 | 2021-02-10 | Lake | Oregon | 41037 | 328 | 6 |
1013557 | 1013557 | 2021-02-09 | Lake | Oregon | 41037 | 322 | 6 |
1010312 | 1010312 | 2021-02-08 | Lake | Oregon | 41037 | 309 | 6 |
1007066 | 1007066 | 2021-02-07 | Lake | Oregon | 41037 | 309 | 6 |
1003820 | 1003820 | 2021-02-06 | Lake | Oregon | 41037 | 307 | 6 |
1000574 | 1000574 | 2021-02-05 | Lake | Oregon | 41037 | 298 | 6 |
997328 | 997328 | 2021-02-04 | Lake | Oregon | 41037 | 283 | 6 |
994082 | 994082 | 2021-02-03 | Lake | Oregon | 41037 | 276 | 6 |
990836 | 990836 | 2021-02-02 | Lake | Oregon | 41037 | 274 | 6 |
987590 | 987590 | 2021-02-01 | Lake | Oregon | 41037 | 270 | 6 |
984343 | 984343 | 2021-01-31 | Lake | Oregon | 41037 | 268 | 6 |
981096 | 981096 | 2021-01-30 | Lake | Oregon | 41037 | 268 | 6 |
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);