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

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

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