ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Tioga" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501905 | 2501905 | 2022-05-13 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2498647 | 2498647 | 2022-05-12 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2495389 | 2495389 | 2022-05-11 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2492131 | 2492131 | 2022-05-10 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2488873 | 2488873 | 2022-05-09 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2485616 | 2485616 | 2022-05-08 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2482358 | 2482358 | 2022-05-07 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2479100 | 2479100 | 2022-05-06 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2475842 | 2475842 | 2022-05-05 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2472585 | 2472585 | 2022-05-04 | Tioga | Pennsylvania | 42117 | 8187 | 193 |
2469329 | 2469329 | 2022-05-03 | Tioga | Pennsylvania | 42117 | 8165 | 193 |
2466073 | 2466073 | 2022-05-02 | Tioga | Pennsylvania | 42117 | 8156 | 193 |
2462818 | 2462818 | 2022-05-01 | Tioga | Pennsylvania | 42117 | 8151 | 193 |
2459562 | 2459562 | 2022-04-30 | Tioga | Pennsylvania | 42117 | 8149 | 193 |
2456306 | 2456306 | 2022-04-29 | Tioga | Pennsylvania | 42117 | 8145 | 193 |
2453050 | 2453050 | 2022-04-28 | Tioga | Pennsylvania | 42117 | 8137 | 192 |
2449794 | 2449794 | 2022-04-27 | Tioga | Pennsylvania | 42117 | 8128 | 192 |
2446537 | 2446537 | 2022-04-26 | Tioga | Pennsylvania | 42117 | 8119 | 192 |
2443282 | 2443282 | 2022-04-25 | Tioga | Pennsylvania | 42117 | 8113 | 192 |
2440026 | 2440026 | 2022-04-24 | Tioga | Pennsylvania | 42117 | 8109 | 192 |
2436770 | 2436770 | 2022-04-23 | Tioga | Pennsylvania | 42117 | 8107 | 192 |
2433514 | 2433514 | 2022-04-22 | Tioga | Pennsylvania | 42117 | 8096 | 192 |
2430258 | 2430258 | 2022-04-21 | Tioga | Pennsylvania | 42117 | 8091 | 192 |
2427002 | 2427002 | 2022-04-20 | Tioga | Pennsylvania | 42117 | 8081 | 192 |
2423746 | 2423746 | 2022-04-19 | Tioga | Pennsylvania | 42117 | 8077 | 192 |
2420490 | 2420490 | 2022-04-18 | Tioga | Pennsylvania | 42117 | 8073 | 192 |
2417234 | 2417234 | 2022-04-17 | Tioga | Pennsylvania | 42117 | 8070 | 192 |
2413978 | 2413978 | 2022-04-16 | Tioga | Pennsylvania | 42117 | 8068 | 192 |
2410722 | 2410722 | 2022-04-15 | Tioga | Pennsylvania | 42117 | 8061 | 192 |
2407466 | 2407466 | 2022-04-14 | Tioga | Pennsylvania | 42117 | 8049 | 192 |
2404210 | 2404210 | 2022-04-13 | Tioga | Pennsylvania | 42117 | 8038 | 192 |
2400955 | 2400955 | 2022-04-12 | Tioga | Pennsylvania | 42117 | 8027 | 192 |
2397700 | 2397700 | 2022-04-11 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2394445 | 2394445 | 2022-04-10 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2391189 | 2391189 | 2022-04-09 | Tioga | Pennsylvania | 42117 | 8019 | 192 |
2387933 | 2387933 | 2022-04-08 | Tioga | Pennsylvania | 42117 | 8013 | 192 |
2384678 | 2384678 | 2022-04-07 | Tioga | Pennsylvania | 42117 | 8011 | 192 |
2381423 | 2381423 | 2022-04-06 | Tioga | Pennsylvania | 42117 | 8007 | 192 |
2378168 | 2378168 | 2022-04-05 | Tioga | Pennsylvania | 42117 | 8002 | 192 |
2374914 | 2374914 | 2022-04-04 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2371662 | 2371662 | 2022-04-03 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2368409 | 2368409 | 2022-04-02 | Tioga | Pennsylvania | 42117 | 7999 | 192 |
2365156 | 2365156 | 2022-04-01 | Tioga | Pennsylvania | 42117 | 7997 | 192 |
2361903 | 2361903 | 2022-03-31 | Tioga | Pennsylvania | 42117 | 7991 | 192 |
2358649 | 2358649 | 2022-03-30 | Tioga | Pennsylvania | 42117 | 7987 | 192 |
2355395 | 2355395 | 2022-03-29 | Tioga | Pennsylvania | 42117 | 7984 | 192 |
2352142 | 2352142 | 2022-03-28 | Tioga | Pennsylvania | 42117 | 7982 | 192 |
2348890 | 2348890 | 2022-03-27 | Tioga | Pennsylvania | 42117 | 7981 | 192 |
2345637 | 2345637 | 2022-03-26 | Tioga | Pennsylvania | 42117 | 7981 | 192 |
2342384 | 2342384 | 2022-03-25 | Tioga | Pennsylvania | 42117 | 7978 | 192 |
2339131 | 2339131 | 2022-03-24 | Tioga | Pennsylvania | 42117 | 7974 | 191 |
2335877 | 2335877 | 2022-03-23 | Tioga | Pennsylvania | 42117 | 7956 | 191 |
2332623 | 2332623 | 2022-03-22 | Tioga | Pennsylvania | 42117 | 7952 | 191 |
2329370 | 2329370 | 2022-03-21 | Tioga | Pennsylvania | 42117 | 7949 | 191 |
2326118 | 2326118 | 2022-03-20 | Tioga | Pennsylvania | 42117 | 7948 | 191 |
2322865 | 2322865 | 2022-03-19 | Tioga | Pennsylvania | 42117 | 7946 | 191 |
2319611 | 2319611 | 2022-03-18 | Tioga | Pennsylvania | 42117 | 7943 | 191 |
2316357 | 2316357 | 2022-03-17 | Tioga | Pennsylvania | 42117 | 7939 | 191 |
2313104 | 2313104 | 2022-03-16 | Tioga | Pennsylvania | 42117 | 7936 | 190 |
2309851 | 2309851 | 2022-03-15 | Tioga | Pennsylvania | 42117 | 7928 | 190 |
2306598 | 2306598 | 2022-03-14 | Tioga | Pennsylvania | 42117 | 7927 | 190 |
2303347 | 2303347 | 2022-03-13 | Tioga | Pennsylvania | 42117 | 7924 | 190 |
2300095 | 2300095 | 2022-03-12 | Tioga | Pennsylvania | 42117 | 7921 | 190 |
2296843 | 2296843 | 2022-03-11 | Tioga | Pennsylvania | 42117 | 7917 | 190 |
2293591 | 2293591 | 2022-03-10 | Tioga | Pennsylvania | 42117 | 7912 | 190 |
2290339 | 2290339 | 2022-03-09 | Tioga | Pennsylvania | 42117 | 7909 | 190 |
2287087 | 2287087 | 2022-03-08 | Tioga | Pennsylvania | 42117 | 7901 | 190 |
2283835 | 2283835 | 2022-03-07 | Tioga | Pennsylvania | 42117 | 7888 | 189 |
2280583 | 2280583 | 2022-03-06 | Tioga | Pennsylvania | 42117 | 7888 | 189 |
2277330 | 2277330 | 2022-03-05 | Tioga | Pennsylvania | 42117 | 7886 | 189 |
2274077 | 2274077 | 2022-03-04 | Tioga | Pennsylvania | 42117 | 7883 | 189 |
2270824 | 2270824 | 2022-03-03 | Tioga | Pennsylvania | 42117 | 7880 | 189 |
2267572 | 2267572 | 2022-03-02 | Tioga | Pennsylvania | 42117 | 7874 | 189 |
2264319 | 2264319 | 2022-03-01 | Tioga | Pennsylvania | 42117 | 7864 | 188 |
2261069 | 2261069 | 2022-02-28 | Tioga | Pennsylvania | 42117 | 7853 | 188 |
2257818 | 2257818 | 2022-02-27 | Tioga | Pennsylvania | 42117 | 7852 | 188 |
2254567 | 2254567 | 2022-02-26 | Tioga | Pennsylvania | 42117 | 7846 | 188 |
2251316 | 2251316 | 2022-02-25 | Tioga | Pennsylvania | 42117 | 7841 | 188 |
2248065 | 2248065 | 2022-02-24 | Tioga | Pennsylvania | 42117 | 7834 | 188 |
2244814 | 2244814 | 2022-02-23 | Tioga | Pennsylvania | 42117 | 7827 | 187 |
2241563 | 2241563 | 2022-02-22 | Tioga | Pennsylvania | 42117 | 7814 | 187 |
2238312 | 2238312 | 2022-02-21 | Tioga | Pennsylvania | 42117 | 7803 | 187 |
2235061 | 2235061 | 2022-02-20 | Tioga | Pennsylvania | 42117 | 7803 | 187 |
2231810 | 2231810 | 2022-02-19 | Tioga | Pennsylvania | 42117 | 7798 | 187 |
2228559 | 2228559 | 2022-02-18 | Tioga | Pennsylvania | 42117 | 7786 | 187 |
2225308 | 2225308 | 2022-02-17 | Tioga | Pennsylvania | 42117 | 7777 | 187 |
2222057 | 2222057 | 2022-02-16 | Tioga | Pennsylvania | 42117 | 7769 | 187 |
2218806 | 2218806 | 2022-02-15 | Tioga | Pennsylvania | 42117 | 7753 | 187 |
2215555 | 2215555 | 2022-02-14 | Tioga | Pennsylvania | 42117 | 7745 | 187 |
2212304 | 2212304 | 2022-02-13 | Tioga | Pennsylvania | 42117 | 7740 | 187 |
2209051 | 2209051 | 2022-02-12 | Tioga | Pennsylvania | 42117 | 7725 | 187 |
2205798 | 2205798 | 2022-02-11 | Tioga | Pennsylvania | 42117 | 7703 | 187 |
2202545 | 2202545 | 2022-02-10 | Tioga | Pennsylvania | 42117 | 7692 | 187 |
2199291 | 2199291 | 2022-02-09 | Tioga | Pennsylvania | 42117 | 7665 | 187 |
2196037 | 2196037 | 2022-02-08 | Tioga | Pennsylvania | 42117 | 7637 | 187 |
2192783 | 2192783 | 2022-02-07 | Tioga | Pennsylvania | 42117 | 7640 | 186 |
2189529 | 2189529 | 2022-02-06 | Tioga | Pennsylvania | 42117 | 7626 | 186 |
2186276 | 2186276 | 2022-02-05 | Tioga | Pennsylvania | 42117 | 7621 | 186 |
2183024 | 2183024 | 2022-02-04 | Tioga | Pennsylvania | 42117 | 7591 | 186 |
2179772 | 2179772 | 2022-02-03 | Tioga | Pennsylvania | 42117 | 7564 | 185 |
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);