ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,568 rows where county = "Tioga" 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 |
---|---|---|---|---|---|---|---|
2501477 | 2501477 | 2022-05-13 | Tioga | New York | 36107 | 11719 | 85 |
2501905 | 2501905 | 2022-05-13 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2498219 | 2498219 | 2022-05-12 | Tioga | New York | 36107 | 11719 | 84 |
2498647 | 2498647 | 2022-05-12 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2494961 | 2494961 | 2022-05-11 | Tioga | New York | 36107 | 11686 | 84 |
2495389 | 2495389 | 2022-05-11 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2491703 | 2491703 | 2022-05-10 | Tioga | New York | 36107 | 11652 | 84 |
2492131 | 2492131 | 2022-05-10 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2488445 | 2488445 | 2022-05-09 | Tioga | New York | 36107 | 11625 | 83 |
2488873 | 2488873 | 2022-05-09 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2485188 | 2485188 | 2022-05-08 | Tioga | New York | 36107 | 11619 | 83 |
2485616 | 2485616 | 2022-05-08 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2481930 | 2481930 | 2022-05-07 | Tioga | New York | 36107 | 11592 | 83 |
2482358 | 2482358 | 2022-05-07 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2478672 | 2478672 | 2022-05-06 | Tioga | New York | 36107 | 11549 | 83 |
2479100 | 2479100 | 2022-05-06 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2475414 | 2475414 | 2022-05-05 | Tioga | New York | 36107 | 11511 | 83 |
2475842 | 2475842 | 2022-05-05 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2472157 | 2472157 | 2022-05-04 | Tioga | New York | 36107 | 11482 | 83 |
2472585 | 2472585 | 2022-05-04 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2468901 | 2468901 | 2022-05-03 | Tioga | New York | 36107 | 11440 | 83 |
2469329 | 2469329 | 2022-05-03 | Tioga | Pennsylvania | 42117 | 8165 | 193 |
2465645 | 2465645 | 2022-05-02 | Tioga | New York | 36107 | 11422 | 83 |
2466073 | 2466073 | 2022-05-02 | Tioga | Pennsylvania | 42117 | 8156 | 193 |
2462390 | 2462390 | 2022-05-01 | Tioga | New York | 36107 | 11400 | 83 |
2462818 | 2462818 | 2022-05-01 | Tioga | Pennsylvania | 42117 | 8151 | 193 |
2459134 | 2459134 | 2022-04-30 | Tioga | New York | 36107 | 11366 | 83 |
2459562 | 2459562 | 2022-04-30 | Tioga | Pennsylvania | 42117 | 8149 | 193 |
2455878 | 2455878 | 2022-04-29 | Tioga | New York | 36107 | 11338 | 83 |
2456306 | 2456306 | 2022-04-29 | Tioga | Pennsylvania | 42117 | 8145 | 193 |
2452622 | 2452622 | 2022-04-28 | Tioga | New York | 36107 | 11310 | 83 |
2453050 | 2453050 | 2022-04-28 | Tioga | Pennsylvania | 42117 | 8137 | 192 |
2449366 | 2449366 | 2022-04-27 | Tioga | New York | 36107 | 11272 | 83 |
2449794 | 2449794 | 2022-04-27 | Tioga | Pennsylvania | 42117 | 8128 | 192 |
2446109 | 2446109 | 2022-04-26 | Tioga | New York | 36107 | 11227 | 83 |
2446537 | 2446537 | 2022-04-26 | Tioga | Pennsylvania | 42117 | 8119 | 192 |
2442854 | 2442854 | 2022-04-25 | Tioga | New York | 36107 | 11211 | 82 |
2443282 | 2443282 | 2022-04-25 | Tioga | Pennsylvania | 42117 | 8113 | 192 |
2439598 | 2439598 | 2022-04-24 | Tioga | New York | 36107 | 11194 | 82 |
2440026 | 2440026 | 2022-04-24 | Tioga | Pennsylvania | 42117 | 8109 | 192 |
2436342 | 2436342 | 2022-04-23 | Tioga | New York | 36107 | 11161 | 82 |
2436770 | 2436770 | 2022-04-23 | Tioga | Pennsylvania | 42117 | 8107 | 192 |
2433086 | 2433086 | 2022-04-22 | Tioga | New York | 36107 | 11130 | 82 |
2433514 | 2433514 | 2022-04-22 | Tioga | Pennsylvania | 42117 | 8096 | 192 |
2429830 | 2429830 | 2022-04-21 | Tioga | New York | 36107 | 11097 | 82 |
2430258 | 2430258 | 2022-04-21 | Tioga | Pennsylvania | 42117 | 8091 | 192 |
2426574 | 2426574 | 2022-04-20 | Tioga | New York | 36107 | 11054 | 82 |
2427002 | 2427002 | 2022-04-20 | Tioga | Pennsylvania | 42117 | 8081 | 192 |
2423318 | 2423318 | 2022-04-19 | Tioga | New York | 36107 | 11026 | 82 |
2423746 | 2423746 | 2022-04-19 | Tioga | Pennsylvania | 42117 | 8077 | 192 |
2420061 | 2420061 | 2022-04-18 | Tioga | New York | 36107 | 11014 | 82 |
2420490 | 2420490 | 2022-04-18 | Tioga | Pennsylvania | 42117 | 8073 | 192 |
2416806 | 2416806 | 2022-04-17 | Tioga | New York | 36107 | 11005 | 82 |
2417234 | 2417234 | 2022-04-17 | Tioga | Pennsylvania | 42117 | 8070 | 192 |
2413550 | 2413550 | 2022-04-16 | Tioga | New York | 36107 | 10983 | 82 |
2413978 | 2413978 | 2022-04-16 | Tioga | Pennsylvania | 42117 | 8068 | 192 |
2410294 | 2410294 | 2022-04-15 | Tioga | New York | 36107 | 10944 | 82 |
2410722 | 2410722 | 2022-04-15 | Tioga | Pennsylvania | 42117 | 8061 | 192 |
2407038 | 2407038 | 2022-04-14 | Tioga | New York | 36107 | 10913 | 82 |
2407466 | 2407466 | 2022-04-14 | Tioga | Pennsylvania | 42117 | 8049 | 192 |
2403782 | 2403782 | 2022-04-13 | Tioga | New York | 36107 | 10892 | 82 |
2404210 | 2404210 | 2022-04-13 | Tioga | Pennsylvania | 42117 | 8038 | 192 |
2400527 | 2400527 | 2022-04-12 | Tioga | New York | 36107 | 10858 | 82 |
2400955 | 2400955 | 2022-04-12 | Tioga | Pennsylvania | 42117 | 8027 | 192 |
2397272 | 2397272 | 2022-04-11 | Tioga | New York | 36107 | 10846 | 82 |
2397700 | 2397700 | 2022-04-11 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2394017 | 2394017 | 2022-04-10 | Tioga | New York | 36107 | 10834 | 82 |
2394445 | 2394445 | 2022-04-10 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2390761 | 2390761 | 2022-04-09 | Tioga | New York | 36107 | 10819 | 82 |
2391189 | 2391189 | 2022-04-09 | Tioga | Pennsylvania | 42117 | 8019 | 192 |
2387505 | 2387505 | 2022-04-08 | Tioga | New York | 36107 | 10798 | 82 |
2387933 | 2387933 | 2022-04-08 | Tioga | Pennsylvania | 42117 | 8013 | 192 |
2384250 | 2384250 | 2022-04-07 | Tioga | New York | 36107 | 10778 | 82 |
2384678 | 2384678 | 2022-04-07 | Tioga | Pennsylvania | 42117 | 8011 | 192 |
2380995 | 2380995 | 2022-04-06 | Tioga | New York | 36107 | 10757 | 82 |
2381423 | 2381423 | 2022-04-06 | Tioga | Pennsylvania | 42117 | 8007 | 192 |
2377740 | 2377740 | 2022-04-05 | Tioga | New York | 36107 | 10740 | 82 |
2378168 | 2378168 | 2022-04-05 | Tioga | Pennsylvania | 42117 | 8002 | 192 |
2374487 | 2374487 | 2022-04-04 | Tioga | New York | 36107 | 10729 | 82 |
2374914 | 2374914 | 2022-04-04 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2371235 | 2371235 | 2022-04-03 | Tioga | New York | 36107 | 10723 | 82 |
2371662 | 2371662 | 2022-04-03 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2367982 | 2367982 | 2022-04-02 | Tioga | New York | 36107 | 10714 | 82 |
2368409 | 2368409 | 2022-04-02 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2364729 | 2364729 | 2022-04-01 | Tioga | New York | 36107 | 10703 | 82 |
2365156 | 2365156 | 2022-04-01 | Tioga | Pennsylvania | 42117 | 7997 | 192 |
2361475 | 2361475 | 2022-03-31 | Tioga | New York | 36107 | 10694 | 82 |
2361903 | 2361903 | 2022-03-31 | Tioga | Pennsylvania | 42117 | 7991 | 192 |
2358221 | 2358221 | 2022-03-30 | Tioga | New York | 36107 | 10686 | 82 |
2358649 | 2358649 | 2022-03-30 | Tioga | Pennsylvania | 42117 | 7987 | 192 |
2354967 | 2354967 | 2022-03-29 | Tioga | New York | 36107 | 10671 | 82 |
2355395 | 2355395 | 2022-03-29 | Tioga | Pennsylvania | 42117 | 7984 | 192 |
2351714 | 2351714 | 2022-03-28 | Tioga | New York | 36107 | 10667 | 82 |
2352142 | 2352142 | 2022-03-28 | Tioga | Pennsylvania | 42117 | 7982 | 192 |
2348462 | 2348462 | 2022-03-27 | Tioga | New York | 36107 | 10667 | 82 |
2348890 | 2348890 | 2022-03-27 | Tioga | Pennsylvania | 42117 | 7981 | 192 |
2345209 | 2345209 | 2022-03-26 | Tioga | New York | 36107 | 10656 | 82 |
2345637 | 2345637 | 2022-03-26 | Tioga | Pennsylvania | 42117 | 7981 | 192 |
2341956 | 2341956 | 2022-03-25 | Tioga | New York | 36107 | 10650 | 82 |
2342384 | 2342384 | 2022-03-25 | Tioga | Pennsylvania | 42117 | 7978 | 192 |
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);