ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Winnebago" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537635 | 537635 | 2020-09-15 | Winnebago | Wisconsin | 55139 | 2205 | 22 |
534399 | 534399 | 2020-09-14 | Winnebago | Wisconsin | 55139 | 2123 | 22 |
531164 | 531164 | 2020-09-13 | Winnebago | Wisconsin | 55139 | 2100 | 22 |
527927 | 527927 | 2020-09-12 | Winnebago | Wisconsin | 55139 | 2029 | 22 |
524691 | 524691 | 2020-09-11 | Winnebago | Wisconsin | 55139 | 1964 | 22 |
521455 | 521455 | 2020-09-10 | Winnebago | Wisconsin | 55139 | 1882 | 22 |
518218 | 518218 | 2020-09-09 | Winnebago | Wisconsin | 55139 | 1851 | 22 |
514983 | 514983 | 2020-09-08 | Winnebago | Wisconsin | 55139 | 1834 | 21 |
511750 | 511750 | 2020-09-07 | Winnebago | Wisconsin | 55139 | 1816 | 21 |
508517 | 508517 | 2020-09-06 | Winnebago | Wisconsin | 55139 | 1797 | 21 |
505285 | 505285 | 2020-09-05 | Winnebago | Wisconsin | 55139 | 1765 | 21 |
502051 | 502051 | 2020-09-04 | Winnebago | Wisconsin | 55139 | 1744 | 21 |
498817 | 498817 | 2020-09-03 | Winnebago | Wisconsin | 55139 | 1597 | 21 |
495584 | 495584 | 2020-09-02 | Winnebago | Wisconsin | 55139 | 1569 | 21 |
492350 | 492350 | 2020-09-01 | Winnebago | Wisconsin | 55139 | 1555 | 21 |
489117 | 489117 | 2020-08-31 | Winnebago | Wisconsin | 55139 | 1528 | 21 |
485884 | 485884 | 2020-08-30 | Winnebago | Wisconsin | 55139 | 1512 | 21 |
482649 | 482649 | 2020-08-29 | Winnebago | Wisconsin | 55139 | 1493 | 21 |
479415 | 479415 | 2020-08-28 | Winnebago | Wisconsin | 55139 | 1461 | 21 |
476182 | 476182 | 2020-08-27 | Winnebago | Wisconsin | 55139 | 1433 | 21 |
472949 | 472949 | 2020-08-26 | Winnebago | Wisconsin | 55139 | 1402 | 21 |
469717 | 469717 | 2020-08-25 | Winnebago | Wisconsin | 55139 | 1383 | 21 |
466488 | 466488 | 2020-08-24 | Winnebago | Wisconsin | 55139 | 1371 | 20 |
463259 | 463259 | 2020-08-23 | Winnebago | Wisconsin | 55139 | 1361 | 20 |
460030 | 460030 | 2020-08-22 | Winnebago | Wisconsin | 55139 | 1350 | 20 |
456803 | 456803 | 2020-08-21 | Winnebago | Wisconsin | 55139 | 1335 | 19 |
453575 | 453575 | 2020-08-20 | Winnebago | Wisconsin | 55139 | 1321 | 19 |
450347 | 450347 | 2020-08-19 | Winnebago | Wisconsin | 55139 | 1309 | 19 |
447119 | 447119 | 2020-08-18 | Winnebago | Wisconsin | 55139 | 1293 | 19 |
443892 | 443892 | 2020-08-17 | Winnebago | Wisconsin | 55139 | 1288 | 19 |
440666 | 440666 | 2020-08-16 | Winnebago | Wisconsin | 55139 | 1280 | 19 |
437440 | 437440 | 2020-08-15 | Winnebago | Wisconsin | 55139 | 1263 | 19 |
434214 | 434214 | 2020-08-14 | Winnebago | Wisconsin | 55139 | 1248 | 19 |
430989 | 430989 | 2020-08-13 | Winnebago | Wisconsin | 55139 | 1235 | 18 |
427761 | 427761 | 2020-08-12 | Winnebago | Wisconsin | 55139 | 1216 | 18 |
424537 | 424537 | 2020-08-11 | Winnebago | Wisconsin | 55139 | 1212 | 18 |
421316 | 421316 | 2020-08-10 | Winnebago | Wisconsin | 55139 | 1193 | 18 |
418095 | 418095 | 2020-08-09 | Winnebago | Wisconsin | 55139 | 1176 | 18 |
414874 | 414874 | 2020-08-08 | Winnebago | Wisconsin | 55139 | 1164 | 18 |
411654 | 411654 | 2020-08-07 | Winnebago | Wisconsin | 55139 | 1124 | 18 |
408435 | 408435 | 2020-08-06 | Winnebago | Wisconsin | 55139 | 1111 | 18 |
405215 | 405215 | 2020-08-05 | Winnebago | Wisconsin | 55139 | 1094 | 18 |
401997 | 401997 | 2020-08-04 | Winnebago | Wisconsin | 55139 | 1082 | 18 |
398781 | 398781 | 2020-08-03 | Winnebago | Wisconsin | 55139 | 1063 | 18 |
395565 | 395565 | 2020-08-02 | Winnebago | Wisconsin | 55139 | 1055 | 17 |
392349 | 392349 | 2020-08-01 | Winnebago | Wisconsin | 55139 | 1041 | 17 |
389132 | 389132 | 2020-07-31 | Winnebago | Wisconsin | 55139 | 1014 | 17 |
385915 | 385915 | 2020-07-30 | Winnebago | Wisconsin | 55139 | 997 | 16 |
382697 | 382697 | 2020-07-29 | Winnebago | Wisconsin | 55139 | 978 | 16 |
379480 | 379480 | 2020-07-28 | Winnebago | Wisconsin | 55139 | 970 | 16 |
376264 | 376264 | 2020-07-27 | Winnebago | Wisconsin | 55139 | 960 | 16 |
373050 | 373050 | 2020-07-26 | Winnebago | Wisconsin | 55139 | 954 | 16 |
369838 | 369838 | 2020-07-25 | Winnebago | Wisconsin | 55139 | 931 | 16 |
366628 | 366628 | 2020-07-24 | Winnebago | Wisconsin | 55139 | 913 | 16 |
363421 | 363421 | 2020-07-23 | Winnebago | Wisconsin | 55139 | 901 | 16 |
360215 | 360215 | 2020-07-22 | Winnebago | Wisconsin | 55139 | 884 | 15 |
357010 | 357010 | 2020-07-21 | Winnebago | Wisconsin | 55139 | 876 | 14 |
353807 | 353807 | 2020-07-20 | Winnebago | Wisconsin | 55139 | 864 | 14 |
350605 | 350605 | 2020-07-19 | Winnebago | Wisconsin | 55139 | 847 | 14 |
347404 | 347404 | 2020-07-18 | Winnebago | Wisconsin | 55139 | 833 | 14 |
344204 | 344204 | 2020-07-17 | Winnebago | Wisconsin | 55139 | 817 | 14 |
341005 | 341005 | 2020-07-16 | Winnebago | Wisconsin | 55139 | 810 | 14 |
337809 | 337809 | 2020-07-15 | Winnebago | Wisconsin | 55139 | 804 | 14 |
334614 | 334614 | 2020-07-14 | Winnebago | Wisconsin | 55139 | 788 | 14 |
331421 | 331421 | 2020-07-13 | Winnebago | Wisconsin | 55139 | 777 | 13 |
328235 | 328235 | 2020-07-12 | Winnebago | Wisconsin | 55139 | 771 | 13 |
325049 | 325049 | 2020-07-11 | Winnebago | Wisconsin | 55139 | 760 | 13 |
321868 | 321868 | 2020-07-10 | Winnebago | Wisconsin | 55139 | 755 | 13 |
318689 | 318689 | 2020-07-09 | Winnebago | Wisconsin | 55139 | 747 | 13 |
315516 | 315516 | 2020-07-08 | Winnebago | Wisconsin | 55139 | 726 | 13 |
312341 | 312341 | 2020-07-07 | Winnebago | Wisconsin | 55139 | 723 | 13 |
309172 | 309172 | 2020-07-06 | Winnebago | Wisconsin | 55139 | 715 | 13 |
306003 | 306003 | 2020-07-05 | Winnebago | Wisconsin | 55139 | 711 | 13 |
302839 | 302839 | 2020-07-04 | Winnebago | Wisconsin | 55139 | 701 | 13 |
299675 | 299675 | 2020-07-03 | Winnebago | Wisconsin | 55139 | 692 | 13 |
296513 | 296513 | 2020-07-02 | Winnebago | Wisconsin | 55139 | 692 | 11 |
293358 | 293358 | 2020-07-01 | Winnebago | Wisconsin | 55139 | 683 | 11 |
290205 | 290205 | 2020-06-30 | Winnebago | Wisconsin | 55139 | 669 | 11 |
287055 | 287055 | 2020-06-29 | Winnebago | Wisconsin | 55139 | 662 | 11 |
283909 | 283909 | 2020-06-28 | Winnebago | Wisconsin | 55139 | 655 | 11 |
280763 | 280763 | 2020-06-27 | Winnebago | Wisconsin | 55139 | 643 | 11 |
277615 | 277615 | 2020-06-26 | Winnebago | Wisconsin | 55139 | 639 | 11 |
274467 | 274467 | 2020-06-25 | Winnebago | Wisconsin | 55139 | 634 | 11 |
271327 | 271327 | 2020-06-24 | Winnebago | Wisconsin | 55139 | 626 | 11 |
268193 | 268193 | 2020-06-23 | Winnebago | Wisconsin | 55139 | 619 | 11 |
265064 | 265064 | 2020-06-22 | Winnebago | Wisconsin | 55139 | 608 | 11 |
261935 | 261935 | 2020-06-21 | Winnebago | Wisconsin | 55139 | 601 | 11 |
258808 | 258808 | 2020-06-20 | Winnebago | Wisconsin | 55139 | 593 | 11 |
255681 | 255681 | 2020-06-19 | Winnebago | Wisconsin | 55139 | 579 | 10 |
252562 | 252562 | 2020-06-18 | Winnebago | Wisconsin | 55139 | 569 | 10 |
249447 | 249447 | 2020-06-17 | Winnebago | Wisconsin | 55139 | 551 | 10 |
246335 | 246335 | 2020-06-16 | Winnebago | Wisconsin | 55139 | 537 | 9 |
243222 | 243222 | 2020-06-15 | Winnebago | Wisconsin | 55139 | 532 | 9 |
240111 | 240111 | 2020-06-14 | Winnebago | Wisconsin | 55139 | 518 | 9 |
237003 | 237003 | 2020-06-13 | Winnebago | Wisconsin | 55139 | 506 | 9 |
233896 | 233896 | 2020-06-12 | Winnebago | Wisconsin | 55139 | 485 | 9 |
230791 | 230791 | 2020-06-11 | Winnebago | Wisconsin | 55139 | 473 | 8 |
227687 | 227687 | 2020-06-10 | Winnebago | Wisconsin | 55139 | 457 | 8 |
224586 | 224586 | 2020-06-09 | Winnebago | Wisconsin | 55139 | 431 | 7 |
221490 | 221490 | 2020-06-08 | Winnebago | Wisconsin | 55139 | 397 | 7 |
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);