search

cynkra / sdtools

tools to work with swissdata sets
1 stars 0 forks source link

Function to list all datasets available from the current S3 #20

Open mbannert opened 5 years ago

christophsax commented 5 years ago

See what's available on swissdata by reading logs_swissdata_summary.csv:

readr::read_csv("https://sos-ch-dk-2.exo.io/swissdata/logs_swissdata_summary.csv", col_types = readr::cols())
#> # A tibble: 97 x 8
#>    set_id_source set_id source     updated_utc         time_test          
#>    <chr>         <chr>  <date>     <dttm>              <dttm>             
#>  1 ch.fso.cpi    ch_fs… 2019-10-02 2019-10-02 07:15:49 2019-10-03 16:09:53
#>  2 ch.fso.rtt    ch_fs… 2019-10-01 2019-10-01 07:16:24 2019-10-03 16:09:53
#>  3 ch.snb.devkum ch_sn… 2019-10-01 2019-10-02 07:16:52 2019-10-03 16:09:53
#>  4 ch.snb.rendo… ch_sn… 2019-10-01 2019-10-02 07:16:57 2019-10-03 16:09:53
#>  5 ch.snb.zimoma ch_sn… 2019-10-01 2019-10-02 07:17:07 2019-10-03 16:09:53
#>  6 ch.snb.snbbi… ch_sn… 2019-09-30 2019-09-30 07:16:50 2019-10-03 16:09:53
#>  7 ch.fso.cah.i… ch_fs… 2019-09-27 2019-09-28 10:00:33 2019-10-03 16:09:53
#>  8 ch.snb.bakre… ch_sn… 2019-09-26 2019-09-26 10:16:52 2019-10-03 16:09:53
#>  9 ch.snb.bakre… ch_sn… 2019-09-26 2019-09-26 10:16:55 2019-10-03 16:09:53
#> 10 ch.snb.bakre… ch_sn… 2019-09-26 2019-09-26 10:17:00 2019-10-03 16:09:53
#> # … with 87 more rows, and 3 more variables: days_since <dbl>,
#> #   error_run <chr>, error_test <chr>

And on dataseries:

readr::read_csv("https://sos-ch-dk-2.exo.io/dataseries/logs_dataseries_summary.csv", col_types = readr::cols())
#> # A tibble: 26 x 12
#>    set_id_source set_id_sd source     updated_utc        
#>    <chr>         <chr>     <date>     <dttm>             
#>  1 ch.adecco.sj… ch_adecc… NA         NA                 
#>  2 ch.fso.es.no… ch_fso_e… 2019-09-19 2019-09-19 07:15:49
#>  3 ch.fso.es.rs  ch_fso_e… 2019-08-20 2019-08-27 07:05:22
#>  4 ch.fso.besta… ch_fso_b… 2019-08-29 2019-08-29 10:15:28
#>  5 ch.fso.besta  ch_fso_b… 2019-08-29 2019-08-29 10:15:21
#>  6 ch.snb.snbmo… ch_snb_s… 2019-09-26 2019-09-26 07:17:05
#>  7 ch.snb.snbmo… ch_snb_s… 2019-09-23 2019-09-23 07:17:27
#>  8 ch.fso.besta… ch_fso_b… 2019-08-29 2019-08-29 07:15:10
#>  9 ch.fso.besta… ch_fso_b… 2019-08-29 2019-08-29 07:15:10
#> 10 ch.fso.besta… ch_fso_b… 2019-08-29 2019-08-29 10:15:25
#> # … with 16 more rows, and 8 more variables: time_test <dttm>,
#> #   days_since <dbl>, error_run <lgl>, error_test <chr>, set_id <chr>,
#> #   error_ds <lgl>, time_ds <dttm>, time_aws <dttm>

Created on 2019-10-03 by the reprex package (v0.3.0)