ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,081 rows where county = "Lake" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Lake · 1,081
Link rowid date ▲ county state fips cases deaths
291961 2020-07-03 Lake California 6033 88 0
292034 2020-07-03 Lake Colorado 8065 51 0
292110 2020-07-03 Lake Florida 12069 1603 23
292400 2020-07-03 Lake Illinois 17097 9864 421
292499 2020-07-03 Lake Indiana 18089 5091 258
293026 2020-07-03 Lake Michigan 26085 9 0
293104 2020-07-03 Lake Minnesota 27075 6 0
293368 2020-07-03 Lake Montana 30047 18 0
293802 2020-07-03 Lake Ohio 39085 480 18
293941 2020-07-03 Lake Oregon 41037 20 0
294112 2020-07-03 Lake South Dakota 46079 22 1
294185 2020-07-03 Lake Tennessee 47095 691 0
288884 2020-07-02 Lake California 6033 87 0
288957 2020-07-02 Lake Colorado 8065 51 0
289033 2020-07-02 Lake Florida 12069 1508 23
289322 2020-07-02 Lake Illinois 17097 9812 421
289420 2020-07-02 Lake Indiana 18089 5023 257
289947 2020-07-02 Lake Michigan 26085 9 0
290025 2020-07-02 Lake Minnesota 27075 6 0
290289 2020-07-02 Lake Montana 30047 18 0
290721 2020-07-02 Lake Ohio 39085 443 16
290861 2020-07-02 Lake Oregon 41037 19 0
291031 2020-07-02 Lake South Dakota 46079 22 1
291104 2020-07-02 Lake Tennessee 47095 690 0
285809 2020-07-01 Lake California 6033 81 0
285882 2020-07-01 Lake Colorado 8065 51 0
285958 2020-07-01 Lake Florida 12069 1410 22
286247 2020-07-01 Lake Illinois 17097 9761 418
286345 2020-07-01 Lake Indiana 18089 4910 256
286872 2020-07-01 Lake Michigan 26085 8 0
286950 2020-07-01 Lake Minnesota 27075 6 0
287214 2020-07-01 Lake Montana 30047 18 0
287645 2020-07-01 Lake Ohio 39085 443 16
287784 2020-07-01 Lake Oregon 41037 19 0
287954 2020-07-01 Lake South Dakota 46079 21 1
288027 2020-07-01 Lake Tennessee 47095 690 0
282736 2020-06-30 Lake California 6033 62 0
282809 2020-06-30 Lake Colorado 8065 51 0
282885 2020-06-30 Lake Florida 12069 1302 22
283175 2020-06-30 Lake Illinois 17097 9719 416
283273 2020-06-30 Lake Indiana 18089 4884 255
283800 2020-06-30 Lake Michigan 26085 8 0
283878 2020-06-30 Lake Minnesota 27075 7 0
284142 2020-06-30 Lake Montana 30047 17 0
284572 2020-06-30 Lake Ohio 39085 433 17
284711 2020-06-30 Lake Oregon 41037 17 0
284881 2020-06-30 Lake South Dakota 46079 21 1
284954 2020-06-30 Lake Tennessee 47095 690 0
279667 2020-06-29 Lake California 6033 58 0
279740 2020-06-29 Lake Colorado 8065 51 0
279816 2020-06-29 Lake Florida 12069 1252 22
280103 2020-06-29 Lake Illinois 17097 9695 415
280201 2020-06-29 Lake Indiana 18089 4818 255
280727 2020-06-29 Lake Michigan 26085 7 0
280805 2020-06-29 Lake Minnesota 27075 6 0
281069 2020-06-29 Lake Montana 30047 16 0
281499 2020-06-29 Lake Ohio 39085 422 17
281637 2020-06-29 Lake Oregon 41037 15 0
281807 2020-06-29 Lake South Dakota 46079 21 1
281880 2020-06-29 Lake Tennessee 47095 691 0
276599 2020-06-28 Lake California 6033 42 0
276672 2020-06-28 Lake Colorado 8065 51 0
276748 2020-06-28 Lake Florida 12069 1192 22
277036 2020-06-28 Lake Illinois 17097 9644 415
277134 2020-06-28 Lake Indiana 18089 4778 255
277659 2020-06-28 Lake Michigan 26085 7 0
277737 2020-06-28 Lake Minnesota 27075 6 0
278001 2020-06-28 Lake Montana 30047 16 0
278431 2020-06-28 Lake Ohio 39085 415 17
278569 2020-06-28 Lake Oregon 41037 13 0
278739 2020-06-28 Lake South Dakota 46079 20 1
278812 2020-06-28 Lake Tennessee 47095 691 0
273530 2020-06-27 Lake California 6033 42 0
273603 2020-06-27 Lake Colorado 8065 50 0
273679 2020-06-27 Lake Florida 12069 1098 22
273966 2020-06-27 Lake Illinois 17097 9608 414
274064 2020-06-27 Lake Indiana 18089 4733 255
274589 2020-06-27 Lake Michigan 26085 7 0
274667 2020-06-27 Lake Minnesota 27075 5 0
274931 2020-06-27 Lake Montana 30047 12 0
275363 2020-06-27 Lake Ohio 39085 405 17
275501 2020-06-27 Lake Oregon 41037 13 0
275671 2020-06-27 Lake South Dakota 46079 19 1
275744 2020-06-27 Lake Tennessee 47095 691 0
270461 2020-06-26 Lake California 6033 42 0
270534 2020-06-26 Lake Colorado 8065 50 0
270610 2020-06-26 Lake Florida 12069 975 22
270897 2020-06-26 Lake Illinois 17097 9561 412
270995 2020-06-26 Lake Indiana 18089 4687 254
271520 2020-06-26 Lake Michigan 26085 7 0
271598 2020-06-26 Lake Minnesota 27075 5 0
271862 2020-06-26 Lake Montana 30047 12 0
272294 2020-06-26 Lake Ohio 39085 393 17
272432 2020-06-26 Lake Oregon 41037 12 0
272602 2020-06-26 Lake South Dakota 46079 19 1
272675 2020-06-26 Lake Tennessee 47095 691 0
267400 2020-06-25 Lake California 6033 42 0
267473 2020-06-25 Lake Colorado 8065 50 0
267549 2020-06-25 Lake Florida 12069 881 21
267834 2020-06-25 Lake Illinois 17097 9514 411

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 944.939ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette