participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "BE000C" 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 |
---|---|---|---|---|---|
5489548 | 5489548 | 20241105191500_JpUDT | BE000C | 2024-11-07T14:12:11.366Z | 2024-11-09T14:19:43.822Z |
5489283 | 5489283 | 20241105182644_2nHPj | BE000C | 2024-11-07T14:11:50.021Z | 2024-11-09T14:19:40.785Z |
5489274 | 5489274 | 20241105182002_WaKFT | BE000C | 2024-11-07T14:11:48.069Z | 2024-11-09T14:19:40.629Z |
5489212 | 5489212 | 20241105180822_CQFcz | BE000C | 2024-11-07T14:11:29.091Z | 2024-11-09T14:19:39.099Z |
5489063 | 5489063 | 20241105174259_wQoaX | BE000C | 2024-11-07T14:11:14.873Z | 2024-11-09T14:19:36.242Z |
5489028 | 5489028 | 20241105173805_uckJt | BE000C | 2024-11-07T14:11:12.473Z | 2024-11-09T14:19:35.917Z |
5489026 | 5489026 | 20241105173746_3xorw | BE000C | 2024-11-07T14:11:12.310Z | 2024-11-09T14:19:35.865Z |
5489000 | 5489000 | 20241105173156_iMgT2 | BE000C | 2024-11-07T14:11:09.599Z | 2024-11-09T14:19:35.289Z |
5483514 | 5483514 | 20241105004957_gXB4j | BE000C | 2024-11-06T14:15:26.028Z | 2024-11-09T14:21:05.745Z |
5483492 | 5483492 | 20241105004513_WWZab | BE000C | 2024-11-06T14:15:25.285Z | 2024-11-09T14:21:05.648Z |
5483482 | 5483482 | 20241105004451_08TzB | BE000C | 2024-11-06T14:15:24.644Z | 2024-11-09T14:21:05.636Z |
5483250 | 5483250 | 20241105001903_f7CsY | BE000C | 2024-11-06T14:14:49.639Z | 2024-11-09T14:21:04.329Z |
5483211 | 5483211 | 20241105001325_z5tiU | BE000C | 2024-11-06T14:14:47.817Z | 2024-11-09T14:21:04.104Z |
5483128 | 5483128 | 20241105000105_Awj1h | BE000C | 2024-11-06T14:14:41.218Z | 2024-11-09T14:21:03.614Z |
5483079 | 5483079 | 20241104235524_uUlq0 | BE000C | 2024-11-06T14:14:38.762Z | 2024-11-09T14:21:03.280Z |
5482839 | 5482839 | 20241104232114_8zJrd | BE000C | 2024-11-06T14:14:09.525Z | 2024-11-09T14:21:01.892Z |
5482832 | 5482832 | 20241104232021_FTLwo | BE000C | 2024-11-06T14:14:08.588Z | 2024-11-09T14:21:01.842Z |
5482809 | 5482809 | 20241104231619_Hdno2 | BE000C | 2024-11-06T14:14:04.503Z | 2024-11-09T14:21:01.706Z |
5482744 | 5482744 | 20241104230951_CRzrh | BE000C | 2024-11-06T14:13:49.412Z | 2024-11-09T14:21:01.357Z |
5482725 | 5482725 | 20241104230823_ra6Z2 | BE000C | 2024-11-06T14:13:43.550Z | 2024-11-09T14:21:01.232Z |
5482678 | 5482678 | 20241104230021_WyZSe | BE000C | 2024-11-06T14:13:35.665Z | 2024-11-09T14:21:00.989Z |
5482641 | 5482641 | 20241104225308_Aqox0 | BE000C | 2024-11-06T14:13:29.526Z | 2024-11-09T14:21:00.727Z |
5482589 | 5482589 | 20241104224625_t72Az | BE000C | 2024-11-06T14:13:25.006Z | 2024-11-09T14:21:00.430Z |
5482407 | 5482407 | 20241104220807_KSP8v | BE000C | 2024-11-06T14:13:08.289Z | 2024-11-09T14:20:58.991Z |
5482341 | 5482341 | 20241104215230_c3ve2 | BE000C | 2024-11-06T14:13:03.510Z | 2024-11-09T14:20:58.364Z |
5482311 | 5482311 | 20241104214727_OCClX | BE000C | 2024-11-06T14:12:56.633Z | 2024-11-09T14:20:57.832Z |
5482293 | 5482293 | 20241104214531_Js4P2 | BE000C | 2024-11-06T14:12:50.983Z | 2024-11-09T14:20:57.632Z |
5482193 | 5482193 | 20241104212344_w5wNO | BE000C | 2024-11-06T14:12:34.628Z | 2024-11-09T14:20:56.361Z |
5482178 | 5482178 | 20241104212143_K8tgB | BE000C | 2024-11-06T14:12:31.943Z | 2024-11-09T14:20:56.005Z |
5482120 | 5482120 | 20241104211004_ZWS7P | BE000C | 2024-11-06T14:12:25.453Z | 2024-11-09T14:20:55.624Z |
5482070 | 5482070 | 20241104210011_2Xztm | BE000C | 2024-11-06T14:12:20.377Z | 2024-11-09T14:20:55.054Z |
5482030 | 5482030 | 20241104205242_uCZve | BE000C | 2024-11-06T14:12:16.006Z | 2024-11-09T14:20:54.327Z |
5482020 | 5482020 | 20241104205029_4AeLn | BE000C | 2024-11-06T14:12:15.275Z | 2024-11-09T14:20:54.275Z |
5481949 | 5481949 | 20241104202744_50x2D | BE000C | 2024-11-06T14:11:59.116Z | 2024-11-09T14:20:53.232Z |
5481928 | 5481928 | 20241104202311_VMbyf | BE000C | 2024-11-06T14:11:52.895Z | 2024-11-09T14:20:52.750Z |
5481891 | 5481891 | 20241104201113_AODmP | BE000C | 2024-11-06T14:11:48.031Z | 2024-11-09T14:20:52.266Z |
5481796 | 5481796 | 20241104194521_UEDCN | BE000C | 2024-11-06T14:11:35.812Z | 2024-11-09T14:20:51.173Z |
5481619 | 5481619 | 20241104185132_GqnVc | BE000C | 2024-11-06T14:10:58.684Z | 2024-11-09T14:20:48.311Z |
5481613 | 5481613 | 20241104185025_ekmQd | BE000C | 2024-11-06T14:10:56.537Z | 2024-11-09T14:20:48.161Z |
5481593 | 5481593 | 20241104184301_ZWqJZ | BE000C | 2024-11-06T14:10:53.957Z | 2024-11-09T14:20:47.779Z |
5481582 | 5481582 | 20241104183935_WeMef | BE000C | 2024-11-06T14:10:52.847Z | 2024-11-09T14:20:47.548Z |
5477915 | 5477915 | 20241104025307_ajpOl | BE000C | 2024-11-05T14:17:36.344Z | 2024-11-09T14:22:22.903Z |
5477749 | 5477749 | 20241104023216_iC1JP | BE000C | 2024-11-05T14:17:22.212Z | 2024-11-09T14:22:21.568Z |
5477740 | 5477740 | 20241104023037_3QkFm | BE000C | 2024-11-05T14:17:20.956Z | 2024-11-09T14:22:21.483Z |
5477718 | 5477718 | 20241104022543_EYIMu | BE000C | 2024-11-05T14:17:19.055Z | 2024-11-09T14:22:21.199Z |
5477652 | 5477652 | 20241104021719_Rm3K1 | BE000C | 2024-11-05T14:17:12.879Z | 2024-11-09T14:22:20.506Z |
5477608 | 5477608 | 20241104021301_KRc8J | BE000C | 2024-11-05T14:17:08.995Z | 2024-11-09T14:22:19.984Z |
5477600 | 5477600 | 20241104021219_X9mGv | BE000C | 2024-11-05T14:17:08.166Z | 2024-11-09T14:22:19.890Z |
5477578 | 5477578 | 20241104021028_dGBzE | BE000C | 2024-11-05T14:17:04.877Z | 2024-11-09T14:22:19.665Z |
5477562 | 5477562 | 20241104020832_1VYLC | BE000C | 2024-11-05T14:17:03.575Z | 2024-11-09T14:22:19.557Z |
5477460 | 5477460 | 20241104015841_KKt7V | BE000C | 2024-11-05T14:16:54.953Z | 2024-11-09T14:22:17.869Z |
5477453 | 5477453 | 20241104015634_gi8mE | BE000C | 2024-11-05T14:16:54.486Z | 2024-11-09T14:22:17.819Z |
5477390 | 5477390 | 20241104014709_Ke5o1 | BE000C | 2024-11-05T14:16:49.374Z | 2024-11-09T14:22:17.206Z |
5477364 | 5477364 | 20241104014212_5lL5o | BE000C | 2024-11-05T14:16:46.807Z | 2024-11-09T14:22:16.976Z |
5477230 | 5477230 | 20241104012226_x8i27 | BE000C | 2024-11-05T14:16:33.751Z | 2024-11-09T14:22:15.987Z |
5477167 | 5477167 | 20241104011031_ddap2 | BE000C | 2024-11-05T14:16:28.447Z | 2024-11-09T14:22:15.087Z |
5477159 | 5477159 | 20241104010937_1LLI3 | BE000C | 2024-11-05T14:16:28.070Z | 2024-11-09T14:22:14.999Z |
5476216 | 5476216 | 20241103224625_F62k3 | BE000C | 2024-11-05T14:14:53.452Z | 2024-11-09T14:22:07.014Z |
5476211 | 5476211 | 20241103224451_D6Ma2 | BE000C | 2024-11-05T14:14:52.305Z | 2024-11-09T14:22:06.996Z |
5476199 | 5476199 | 20241103224101_9OhFd | BE000C | 2024-11-05T14:14:51.291Z | 2024-11-09T14:22:06.694Z |
5476106 | 5476106 | 20241103222628_8pt3B | BE000C | 2024-11-05T14:14:45.654Z | 2024-11-09T14:22:05.882Z |
5475887 | 5475887 | 20241103214538_MTpD2 | BE000C | 2024-11-05T14:14:30.552Z | 2024-11-09T14:22:03.690Z |
5475834 | 5475834 | 20241103213150_gpsVI | BE000C | 2024-11-05T14:14:20.511Z | 2024-11-09T14:22:02.735Z |
5475729 | 5475729 | 20241103211034_jP5df | BE000C | 2024-11-05T14:14:03.740Z | 2024-11-09T14:22:01.697Z |
5475718 | 5475718 | 20241103210920_hvWY0 | BE000C | 2024-11-05T14:14:03.246Z | 2024-11-09T14:22:01.551Z |
5475653 | 5475653 | 20241103205517_gfGvM | BE000C | 2024-11-05T14:13:55.990Z | 2024-11-09T14:22:00.697Z |
5475542 | 5475542 | 20241103203157_3mjyV | BE000C | 2024-11-05T14:13:47.273Z | 2024-11-09T14:21:59.826Z |
5475170 | 5475170 | 20241103192245_Xz2UN | BE000C | 2024-11-05T14:12:38.702Z | 2024-11-09T14:21:56.358Z |
5475087 | 5475087 | 20241103190354_mhAD3 | BE000C | 2024-11-05T14:12:30.509Z | 2024-11-09T14:21:55.719Z |
5475016 | 5475016 | 20241103185147_Ku26U | BE000C | 2024-11-05T14:12:24.715Z | 2024-11-09T14:21:55.182Z |
5474911 | 5474911 | 20241103183618_bxQO0 | BE000C | 2024-11-05T14:12:15.871Z | 2024-11-09T14:21:54.251Z |
5474824 | 5474824 | 20241103182208_FYqrp | BE000C | 2024-11-05T14:12:08.019Z | 2024-11-09T14:21:52.954Z |
5474779 | 5474779 | 20241103181443_x0b8b | BE000C | 2024-11-05T14:11:57.412Z | 2024-11-09T14:21:52.367Z |
5474714 | 5474714 | 20241103180339_vgNNt | BE000C | 2024-11-05T14:11:41.798Z | 2024-11-09T14:21:50.882Z |
5454761 | 5454761 | 20241031050944_ye9yZ | BE000C | 2024-11-02T12:23:20.901Z | 2024-11-08T14:23:25.515Z |
5454682 | 5454682 | 20241031045500_xYOHl | BE000C | 2024-11-02T12:23:16.810Z | 2024-11-08T14:23:24.750Z |
5454276 | 5454276 | 20241031040431_UTlbo | BE000C | 2024-11-02T12:22:57.469Z | 2024-11-08T14:23:21.973Z |
5454239 | 5454239 | 20241031040121_2I4ki | BE000C | 2024-11-02T12:22:55.679Z | 2024-11-08T14:23:21.664Z |
5454218 | 5454218 | 20241031035810_VnTEh | BE000C | 2024-11-02T12:22:55.180Z | 2024-11-08T14:23:21.430Z |
5454097 | 5454097 | 20241031034128_9oMbh | BE000C | 2024-11-02T12:22:50.723Z | 2024-11-08T14:23:20.446Z |
5454034 | 5454034 | 20241031033322_6hDXA | BE000C | 2024-11-02T12:22:49.071Z | 2024-11-08T14:23:20.073Z |
5453961 | 5453961 | 20241031032311_R0woz | BE000C | 2024-11-02T12:22:46.235Z | 2024-11-08T14:23:19.791Z |
5453957 | 5453957 | 20241031032153_KGWVC | BE000C | 2024-11-02T12:22:45.833Z | 2024-11-08T14:23:19.727Z |
5453881 | 5453881 | 20241031031223_wuOG1 | BE000C | 2024-11-02T12:22:44.211Z | 2024-11-08T14:23:19.602Z |
5453752 | 5453752 | 20241031025621_ePIm1 | BE000C | 2024-11-02T12:22:41.918Z | 2024-11-08T14:23:18.980Z |
5453600 | 5453600 | 20241031022901_IoM9T | BE000C | 2024-11-02T12:22:36.831Z | 2024-11-08T14:23:18.174Z |
5453543 | 5453543 | 20241031022201_S2hxf | BE000C | 2024-11-02T12:22:35.742Z | 2024-11-08T14:23:18.030Z |
5453470 | 5453470 | 20241031021454_QtYYM | BE000C | 2024-11-02T12:22:34.317Z | 2024-11-08T14:23:17.566Z |
5453309 | 5453309 | 20241031020102_EWKBS | BE000C | 2024-11-02T12:22:31.670Z | 2024-11-08T14:23:16.555Z |
5453270 | 5453270 | 20241031015515_qe2qC | BE000C | 2024-11-02T12:22:30.701Z | 2024-11-08T14:23:16.286Z |
5453044 | 5453044 | 20241031012941_m9U0x | BE000C | 2024-11-02T12:22:24.799Z | 2024-11-08T14:23:15.787Z |
5450209 | 5450209 | 20241031181649_uw0Dd | BE000C | 2024-11-02T12:14:46.435Z | 2024-11-09T14:24:14.700Z |
5450168 | 5450168 | 20241031180559_639ei | BE000C | 2024-11-02T12:14:40.767Z | 2024-11-09T14:24:14.126Z |
5450075 | 5450075 | 20241031174645_ndnkk | BE000C | 2024-11-02T12:14:23.102Z | 2024-11-09T14:24:13.443Z |
5444460 | 5444460 | 20241031012300_eB6Lc | BE000C | 2024-11-01T12:21:18.423Z | 2024-11-08T14:23:15.654Z |
5444435 | 5444435 | 20241031012107_roYEr | BE000C | 2024-11-01T12:21:17.787Z | 2024-11-08T14:23:15.576Z |
5444337 | 5444337 | 20241031011001_qMWLI | BE000C | 2024-11-01T12:21:13.172Z | 2024-11-08T14:23:14.360Z |
5444193 | 5444193 | 20241031005756_wEhKm | BE000C | 2024-11-01T12:21:08.846Z | 2024-11-08T14:23:14.084Z |
5444034 | 5444034 | 20241031004036_FvqxB | BE000C | 2024-11-01T12:21:02.560Z | 2024-11-08T14:23:13.586Z |
5443953 | 5443953 | 20241031003311_483ya | BE000C | 2024-11-01T12:20:58.802Z | 2024-11-08T14:23:13.316Z |
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);