participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,684 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 |
---|---|---|---|---|---|
5482936 | 5482936 | 20241104233626_DIdWH | BE000P | 2024-11-06T14:14:22.839Z | 2024-11-09T14:21:02.492Z |
5478717 | 5478717 | 20241104051722_Sz3qG | BE000P | 2024-11-05T14:18:44.069Z | 2024-11-09T14:22:30.920Z |
5478653 | 5478653 | 20241104045206_gV7bK | BE000P | 2024-11-05T14:18:38.148Z | 2024-11-09T14:22:30.509Z |
5478646 | 5478646 | 20241104044952_0Lo4g | BE000P | 2024-11-05T14:18:37.182Z | 2024-11-09T14:22:30.478Z |
5478549 | 5478549 | 20241104042916_2jJB0 | BE000P | 2024-11-05T14:18:29.657Z | 2024-11-09T14:22:29.030Z |
5478512 | 5478512 | 20241104042215_2USWK | BE000P | 2024-11-05T14:18:27.018Z | 2024-11-09T14:22:28.804Z |
5478499 | 5478499 | 20241104041828_mudya | BE000P | 2024-11-05T14:18:26.056Z | 2024-11-09T14:22:28.576Z |
5478463 | 5478463 | 20241104041410_s9BFI | BE000P | 2024-11-05T14:18:24.064Z | 2024-11-09T14:22:28.300Z |
5478366 | 5478366 | 20241104035555_hbXjB | BE000P | 2024-11-05T14:18:15.918Z | 2024-11-09T14:22:27.385Z |
5478308 | 5478308 | 20241104035053_541wK | BE000P | 2024-11-05T14:18:12.629Z | 2024-11-09T14:22:26.971Z |
5478278 | 5478278 | 20241104034544_Qn3p0 | BE000P | 2024-11-05T14:18:08.810Z | 2024-11-09T14:22:26.545Z |
5478159 | 5478159 | 20241104033105_WEQKr | BE000P | 2024-11-05T14:18:00.781Z | 2024-11-09T14:22:25.532Z |
5478099 | 5478099 | 20241104032133_FD029 | BE000P | 2024-11-05T14:17:55.853Z | 2024-11-09T14:22:25.151Z |
5477948 | 5477948 | 20241104025951_8Ce1p | BE000P | 2024-11-05T14:17:39.895Z | 2024-11-09T14:22:23.084Z |
5477868 | 5477868 | 20241104024753_wGvHf | BE000P | 2024-11-05T14:17:32.432Z | 2024-11-09T14:22:22.460Z |
5477760 | 5477760 | 20241104023255_eCrUo | BE000P | 2024-11-05T14:17:23.090Z | 2024-11-09T14:22:21.614Z |
5477581 | 5477581 | 20241104021048_phYxX | BE000P | 2024-11-05T14:17:05.360Z | 2024-11-09T14:22:19.787Z |
5477448 | 5477448 | 20241104015451_zSTch | BE000P | 2024-11-05T14:16:54.241Z | 2024-11-09T14:22:17.802Z |
5477396 | 5477396 | 20241104014802_eprV3 | BE000P | 2024-11-05T14:16:49.769Z | 2024-11-09T14:22:17.251Z |
5477379 | 5477379 | 20241104014508_ps4oW | BE000P | 2024-11-05T14:16:48.406Z | 2024-11-09T14:22:17.102Z |
5477368 | 5477368 | 20241104014357_cbcgc | BE000P | 2024-11-05T14:16:47.293Z | 2024-11-09T14:22:17.006Z |
5477329 | 5477329 | 20241104013824_qDNV0 | BE000P | 2024-11-05T14:16:43.991Z | 2024-11-09T14:22:16.655Z |
5477306 | 5477306 | 20241104013438_UMB1S | BE000P | 2024-11-05T14:16:42.057Z | 2024-11-09T14:22:16.456Z |
5477293 | 5477293 | 20241104013357_qCn6B | BE000P | 2024-11-05T14:16:40.689Z | 2024-11-09T14:22:16.346Z |
5477262 | 5477262 | 20241104012930_rMEPC | BE000P | 2024-11-05T14:16:38.311Z | 2024-11-09T14:22:16.251Z |
5477256 | 5477256 | 20241104012755_RsEIh | BE000P | 2024-11-05T14:16:38.008Z | 2024-11-09T14:22:16.189Z |
5477231 | 5477231 | 20241104012226_x8i27 | BE000P | 2024-11-05T14:16:33.751Z | 2024-11-09T14:22:15.987Z |
5477212 | 5477212 | 20241104012037_Ee0NG | BE000P | 2024-11-05T14:16:31.682Z | 2024-11-09T14:22:15.739Z |
5477187 | 5477187 | 20241104011529_yRV2O | BE000P | 2024-11-05T14:16:30.033Z | 2024-11-09T14:22:15.317Z |
5477151 | 5477151 | 20241104010856_KYJwe | BE000P | 2024-11-05T14:16:27.629Z | 2024-11-09T14:22:14.882Z |
5477122 | 5477122 | 20241104010349_lvyES | BE000P | 2024-11-05T14:16:24.630Z | 2024-11-09T14:22:14.459Z |
5477117 | 5477117 | 20241104010327_EGZNH | BE000P | 2024-11-05T14:16:24.338Z | 2024-11-09T14:22:14.441Z |
5477111 | 5477111 | 20241104010237_u83cT | BE000P | 2024-11-05T14:16:23.544Z | 2024-11-09T14:22:14.382Z |
5476926 | 5476926 | 20241104004305_qKYVg | BE000P | 2024-11-05T14:16:12.709Z | 2024-11-09T14:22:13.392Z |
5476856 | 5476856 | 20241104003556_0Nn38 | BE000P | 2024-11-05T14:16:08.162Z | 2024-11-09T14:22:12.781Z |
5476837 | 5476837 | 20241104003122_ydWoS | BE000P | 2024-11-05T14:16:07.119Z | 2024-11-09T14:22:12.674Z |
5476824 | 5476824 | 20241104002951_iqLZM | BE000P | 2024-11-05T14:16:06.494Z | 2024-11-09T14:22:12.591Z |
5476798 | 5476798 | 20241104002357_KUKEZ | BE000P | 2024-11-05T14:16:05.319Z | 2024-11-09T14:22:12.459Z |
5476783 | 5476783 | 20241104002113_Vhe2J | BE000P | 2024-11-05T14:16:04.510Z | 2024-11-09T14:22:12.358Z |
5476696 | 5476696 | 20241104000831_2FFaF | BE000P | 2024-11-05T14:15:54.817Z | 2024-11-09T14:22:11.805Z |
5476692 | 5476692 | 20241104000830_Fm0Ix | BE000P | 2024-11-05T14:15:54.082Z | 2024-11-09T14:22:11.789Z |
5476680 | 5476680 | 20241104000731_2APED | BE000P | 2024-11-05T14:15:51.831Z | 2024-11-09T14:22:11.635Z |
5476624 | 5476624 | 20241103235640_yt3ce | BE000P | 2024-11-05T14:15:46.058Z | 2024-11-09T14:22:11.257Z |
5476609 | 5476609 | 20241103235234_bAYFY | BE000P | 2024-11-05T14:15:43.702Z | 2024-11-09T14:22:11.132Z |
5476547 | 5476547 | 20241103234321_dlP1L | BE000P | 2024-11-05T14:15:36.602Z | 2024-11-09T14:22:10.592Z |
5476461 | 5476461 | 20241103232932_qA2FE | BE000P | 2024-11-05T14:15:26.349Z | 2024-11-09T14:22:09.799Z |
5476436 | 5476436 | 20241103232650_zWii0 | BE000P | 2024-11-05T14:15:22.592Z | 2024-11-09T14:22:09.545Z |
5476430 | 5476430 | 20241103232523_ASVVs | BE000P | 2024-11-05T14:15:21.007Z | 2024-11-09T14:22:09.428Z |
5476413 | 5476413 | 20241103232142_oVB3l | BE000P | 2024-11-05T14:15:18.622Z | 2024-11-09T14:22:09.259Z |
5476325 | 5476325 | 20241103230903_8C3lP | BE000P | 2024-11-05T14:15:04.175Z | 2024-11-09T14:22:08.236Z |
5476241 | 5476241 | 20241103225101_GIfRO | BE000P | 2024-11-05T14:14:57.887Z | 2024-11-09T14:22:07.308Z |
5476031 | 5476031 | 20241103221044_1iA79 | BE000P | 2024-11-05T14:14:40.740Z | 2024-11-09T14:22:04.869Z |
5475964 | 5475964 | 20241103220155_xzuj0 | BE000P | 2024-11-05T14:14:36.142Z | 2024-11-09T14:22:04.244Z |
5475808 | 5475808 | 20241103212925_8SQu4 | BE000P | 2024-11-05T14:14:14.939Z | 2024-11-09T14:22:02.517Z |
5475761 | 5475761 | 20241103211837_3VEZC | BE000P | 2024-11-05T14:14:09.979Z | 2024-11-09T14:22:02.073Z |
5475610 | 5475610 | 20241103204950_28J33 | BE000P | 2024-11-05T14:13:53.155Z | 2024-11-09T14:22:00.521Z |
5475593 | 5475593 | 20241103204701_N7u9C | BE000P | 2024-11-05T14:13:51.857Z | 2024-11-09T14:22:00.388Z |
5475579 | 5475579 | 20241103204206_1EMJB | BE000P | 2024-11-05T14:13:50.935Z | 2024-11-09T14:22:00.268Z |
5475520 | 5475520 | 20241103202327_VFCqR | BE000P | 2024-11-05T14:13:45.730Z | 2024-11-09T14:21:59.652Z |
5475446 | 5475446 | 20241103200746_b18uR | BE000P | 2024-11-05T14:13:34.713Z | 2024-11-09T14:21:58.775Z |
5475349 | 5475349 | 20241103195215_K7e0w | BE000P | 2024-11-05T14:13:17.139Z | 2024-11-09T14:21:57.586Z |
5475289 | 5475289 | 20241103194126_HOMn1 | BE000P | 2024-11-05T14:13:04.437Z | 2024-11-09T14:21:57.079Z |
5475278 | 5475278 | 20241103194001_bbhmv | BE000P | 2024-11-05T14:13:00.088Z | 2024-11-09T14:21:56.946Z |
5475175 | 5475175 | 20241103192321_i0uKG | BE000P | 2024-11-05T14:12:39.143Z | 2024-11-09T14:21:56.383Z |
5475171 | 5475171 | 20241103192245_Xz2UN | BE000P | 2024-11-05T14:12:38.702Z | 2024-11-09T14:21:56.358Z |
5475083 | 5475083 | 20241103190353_zoyCn | BE000P | 2024-11-05T14:12:30.315Z | 2024-11-09T14:21:55.711Z |
5474761 | 5474761 | 20241103181209_daj2x | BE000P | 2024-11-05T14:11:55.206Z | 2024-11-09T14:21:52.232Z |
5474654 | 5474654 | 20241103175459_bK35E | BE000P | 2024-11-05T14:11:30.192Z | 2024-11-09T14:21:50.060Z |
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 |
5439312 | 5439312 | 20241030194156_bJG9s | BE000P | 2024-11-01T12:13:40.854Z | 2024-11-08T14:23:03.005Z |
5439280 | 5439280 | 20241030193610_gC2GT | BE000P | 2024-11-01T12:13:28.133Z | 2024-11-08T14:23:02.804Z |
5433462 | 5433462 | 20241029200126_rH6FD | BE000P | 2024-10-31T12:22:16.736Z | 2024-11-07T14:26:39.692Z |
5433435 | 5433435 | 20241029195816_MVb38 | BE000P | 2024-10-31T12:22:15.534Z | 2024-11-07T14:26:39.543Z |
5430884 | 5430884 | 20241028235900_vuTRQ | BE000P | 2024-10-31T12:19:15.487Z | 2024-11-06T14:27:22.085Z |
5430866 | 5430866 | 20241028235410_efkh2 | BE000P | 2024-10-31T12:19:12.142Z | 2024-11-06T14:27:21.940Z |
5430845 | 5430845 | 20241028235203_O17S2 | BE000P | 2024-10-31T12:19:09.900Z | 2024-11-06T14:27:21.744Z |
5430780 | 5430780 | 20241028233722_cgETk | BE000P | 2024-10-31T12:19:01.393Z | 2024-11-06T14:27:21.517Z |
5420310 | 5420310 | 20241028022803_rhaNt | BE000P | 2024-10-30T12:18:42.573Z | 2024-11-05T14:27:15.154Z |
5418756 | 5418756 | 20241027215252_Hayln | BE000P | 2024-10-30T12:16:07.442Z | 2024-11-05T14:27:11.062Z |
5418744 | 5418744 | 20241027215050_ATJlv | BE000P | 2024-10-30T12:16:04.395Z | 2024-11-05T14:27:11.035Z |
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);