participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,695 rows where station_code = "BE000P" 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 |
---|---|---|---|---|---|
5569925 | 5569925 | 20241120180029_yIJPV | BE000P | 2024-11-22T14:14:36.929Z | 2024-11-22T14:19:21.830Z |
5565421 | 5565421 | 20241120042433_C2xaF | BE000P | 2024-11-21T14:18:48.609Z | 2024-11-22T14:21:46.617Z |
5562633 | 5562633 | 20241119235932_FwDVt | BE000P | 2024-11-21T14:15:14.486Z | 2024-11-22T14:21:01.389Z |
5558015 | 5558015 | 20241120053151_eV8UR | BE000P | 2024-11-21T14:02:19.049Z | 2024-11-22T14:19:21.164Z |
5557902 | 5557902 | 20241120052228_eMqzn | BE000P | 2024-11-21T14:02:02.017Z | 2024-11-22T14:19:21.143Z |
5557479 | 5557479 | 20241120045006_Tcm1I | BE000P | 2024-11-21T14:00:59.021Z | 2024-11-22T14:19:21.077Z |
5557462 | 5557462 | 20241120044725_fmyXu | BE000P | 2024-11-21T14:00:56.753Z | 2024-11-22T14:19:21.075Z |
5557410 | 5557410 | 20241120044403_LB6MW | BE000P | 2024-11-21T14:00:44.283Z | 2024-11-22T14:19:21.065Z |
5557403 | 5557403 | 20241120044403_gbtcp | BE000P | 2024-11-21T14:00:43.780Z | 2024-11-22T14:19:21.064Z |
5557394 | 5557394 | 20241120044325_r7807 | BE000P | 2024-11-21T14:00:42.167Z | 2024-11-22T14:19:21.062Z |
5524292 | 5524292 | 20241111034813_eP0t2 | BE000P | 2024-11-12T14:16:56.205Z | 2024-11-19T14:22:19.783Z |
5482936 | 5482936 | 20241104233626_DIdWH | BE000P | 2024-11-06T14:14:22.839Z | 2024-11-13T14:27:35.404Z |
5478717 | 5478717 | 20241104051722_Sz3qG | BE000P | 2024-11-05T14:18:44.069Z | 2024-11-12T14:28:16.758Z |
5478653 | 5478653 | 20241104045206_gV7bK | BE000P | 2024-11-05T14:18:38.148Z | 2024-11-12T14:28:16.468Z |
5478646 | 5478646 | 20241104044952_0Lo4g | BE000P | 2024-11-05T14:18:37.182Z | 2024-11-12T14:28:16.458Z |
5478549 | 5478549 | 20241104042916_2jJB0 | BE000P | 2024-11-05T14:18:29.657Z | 2024-11-12T14:28:15.848Z |
5478512 | 5478512 | 20241104042215_2USWK | BE000P | 2024-11-05T14:18:27.018Z | 2024-11-12T14:28:15.751Z |
5478499 | 5478499 | 20241104041828_mudya | BE000P | 2024-11-05T14:18:26.056Z | 2024-11-12T14:28:15.730Z |
5478463 | 5478463 | 20241104041410_s9BFI | BE000P | 2024-11-05T14:18:24.064Z | 2024-11-12T14:28:15.487Z |
5478366 | 5478366 | 20241104035555_hbXjB | BE000P | 2024-11-05T14:18:15.918Z | 2024-11-12T14:28:15.023Z |
5478308 | 5478308 | 20241104035053_541wK | BE000P | 2024-11-05T14:18:12.629Z | 2024-11-12T14:28:14.915Z |
5478278 | 5478278 | 20241104034544_Qn3p0 | BE000P | 2024-11-05T14:18:08.810Z | 2024-11-12T14:28:14.784Z |
5478159 | 5478159 | 20241104033105_WEQKr | BE000P | 2024-11-05T14:18:00.781Z | 2024-11-12T14:28:14.472Z |
5478099 | 5478099 | 20241104032133_FD029 | BE000P | 2024-11-05T14:17:55.853Z | 2024-11-12T14:28:14.208Z |
5477948 | 5477948 | 20241104025951_8Ce1p | BE000P | 2024-11-05T14:17:39.895Z | 2024-11-12T14:28:13.615Z |
5477868 | 5477868 | 20241104024753_wGvHf | BE000P | 2024-11-05T14:17:32.432Z | 2024-11-12T14:28:13.104Z |
5477760 | 5477760 | 20241104023255_eCrUo | BE000P | 2024-11-05T14:17:23.090Z | 2024-11-12T14:28:12.812Z |
5477581 | 5477581 | 20241104021048_phYxX | BE000P | 2024-11-05T14:17:05.360Z | 2024-11-12T14:28:12.092Z |
5477448 | 5477448 | 20241104015451_zSTch | BE000P | 2024-11-05T14:16:54.241Z | 2024-11-12T14:28:11.781Z |
5477396 | 5477396 | 20241104014802_eprV3 | BE000P | 2024-11-05T14:16:49.769Z | 2024-11-12T14:28:11.228Z |
5477379 | 5477379 | 20241104014508_ps4oW | BE000P | 2024-11-05T14:16:48.406Z | 2024-11-12T14:28:11.158Z |
5477368 | 5477368 | 20241104014357_cbcgc | BE000P | 2024-11-05T14:16:47.293Z | 2024-11-12T14:28:11.007Z |
5477329 | 5477329 | 20241104013824_qDNV0 | BE000P | 2024-11-05T14:16:43.991Z | 2024-11-12T14:28:10.699Z |
5477306 | 5477306 | 20241104013438_UMB1S | BE000P | 2024-11-05T14:16:42.057Z | 2024-11-12T14:28:10.549Z |
5477293 | 5477293 | 20241104013357_qCn6B | BE000P | 2024-11-05T14:16:40.689Z | 2024-11-12T14:28:10.525Z |
5477262 | 5477262 | 20241104012930_rMEPC | BE000P | 2024-11-05T14:16:38.311Z | 2024-11-12T14:28:10.465Z |
5477256 | 5477256 | 20241104012755_RsEIh | BE000P | 2024-11-05T14:16:38.008Z | 2024-11-12T14:28:10.462Z |
5477231 | 5477231 | 20241104012226_x8i27 | BE000P | 2024-11-05T14:16:33.751Z | 2024-11-12T14:28:10.421Z |
5477212 | 5477212 | 20241104012037_Ee0NG | BE000P | 2024-11-05T14:16:31.682Z | 2024-11-12T14:28:10.132Z |
5477187 | 5477187 | 20241104011529_yRV2O | BE000P | 2024-11-05T14:16:30.033Z | 2024-11-12T14:28:09.961Z |
5477151 | 5477151 | 20241104010856_KYJwe | BE000P | 2024-11-05T14:16:27.629Z | 2024-11-12T14:28:09.874Z |
5477122 | 5477122 | 20241104010349_lvyES | BE000P | 2024-11-05T14:16:24.630Z | 2024-11-12T14:28:09.748Z |
5477117 | 5477117 | 20241104010327_EGZNH | BE000P | 2024-11-05T14:16:24.338Z | 2024-11-12T14:28:09.746Z |
5477111 | 5477111 | 20241104010237_u83cT | BE000P | 2024-11-05T14:16:23.544Z | 2024-11-12T14:28:09.713Z |
5476926 | 5476926 | 20241104004305_qKYVg | BE000P | 2024-11-05T14:16:12.709Z | 2024-11-12T14:28:07.904Z |
5476856 | 5476856 | 20241104003556_0Nn38 | BE000P | 2024-11-05T14:16:08.162Z | 2024-11-12T14:28:07.734Z |
5476837 | 5476837 | 20241104003122_ydWoS | BE000P | 2024-11-05T14:16:07.119Z | 2024-11-12T14:28:07.711Z |
5476824 | 5476824 | 20241104002951_iqLZM | BE000P | 2024-11-05T14:16:06.494Z | 2024-11-12T14:28:07.587Z |
5476798 | 5476798 | 20241104002357_KUKEZ | BE000P | 2024-11-05T14:16:05.319Z | 2024-11-12T14:28:07.441Z |
5476783 | 5476783 | 20241104002113_Vhe2J | BE000P | 2024-11-05T14:16:04.510Z | 2024-11-12T14:28:07.424Z |
5476696 | 5476696 | 20241104000831_2FFaF | BE000P | 2024-11-05T14:15:54.817Z | 2024-11-12T14:28:06.925Z |
5476692 | 5476692 | 20241104000830_Fm0Ix | BE000P | 2024-11-05T14:15:54.082Z | 2024-11-12T14:28:06.914Z |
5476680 | 5476680 | 20241104000731_2APED | BE000P | 2024-11-05T14:15:51.831Z | 2024-11-12T14:28:06.856Z |
5476624 | 5476624 | 20241103235640_yt3ce | BE000P | 2024-11-05T14:15:46.058Z | 2024-11-12T14:28:06.636Z |
5476609 | 5476609 | 20241103235234_bAYFY | BE000P | 2024-11-05T14:15:43.702Z | 2024-11-12T14:28:06.576Z |
5476547 | 5476547 | 20241103234321_dlP1L | BE000P | 2024-11-05T14:15:36.602Z | 2024-11-12T14:28:06.481Z |
5476461 | 5476461 | 20241103232932_qA2FE | BE000P | 2024-11-05T14:15:26.349Z | 2024-11-12T14:28:06.139Z |
5476436 | 5476436 | 20241103232650_zWii0 | BE000P | 2024-11-05T14:15:22.592Z | 2024-11-12T14:28:06.024Z |
5476430 | 5476430 | 20241103232523_ASVVs | BE000P | 2024-11-05T14:15:21.007Z | 2024-11-12T14:28:06.020Z |
5476413 | 5476413 | 20241103232142_oVB3l | BE000P | 2024-11-05T14:15:18.622Z | 2024-11-12T14:28:05.962Z |
5476325 | 5476325 | 20241103230903_8C3lP | BE000P | 2024-11-05T14:15:04.175Z | 2024-11-12T14:28:05.506Z |
5476241 | 5476241 | 20241103225101_GIfRO | BE000P | 2024-11-05T14:14:57.887Z | 2024-11-12T14:28:04.163Z |
5476031 | 5476031 | 20241103221044_1iA79 | BE000P | 2024-11-05T14:14:40.740Z | 2024-11-12T14:28:02.483Z |
5475964 | 5475964 | 20241103220155_xzuj0 | BE000P | 2024-11-05T14:14:36.142Z | 2024-11-12T14:28:01.921Z |
5475808 | 5475808 | 20241103212925_8SQu4 | BE000P | 2024-11-05T14:14:14.939Z | 2024-11-12T14:28:01.117Z |
5475761 | 5475761 | 20241103211837_3VEZC | BE000P | 2024-11-05T14:14:09.979Z | 2024-11-12T14:28:00.867Z |
5475610 | 5475610 | 20241103204950_28J33 | BE000P | 2024-11-05T14:13:53.155Z | 2024-11-12T14:28:00.065Z |
5475593 | 5475593 | 20241103204701_N7u9C | BE000P | 2024-11-05T14:13:51.857Z | 2024-11-12T14:28:00.048Z |
5475579 | 5475579 | 20241103204206_1EMJB | BE000P | 2024-11-05T14:13:50.935Z | 2024-11-12T14:27:59.975Z |
5475520 | 5475520 | 20241103202327_VFCqR | BE000P | 2024-11-05T14:13:45.730Z | 2024-11-12T14:27:59.581Z |
5475446 | 5475446 | 20241103200746_b18uR | BE000P | 2024-11-05T14:13:34.713Z | 2024-11-12T14:27:58.601Z |
5475349 | 5475349 | 20241103195215_K7e0w | BE000P | 2024-11-05T14:13:17.139Z | 2024-11-12T14:27:57.999Z |
5475289 | 5475289 | 20241103194126_HOMn1 | BE000P | 2024-11-05T14:13:04.437Z | 2024-11-12T14:27:57.903Z |
5475278 | 5475278 | 20241103194001_bbhmv | BE000P | 2024-11-05T14:13:00.088Z | 2024-11-12T14:27:57.886Z |
5475175 | 5475175 | 20241103192321_i0uKG | BE000P | 2024-11-05T14:12:39.143Z | 2024-11-12T14:27:57.443Z |
5475171 | 5475171 | 20241103192245_Xz2UN | BE000P | 2024-11-05T14:12:38.702Z | 2024-11-12T14:27:57.406Z |
5475083 | 5475083 | 20241103190353_zoyCn | BE000P | 2024-11-05T14:12:30.315Z | 2024-11-12T14:27:57.019Z |
5474761 | 5474761 | 20241103181209_daj2x | BE000P | 2024-11-05T14:11:55.206Z | 2024-11-12T14:27:54.568Z |
5474654 | 5474654 | 20241103175459_bK35E | BE000P | 2024-11-05T14:11:30.192Z | 2024-11-12T14:27:53.754Z |
5454718 | 5454718 | 20241031050033_GXEK5 | BE000P | 2024-11-02T12:23:18.643Z | 2024-11-08T14:23:24.861Z |
5454706 | 5454706 | 20241031045749_xNM6O | BE000P | 2024-11-02T12:23:17.653Z | 2024-11-08T14:23:24.824Z |
5454702 | 5454702 | 20241031045659_Bo1Sf | BE000P | 2024-11-02T12:23:17.213Z | 2024-11-08T14:23:24.795Z |
5454529 | 5454529 | 20241031043526_feNhP | BE000P | 2024-11-02T12:23:10.419Z | 2024-11-08T14:23:23.520Z |
5454514 | 5454514 | 20241031043303_Zvvn7 | BE000P | 2024-11-02T12:23:09.384Z | 2024-11-08T14:23:23.445Z |
5454316 | 5454316 | 20241031040757_a9mjz | BE000P | 2024-11-02T12:23:00.534Z | 2024-11-08T14:23:22.165Z |
5454159 | 5454159 | 20241031034903_4G8LO | BE000P | 2024-11-02T12:22:52.747Z | 2024-11-08T14:23:20.802Z |
5454124 | 5454124 | 20241031034459_MFJYW | BE000P | 2024-11-02T12:22:51.551Z | 2024-11-08T14:23:20.642Z |
5454098 | 5454098 | 20241031034128_9oMbh | BE000P | 2024-11-02T12:22:50.723Z | 2024-11-08T14:23:20.446Z |
5454052 | 5454052 | 20241031033636_DOiIL | BE000P | 2024-11-02T12:22:49.716Z | 2024-11-08T14:23:20.127Z |
5454016 | 5454016 | 20241031033107_RZJ2J | BE000P | 2024-11-02T12:22:48.486Z | 2024-11-08T14:23:19.988Z |
5442815 | 5442815 | 20241030023751_X2zQb | BE000P | 2024-11-01T12:20:09.512Z | 2024-11-07T14:26:48.475Z |
5442813 | 5442813 | 20241030023739_Ph9PZ | BE000P | 2024-11-01T12:20:09.442Z | 2024-11-07T14:26:48.398Z |
5440492 | 5440492 | 20241030222003_vVS61 | BE000P | 2024-11-01T12:15:33.259Z | 2024-11-08T14:23:09.598Z |
5440485 | 5440485 | 20241030221836_BrZX1 | BE000P | 2024-11-01T12:15:33.012Z | 2024-11-08T14:23:09.590Z |
5440293 | 5440293 | 20241030215305_2L02y | BE000P | 2024-11-01T12:15:15.977Z | 2024-11-08T14:23:08.658Z |
5440219 | 5440219 | 20241030214355_OWoYF | BE000P | 2024-11-01T12:15:01.172Z | 2024-11-08T14:23:07.845Z |
5440127 | 5440127 | 20241030212535_8d1N7 | BE000P | 2024-11-01T12:14:53.365Z | 2024-11-08T14:23:07.558Z |
5439951 | 5439951 | 20241030205506_DEP3S | BE000P | 2024-11-01T12:14:40.047Z | 2024-11-08T14:23:06.480Z |
5439615 | 5439615 | 20241030201244_DlmAt | BE000P | 2024-11-01T12:14:03.942Z | 2024-11-08T14:23:04.296Z |
5439340 | 5439340 | 20241030194615_ARn2p | BE000P | 2024-11-01T12:13:43.910Z | 2024-11-08T14:23:03.134Z |
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);