participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,082 rows where station_code = "UK0042" 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 |
---|---|---|---|---|---|
5134081 | 5134081 | 20240916044441_W5pWv | UK0042 | 2024-09-19T12:17:18.307Z | 2024-09-19T12:17:18.307Z |
5133960 | 5133960 | 20240916042059_hD2ru | UK0042 | 2024-09-19T12:17:14.477Z | 2024-09-19T12:17:14.477Z |
5132913 | 5132913 | 20240916022850_E6Oav | UK0042 | 2024-09-19T12:16:35.911Z | 2024-09-19T12:16:35.911Z |
5132824 | 5132824 | 20240916021859_71Yfn | UK0042 | 2024-09-19T12:16:33.753Z | 2024-09-19T12:16:33.753Z |
5132806 | 5132806 | 20240916021515_8gZYt | UK0042 | 2024-09-19T12:16:33.366Z | 2024-09-19T12:16:33.366Z |
5132780 | 5132780 | 20240916021145_oEK6D | UK0042 | 2024-09-19T12:16:32.426Z | 2024-09-19T12:16:32.426Z |
5132748 | 5132748 | 20240916020446_ly8Q6 | UK0042 | 2024-09-19T12:16:30.753Z | 2024-09-19T12:16:30.753Z |
5132604 | 5132604 | 20240916014141_JHh9m | UK0042 | 2024-09-19T12:16:22.142Z | 2024-09-19T12:16:22.142Z |
5132591 | 5132591 | 20240916013741_8JOXx | UK0042 | 2024-09-19T12:16:20.758Z | 2024-09-19T12:16:20.758Z |
5132511 | 5132511 | 20240916012313_h5psZ | UK0042 | 2024-09-19T12:16:16.337Z | 2024-09-19T12:16:16.337Z |
5132279 | 5132279 | 20240916002247_DHiwZ | UK0042 | 2024-09-19T12:16:03.153Z | 2024-09-19T12:16:03.153Z |
5132015 | 5132015 | 20240915224843_JvzYU | UK0042 | 2024-09-19T12:15:43.933Z | 2024-09-19T12:15:43.933Z |
5129867 | 5129867 | 20240917044809_ht3nv | UK0042 | 2024-09-19T12:12:11.478Z | 2024-09-19T12:12:11.478Z |
5129834 | 5129834 | 20240917043812_1G37g | UK0042 | 2024-09-19T12:12:08.082Z | 2024-09-19T12:12:08.082Z |
5129787 | 5129787 | 20240917042906_nevS9 | UK0042 | 2024-09-19T12:12:04.758Z | 2024-09-19T12:12:04.758Z |
5129472 | 5129472 | 20240917035950_aH681 | UK0042 | 2024-09-19T12:11:41.322Z | 2024-09-19T12:11:41.322Z |
5129268 | 5129268 | 20240917034316_WzUDw | UK0042 | 2024-09-19T12:11:24.777Z | 2024-09-19T12:11:24.777Z |
5129227 | 5129227 | 20240917033849_JFQoF | UK0042 | 2024-09-19T12:11:23.653Z | 2024-09-19T12:11:23.653Z |
5129185 | 5129185 | 20240917033424_3aRqg | UK0042 | 2024-09-19T12:11:22.582Z | 2024-09-19T12:11:22.582Z |
5128989 | 5128989 | 20240917030359_i26mR | UK0042 | 2024-09-19T12:11:10.426Z | 2024-09-19T12:11:10.426Z |
5128902 | 5128902 | 20240917025239_9XJjF | UK0042 | 2024-09-19T12:11:05.973Z | 2024-09-19T12:11:05.973Z |
5128777 | 5128777 | 20240917023459_iFqY0 | UK0042 | 2024-09-19T12:11:01.267Z | 2024-09-19T12:11:01.267Z |
5128755 | 5128755 | 20240917023136_SKu3T | UK0042 | 2024-09-19T12:10:59.997Z | 2024-09-19T12:10:59.997Z |
5128586 | 5128586 | 20240917020759_7vm3g | UK0042 | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128498 | 5128498 | 20240917015222_IBDPu | UK0042 | 2024-09-19T12:10:39.312Z | 2024-09-19T12:10:39.312Z |
5128357 | 5128357 | 20240917013113_7lp2l | UK0042 | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128334 | 5128334 | 20240917012738_7wLoW | UK0042 | 2024-09-19T12:10:27.439Z | 2024-09-19T12:10:27.439Z |
5128294 | 5128294 | 20240917012201_PHVbY | UK0042 | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128184 | 5128184 | 20240917010457_029vC | UK0042 | 2024-09-19T12:10:19.784Z | 2024-09-19T12:10:19.784Z |
5128063 | 5128063 | 20240917003155_vMecy | UK0042 | 2024-09-19T12:09:59.460Z | 2024-09-19T12:09:59.460Z |
5127977 | 5127977 | 20240917001543_z3xIM | UK0042 | 2024-09-19T12:09:51.875Z | 2024-09-19T12:09:51.875Z |
5127967 | 5127967 | 20240917001114_tyHjc | UK0042 | 2024-09-19T12:09:49.525Z | 2024-09-19T12:09:49.525Z |
5127906 | 5127906 | 20240917000505_sC3Ql | UK0042 | 2024-09-19T12:09:46.714Z | 2024-09-19T12:09:46.714Z |
5127829 | 5127829 | 20240916234359_kBzyE | UK0042 | 2024-09-19T12:09:41.821Z | 2024-09-19T12:09:41.821Z |
5127800 | 5127800 | 20240916233537_Vtufh | UK0042 | 2024-09-19T12:09:40.029Z | 2024-09-19T12:09:40.029Z |
5127795 | 5127795 | 20240916233505_c3G27 | UK0042 | 2024-09-19T12:09:39.350Z | 2024-09-19T12:09:39.350Z |
5127665 | 5127665 | 20240916224750_sNc8t | UK0042 | 2024-09-19T12:09:30.363Z | 2024-09-19T12:09:30.363Z |
5127574 | 5127574 | 20240916223009_dCnVN | UK0042 | 2024-09-19T12:09:24.257Z | 2024-09-19T12:09:24.257Z |
5127535 | 5127535 | 20240916221855_C2PeJ | UK0042 | 2024-09-19T12:09:18.576Z | 2024-09-19T12:09:18.576Z |
5127436 | 5127436 | 20240916215228_fyYNu | UK0042 | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5127381 | 5127381 | 20240916214237_wssGw | UK0042 | 2024-09-19T12:09:01.131Z | 2024-09-19T12:09:01.131Z |
5126959 | 5126959 | 20240916200134_DfSMC | UK0042 | 2024-09-19T12:07:48.716Z | 2024-09-19T12:07:48.716Z |
5125837 | 5125837 | 20240918040647_u2Yhj | UK0042 | 2024-09-19T12:04:13.017Z | 2024-09-19T12:06:42.093Z |
5125833 | 5125833 | 20240918040330_aqES8 | UK0042 | 2024-09-19T12:04:11.905Z | 2024-09-19T12:06:42.092Z |
5125613 | 5125613 | 20240918030908_Vor62 | UK0042 | 2024-09-19T12:03:42.984Z | 2024-09-19T12:06:42.058Z |
5125580 | 5125580 | 20240918030406_8HNgO | UK0042 | 2024-09-19T12:03:34.544Z | 2024-09-19T12:06:42.054Z |
5125486 | 5125486 | 20240918024913_3ePAR | UK0042 | 2024-09-19T12:03:21.989Z | 2024-09-19T12:06:42.041Z |
5125484 | 5125484 | 20240918024811_fOyKe | UK0042 | 2024-09-19T12:03:21.446Z | 2024-09-19T12:06:42.041Z |
5125461 | 5125461 | 20240918024027_x3XCZ | UK0042 | 2024-09-19T12:03:18.447Z | 2024-09-19T12:06:42.037Z |
5125442 | 5125442 | 20240918023837_mAgAS | UK0042 | 2024-09-19T12:03:15.387Z | 2024-09-19T12:06:42.033Z |
5125425 | 5125425 | 20240918023604_GEYsf | UK0042 | 2024-09-19T12:03:13.502Z | 2024-09-19T12:06:42.031Z |
5125396 | 5125396 | 20240918022835_IQf3K | UK0042 | 2024-09-19T12:03:09.420Z | 2024-09-19T12:06:42.026Z |
5125375 | 5125375 | 20240918022355_4PcBv | UK0042 | 2024-09-19T12:03:07.306Z | 2024-09-19T12:06:42.023Z |
5125351 | 5125351 | 20240918021737_GMWlk | UK0042 | 2024-09-19T12:03:02.780Z | 2024-09-19T12:06:42.018Z |
5125304 | 5125304 | 20240918015714_bGbiF | UK0042 | 2024-09-19T12:02:42.741Z | 2024-09-19T12:06:42.008Z |
5125299 | 5125299 | 20240918015709_uNuTF | UK0042 | 2024-09-19T12:02:42.306Z | 2024-09-19T12:06:42.007Z |
5125286 | 5125286 | 20240918015530_VE2UK | UK0042 | 2024-09-19T12:02:41.158Z | 2024-09-19T12:06:42.005Z |
5125277 | 5125277 | 20240918015211_RosXD | UK0042 | 2024-09-19T12:02:39.818Z | 2024-09-19T12:06:42.004Z |
5125251 | 5125251 | 20240918013655_YGTDV | UK0042 | 2024-09-19T12:02:36.225Z | 2024-09-19T12:06:41.999Z |
5125183 | 5125183 | 20240918010155_AU8rk | UK0042 | 2024-09-19T12:02:27.873Z | 2024-09-19T12:06:41.988Z |
5125158 | 5125158 | 20240918003832_WaDDv | UK0042 | 2024-09-19T12:02:24.861Z | 2024-09-19T12:06:41.983Z |
5125147 | 5125147 | 20240918003320_5ZH52 | UK0042 | 2024-09-19T12:02:24.056Z | 2024-09-19T12:06:41.982Z |
5125138 | 5125138 | 20240918002709_LJepw | UK0042 | 2024-09-19T12:02:23.341Z | 2024-09-19T12:06:41.981Z |
5125051 | 5125051 | 20240917235057_vWFUY | UK0042 | 2024-09-19T12:02:03.105Z | 2024-09-19T12:06:41.968Z |
5125049 | 5125049 | 20240917235024_lJLR6 | UK0042 | 2024-09-19T12:02:02.599Z | 2024-09-19T12:06:41.967Z |
5125025 | 5125025 | 20240917233324_zj5tc | UK0042 | 2024-09-19T12:01:57.513Z | 2024-09-19T12:06:41.963Z |
5125015 | 5125015 | 20240917233231_nf9pY | UK0042 | 2024-09-19T12:01:56.713Z | 2024-09-19T12:06:41.962Z |
5124944 | 5124944 | 20240917225608_CRlD2 | UK0042 | 2024-09-19T12:01:50.474Z | 2024-09-19T12:06:41.955Z |
5124835 | 5124835 | 20240917221520_RcOc1 | UK0042 | 2024-09-19T12:01:39.490Z | 2024-09-19T12:06:41.941Z |
5124800 | 5124800 | 20240917220341_25iBX | UK0042 | 2024-09-19T12:01:35.833Z | 2024-09-19T12:06:41.936Z |
5124781 | 5124781 | 20240917220112_DZ7h4 | UK0042 | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124706 | 5124706 | 20240917215057_8SuHw | UK0042 | 2024-09-19T12:01:21.598Z | 2024-09-19T12:06:41.927Z |
5124587 | 5124587 | 20240917212232_dI0is | UK0042 | 2024-09-19T12:01:10.902Z | 2024-09-19T12:06:41.914Z |
5124570 | 5124570 | 20240917211327_fRJG0 | UK0042 | 2024-09-19T12:01:09.248Z | 2024-09-19T12:06:41.912Z |
5124522 | 5124522 | 20240917205551_GBozT | UK0042 | 2024-09-19T12:01:05.529Z | 2024-09-19T12:06:41.907Z |
5124494 | 5124494 | 20240917204840_m1XmY | UK0042 | 2024-09-19T12:01:02.689Z | 2024-09-19T12:06:41.903Z |
5124463 | 5124463 | 20240917202910_S1vA3 | UK0042 | 2024-09-19T12:00:58.335Z | 2024-09-19T12:06:41.898Z |
5124441 | 5124441 | 20240917202117_SRq2Q | UK0042 | 2024-09-19T12:00:56.024Z | 2024-09-19T12:06:41.895Z |
5124437 | 5124437 | 20240917201828_1I1UJ | UK0042 | 2024-09-19T12:00:53.659Z | 2024-09-19T12:06:41.895Z |
5124362 | 5124362 | 20240917194210_pmXYw | UK0042 | 2024-09-19T12:00:39.295Z | 2024-09-19T12:06:41.883Z |
5124356 | 5124356 | 20240917194129_1eyG7 | UK0042 | 2024-09-19T12:00:38.469Z | 2024-09-19T12:06:41.882Z |
5121994 | 5121994 | 20240914042433_zg0kx | UK0042 | 2024-09-18T12:11:03.928Z | 2024-09-19T12:20:02.573Z |
5121623 | 5121623 | 20240914041042_HtKAC | UK0042 | 2024-09-18T12:10:58.922Z | 2024-09-19T12:20:02.186Z |
5121611 | 5121611 | 20240914041027_ZjFMf | UK0042 | 2024-09-18T12:10:58.865Z | 2024-09-19T12:20:02.185Z |
5119117 | 5119117 | 20240914021212_g33OE | UK0042 | 2024-09-18T12:10:16.408Z | 2024-09-19T12:19:57.196Z |
5116639 | 5116639 | 20240915033354_YOEmr | UK0042 | 2024-09-18T12:07:14.186Z | 2024-09-19T12:19:11.804Z |
5116532 | 5116532 | 20240915033116_Lx8aQ | UK0042 | 2024-09-18T12:07:09.025Z | 2024-09-19T12:19:11.487Z |
5114471 | 5114471 | 20240915014409_HzMIi | UK0042 | 2024-09-18T12:05:19.344Z | 2024-09-19T12:18:58.465Z |
5114418 | 5114418 | 20240915014110_JrNif | UK0042 | 2024-09-18T12:05:14.433Z | 2024-09-19T12:18:57.943Z |
5113970 | 5113970 | 20240915012116_1VSgb | UK0042 | 2024-09-18T12:04:56.776Z | 2024-09-19T12:18:54.884Z |
5113586 | 5113586 | 20240915005955_fLgDB | UK0042 | 2024-09-18T12:04:34.180Z | 2024-09-19T12:18:50.510Z |
5113416 | 5113416 | 20240915004805_b42ud | UK0042 | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5113232 | 5113232 | 20240915003257_s1w3d | UK0042 | 2024-09-18T12:04:04.299Z | 2024-09-19T12:18:48.224Z |
5112924 | 5112924 | 20240915000653_3UA7I | UK0042 | 2024-09-18T12:03:47.606Z | 2024-09-19T12:18:45.881Z |
5112607 | 5112607 | 20240914233444_D7QiL | UK0042 | 2024-09-18T12:03:16.628Z | 2024-09-19T12:18:41.631Z |
5112540 | 5112540 | 20240914232830_Ay5Rv | UK0042 | 2024-09-18T12:03:12.858Z | 2024-09-19T12:18:41.419Z |
5112372 | 5112372 | 20240914230622_sluI3 | UK0042 | 2024-09-18T12:03:01.687Z | 2024-09-19T12:18:40.750Z |
5112300 | 5112300 | 20240914225223_Pdi0R | UK0042 | 2024-09-18T12:02:58.951Z | 2024-09-19T12:18:40.427Z |
5112136 | 5112136 | 20240914222523_j8gmB | UK0042 | 2024-09-18T12:02:49.675Z | 2024-09-19T12:18:38.641Z |
5112063 | 5112063 | 20240914220647_F1I22 | UK0042 | 2024-09-18T12:02:45.268Z | 2024-09-19T12:18:37.782Z |
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);