participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
583 rows where station_code = "BE000N" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
3259414 | 3259414 | 20231023050755_SrB56 | BE000N | 2024-01-06T00:03:22.567Z | 2024-01-06T00:03:22.567Z |
3258746 | 3258746 | 20231023041741_ZruEr | BE000N | 2024-01-06T00:03:22.474Z | 2024-01-06T00:03:22.474Z |
3257987 | 3257987 | 20231023033902_qants | BE000N | 2024-01-06T00:03:22.375Z | 2024-01-06T00:03:22.375Z |
3257796 | 3257796 | 20231023033059_nEUcu | BE000N | 2024-01-06T00:03:22.350Z | 2024-01-06T00:03:22.350Z |
3257543 | 3257543 | 20231023032049_Ih3z2 | BE000N | 2024-01-06T00:03:22.322Z | 2024-01-06T00:03:22.322Z |
3257460 | 3257460 | 20231023031732_pY2uO | BE000N | 2024-01-06T00:03:22.313Z | 2024-01-06T00:03:22.313Z |
3256872 | 3256872 | 20231023025225_k43qv | BE000N | 2024-01-06T00:03:22.224Z | 2024-01-06T00:03:22.224Z |
3256012 | 3256012 | 20231023022115_mjgjG | BE000N | 2024-01-06T00:03:22.086Z | 2024-01-06T00:03:22.086Z |
3254357 | 3254357 | 20231023013055_XfKJy | BE000N | 2024-01-06T00:03:21.786Z | 2024-01-06T00:03:21.786Z |
3253735 | 3253735 | 20231023011222_dByZF | BE000N | 2024-01-06T00:03:21.669Z | 2024-01-06T00:03:21.669Z |
3253704 | 3253704 | 20231023011132_0tahU | BE000N | 2024-01-06T00:03:21.663Z | 2024-01-06T00:03:21.663Z |
3253318 | 3253318 | 20231023005559_QuDsO | BE000N | 2024-01-06T00:03:21.569Z | 2024-01-06T00:03:21.569Z |
3253217 | 3253217 | 20231023005320_phGgg | BE000N | 2024-01-06T00:03:21.549Z | 2024-01-06T00:03:21.549Z |
3253161 | 3253161 | 20231023005054_chXAA | BE000N | 2024-01-06T00:03:21.537Z | 2024-01-06T00:03:21.537Z |
3252676 | 3252676 | 20231023003240_pfcTN | BE000N | 2024-01-06T00:03:21.438Z | 2024-01-06T00:03:21.438Z |
3252578 | 3252578 | 20231023002932_3Zv2F | BE000N | 2024-01-06T00:03:21.417Z | 2024-01-06T00:03:21.417Z |
3252186 | 3252186 | 20231023001254_ZRQIe | BE000N | 2024-01-06T00:03:21.337Z | 2024-01-06T00:03:21.337Z |
3251901 | 3251901 | 20231023000133_4uTNN | BE000N | 2024-01-06T00:03:18.972Z | 2024-01-06T00:03:18.972Z |
3251856 | 3251856 | 20231023000031_fu6U7 | BE000N | 2024-01-06T00:03:18.962Z | 2024-01-06T00:03:18.962Z |
3251431 | 3251431 | 20231022234314_ZC5oY | BE000N | 2024-01-06T00:03:18.876Z | 2024-01-06T00:03:18.876Z |
3250960 | 3250960 | 20231022232539_2J2u9 | BE000N | 2024-01-06T00:03:18.790Z | 2024-01-06T00:03:18.790Z |
3250266 | 3250266 | 20231022225804_FUIwA | BE000N | 2024-01-06T00:03:18.658Z | 2024-01-06T00:03:18.658Z |
3249974 | 3249974 | 20231022224357_9EVlz | BE000N | 2024-01-06T00:03:18.606Z | 2024-01-06T00:03:18.606Z |
3249409 | 3249409 | 20231022220423_u2NlR | BE000N | 2024-01-06T00:03:18.490Z | 2024-01-06T00:03:18.490Z |
3249344 | 3249344 | 20231022215822_VTLYi | BE000N | 2024-01-06T00:03:18.476Z | 2024-01-06T00:03:18.476Z |
3249025 | 3249025 | 20231022211933_KGeSx | BE000N | 2024-01-06T00:03:18.400Z | 2024-01-06T00:03:18.400Z |
3248890 | 3248890 | 20231022210506_V11nh | BE000N | 2024-01-06T00:03:18.374Z | 2024-01-06T00:03:18.374Z |
3247222 | 3247222 | 20231022185912_9gc7g | BE000N | 2024-01-06T00:03:18.001Z | 2024-01-06T00:03:18.001Z |
3238931 | 3238931 | 20231022043524_jftiH | BE000N | 2024-01-06T00:03:16.017Z | 2024-01-06T00:03:16.017Z |
3238758 | 3238758 | 20231022042917_OyWKf | BE000N | 2024-01-06T00:03:15.985Z | 2024-01-06T00:03:15.985Z |
3238291 | 3238291 | 20231022040918_DpYR3 | BE000N | 2024-01-06T00:03:15.897Z | 2024-01-06T00:03:15.897Z |
3238238 | 3238238 | 20231022040750_3eeS8 | BE000N | 2024-01-06T00:03:15.888Z | 2024-01-06T00:03:15.888Z |
3238095 | 3238095 | 20231022040027_53UiP | BE000N | 2024-01-06T00:03:15.861Z | 2024-01-06T00:03:15.861Z |
3237747 | 3237747 | 20231022034607_npK3R | BE000N | 2024-01-06T00:03:15.801Z | 2024-01-06T00:03:15.801Z |
3237167 | 3237167 | 20231022032716_Iqc6O | BE000N | 2024-01-06T00:03:15.700Z | 2024-01-06T00:03:15.700Z |
3222484 | 3222484 | 20231021040423_X4ZhW | BE000N | 2024-01-06T00:03:09.322Z | 2024-01-06T00:03:09.322Z |
3222295 | 3222295 | 20231021031101_9XbZC | BE000N | 2024-01-06T00:03:09.247Z | 2024-01-06T00:03:09.247Z |
3222281 | 3222281 | 20231021030644_bTZNP | BE000N | 2024-01-06T00:03:09.241Z | 2024-01-06T00:03:09.241Z |
3221845 | 3221845 | 20231021013913_ykwSn | BE000N | 2024-01-06T00:03:09.005Z | 2024-01-06T00:03:09.005Z |
3221823 | 3221823 | 20231021013446_e1SfW | BE000N | 2024-01-06T00:03:08.999Z | 2024-01-06T00:03:08.999Z |
3221438 | 3221438 | 20231020230107_38b6F | BE000N | 2024-01-06T00:03:06.902Z | 2024-01-06T00:03:06.902Z |
3221418 | 3221418 | 20231020224923_is5Qg | BE000N | 2024-01-06T00:03:06.896Z | 2024-01-06T00:03:06.896Z |
3221412 | 3221412 | 20231020224302_fal1I | BE000N | 2024-01-06T00:03:06.894Z | 2024-01-06T00:03:06.894Z |
3221335 | 3221335 | 20231020211117_9OpCs | BE000N | 2024-01-06T00:03:06.868Z | 2024-01-06T00:03:06.868Z |
3221278 | 3221278 | 20231020204450_ZwRJa | BE000N | 2024-01-06T00:03:06.855Z | 2024-01-06T00:03:06.855Z |
3220952 | 3220952 | 20231020200325_492Ao | BE000N | 2024-01-06T00:03:06.774Z | 2024-01-06T00:03:06.774Z |
3220172 | 3220172 | 20231020185850_9jI3n | BE000N | 2024-01-06T00:03:06.640Z | 2024-01-06T00:03:06.640Z |
3219179 | 3219179 | 20231020174746_EGBM3 | BE000N | 2024-01-06T00:03:06.470Z | 2024-01-06T00:03:06.470Z |
3200723 | 3200723 | 20231018021708_ln1zc | BE000N | 2024-01-06T00:02:57.304Z | 2024-01-06T00:02:57.304Z |
3200585 | 3200585 | 20231018015045_mGz2S | BE000N | 2024-01-06T00:02:57.246Z | 2024-01-06T00:02:57.246Z |
3200551 | 3200551 | 20231018013945_G7mjl | BE000N | 2024-01-06T00:02:57.230Z | 2024-01-06T00:02:57.230Z |
3200543 | 3200543 | 20231018013635_YpJqK | BE000N | 2024-01-06T00:02:57.226Z | 2024-01-06T00:02:57.226Z |
3200462 | 3200462 | 20231018012007_E3Cb4 | BE000N | 2024-01-06T00:02:57.190Z | 2024-01-06T00:02:57.190Z |
3200441 | 3200441 | 20231018011538_fI5vb | BE000N | 2024-01-06T00:02:57.180Z | 2024-01-06T00:02:57.180Z |
3200424 | 3200424 | 20231018011145_a4Ujc | BE000N | 2024-01-06T00:02:57.174Z | 2024-01-06T00:02:57.174Z |
3200402 | 3200402 | 20231018010656_Rqh1g | BE000N | 2024-01-06T00:02:57.167Z | 2024-01-06T00:02:57.167Z |
3200355 | 3200355 | 20231018005233_G8zld | BE000N | 2024-01-06T00:02:57.151Z | 2024-01-06T00:02:57.151Z |
3200082 | 3200082 | 20231017234456_6m0uG | BE000N | 2024-01-06T00:02:57.072Z | 2024-01-06T00:02:57.072Z |
3199856 | 3199856 | 20231017221700_gdf8O | BE000N | 2024-01-06T00:02:55.208Z | 2024-01-06T00:02:55.208Z |
3199744 | 3199744 | 20231017213011_uq2BR | BE000N | 2024-01-06T00:02:55.176Z | 2024-01-06T00:02:55.176Z |
3199277 | 3199277 | 20231017195354_Pn6F2 | BE000N | 2024-01-06T00:02:55.069Z | 2024-01-06T00:02:55.069Z |
3199159 | 3199159 | 20231017193706_diwTc | BE000N | 2024-01-06T00:02:55.043Z | 2024-01-06T00:02:55.043Z |
3199127 | 3199127 | 20231017193356_OfQ90 | BE000N | 2024-01-06T00:02:55.036Z | 2024-01-06T00:02:55.036Z |
3189802 | 3189802 | 20231016221846_3YFvv | BE000N | 2024-01-06T00:02:52.592Z | 2024-01-06T00:02:52.592Z |
3181789 | 3181789 | 20231016031722_44n5U | BE000N | 2024-01-06T00:02:51.688Z | 2024-01-06T00:02:51.688Z |
3181728 | 3181728 | 20231016031055_qFUKY | BE000N | 2024-01-06T00:02:51.680Z | 2024-01-06T00:02:51.680Z |
3181519 | 3181519 | 20231016025435_sJQz5 | BE000N | 2024-01-06T00:02:51.658Z | 2024-01-06T00:02:51.658Z |
3181363 | 3181363 | 20231016024539_bQJdi | BE000N | 2024-01-06T00:02:51.642Z | 2024-01-06T00:02:51.642Z |
3181053 | 3181053 | 20231016022232_kVTjD | BE000N | 2024-01-06T00:02:51.611Z | 2024-01-06T00:02:51.611Z |
3180867 | 3180867 | 20231016021114_2QRaF | BE000N | 2024-01-06T00:02:51.593Z | 2024-01-06T00:02:51.593Z |
3180614 | 3180614 | 20231016015409_xQKUY | BE000N | 2024-01-06T00:02:51.567Z | 2024-01-06T00:02:51.567Z |
3179710 | 3179710 | 20231016003228_fI2YX | BE000N | 2024-01-06T00:02:51.478Z | 2024-01-06T00:02:51.478Z |
3179563 | 3179563 | 20231016002457_8f2UD | BE000N | 2024-01-06T00:02:51.466Z | 2024-01-06T00:02:51.466Z |
3179504 | 3179504 | 20231016002031_TdKob | BE000N | 2024-01-06T00:02:51.460Z | 2024-01-06T00:02:51.460Z |
3179441 | 3179441 | 20231016001551_2OP9b | BE000N | 2024-01-06T00:02:51.453Z | 2024-01-06T00:02:51.453Z |
3179342 | 3179342 | 20231016000506_Sjj5d | BE000N | 2024-01-06T00:02:51.443Z | 2024-01-06T00:02:51.443Z |
3179291 | 3179291 | 20231015235747_KoZHo | BE000N | 2024-01-06T00:02:51.438Z | 2024-01-06T00:02:51.438Z |
3179101 | 3179101 | 20231015234109_geuzC | BE000N | 2024-01-06T00:02:51.420Z | 2024-01-06T00:02:51.420Z |
3178953 | 3178953 | 20231015232522_7uXUs | BE000N | 2024-01-06T00:02:51.404Z | 2024-01-06T00:02:51.404Z |
3178877 | 3178877 | 20231015231817_6cT3S | BE000N | 2024-01-06T00:02:51.397Z | 2024-01-06T00:02:51.397Z |
3178750 | 3178750 | 20231015230701_5LLFz | BE000N | 2024-01-06T00:02:51.384Z | 2024-01-06T00:02:51.384Z |
3178672 | 3178672 | 20231015225345_mGWDe | BE000N | 2024-01-06T00:02:49.977Z | 2024-01-06T00:02:49.977Z |
3178620 | 3178620 | 20231015224111_2Dd1o | BE000N | 2024-01-06T00:02:49.970Z | 2024-01-06T00:02:49.970Z |
3178586 | 3178586 | 20231015223525_SY2TB | BE000N | 2024-01-06T00:02:49.966Z | 2024-01-06T00:02:49.966Z |
3178526 | 3178526 | 20231015222524_qoCIN | BE000N | 2024-01-06T00:02:49.959Z | 2024-01-06T00:02:49.959Z |
3178511 | 3178511 | 20231015222345_FUXQQ | BE000N | 2024-01-06T00:02:49.957Z | 2024-01-06T00:02:49.957Z |
3178240 | 3178240 | 20231015213216_ejXaO | BE000N | 2024-01-06T00:02:49.925Z | 2024-01-06T00:02:49.925Z |
3178128 | 3178128 | 20231015211116_uay6s | BE000N | 2024-01-06T00:02:49.912Z | 2024-01-06T00:02:49.912Z |
3178134 | 3178134 | 20231015211149_xp59x | BE000N | 2024-01-06T00:02:49.912Z | 2024-01-06T00:02:49.912Z |
3177951 | 3177951 | 20231015204423_H9F5p | BE000N | 2024-01-06T00:02:49.892Z | 2024-01-06T00:02:49.892Z |
3177620 | 3177620 | 20231015200942_n0sK3 | BE000N | 2024-01-06T00:02:49.855Z | 2024-01-06T00:02:49.855Z |
3176826 | 3176826 | 20231015184023_3KDmn | BE000N | 2024-01-06T00:02:49.764Z | 2024-01-06T00:02:49.764Z |
3176656 | 3176656 | 20231015182539_XiMCX | BE000N | 2024-01-06T00:02:49.748Z | 2024-01-06T00:02:49.748Z |
3171499 | 3171499 | 20231015050244_Aln9b | BE000N | 2024-01-06T00:02:48.927Z | 2024-01-06T00:02:48.927Z |
3171504 | 3171504 | 20231015050447_YunJP | BE000N | 2024-01-06T00:02:48.927Z | 2024-01-06T00:02:48.927Z |
3170114 | 3170114 | 20231015042141_PDuTz | BE000N | 2024-01-06T00:02:48.721Z | 2024-01-06T00:02:48.721Z |
3169468 | 3169468 | 20231015035942_mPV9J | BE000N | 2024-01-06T00:02:48.680Z | 2024-01-06T00:02:48.680Z |
3169362 | 3169362 | 20231015035802_270rZ | BE000N | 2024-01-06T00:02:48.675Z | 2024-01-06T00:02:48.675Z |
3168750 | 3168750 | 20231015033745_SM20y | BE000N | 2024-01-06T00:02:48.633Z | 2024-01-06T00:02:48.633Z |
3168209 | 3168209 | 20231015032126_xS4Ji | BE000N | 2024-01-06T00:02:48.600Z | 2024-01-06T00:02:48.600Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);