participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
397 rows where station_code = "UK00C3" 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 |
---|---|---|---|---|---|
5454680 | 5454680 | 20241031045456_RJh0U | UK00C3 | 2024-11-02T12:23:16.701Z | 2024-11-08T14:23:24.748Z |
5451920 | 5451920 | 20241101012740_K4y3Y | UK00C3 | 2024-11-02T12:18:06.114Z | 2024-11-09T14:24:26.660Z |
5451765 | 5451765 | 20241101010026_OXYq7 | UK00C3 | 2024-11-02T12:17:56.256Z | 2024-11-09T14:24:25.381Z |
5442968 | 5442968 | 20241030030635_bUcHx | UK00C3 | 2024-11-01T12:20:14.602Z | 2024-11-07T14:26:49.066Z |
5442663 | 5442663 | 20241030021054_XXJIb | UK00C3 | 2024-11-01T12:20:04.485Z | 2024-11-07T14:26:47.485Z |
5442373 | 5442373 | 20241030012217_OwfwL | UK00C3 | 2024-11-01T12:19:45.035Z | 2024-11-07T14:26:46.380Z |
5442280 | 5442280 | 20241030010615_1gnFi | UK00C3 | 2024-11-01T12:19:37.811Z | 2024-11-07T14:26:45.827Z |
5441809 | 5441809 | 20241029234053_o9cN8 | UK00C3 | 2024-11-01T12:19:03.110Z | 2024-11-07T14:26:43.476Z |
5441552 | 5441552 | 20241029223520_qrrYT | UK00C3 | 2024-11-01T12:18:44.472Z | 2024-11-07T14:26:42.648Z |
5441298 | 5441298 | 20241029213341_3Xhn1 | UK00C3 | 2024-11-01T12:18:25.155Z | 2024-11-07T14:26:41.596Z |
5432704 | 5432704 | 20241029042139_gfI9V | UK00C3 | 2024-10-31T12:21:31.821Z | 2024-11-06T14:27:28.501Z |
5410800 | 5410800 | 20241027053748_lNw7V | UK00C3 | 2024-10-29T12:18:05.218Z | 2024-11-04T14:29:05.500Z |
5410079 | 5410079 | 20241027045207_1TjLi | UK00C3 | 2024-10-29T12:17:47.179Z | 2024-11-04T14:29:03.669Z |
5409575 | 5409575 | 20241027042546_KOBrQ | UK00C3 | 2024-10-29T12:17:30.908Z | 2024-11-04T14:29:01.962Z |
5409380 | 5409380 | 20241027041326_SJ6bX | UK00C3 | 2024-10-29T12:17:18.693Z | 2024-11-04T14:29:01.608Z |
5409184 | 5409184 | 20241027040510_L5r1i | UK00C3 | 2024-10-29T12:17:10.493Z | 2024-11-04T14:29:01.355Z |
5408964 | 5408964 | 20241027035134_DaS3U | UK00C3 | 2024-10-29T12:16:58.206Z | 2024-11-04T14:29:00.872Z |
5407478 | 5407478 | 20241027023830_WjmaM | UK00C3 | 2024-10-29T12:15:26.065Z | 2024-11-04T14:28:57.655Z |
5407160 | 5407160 | 20241027022410_d8omz | UK00C3 | 2024-10-29T12:15:15.135Z | 2024-11-04T14:28:57.116Z |
5407056 | 5407056 | 20241027021848_2V2Rh | UK00C3 | 2024-10-29T12:15:10.300Z | 2024-11-04T14:28:56.815Z |
5406619 | 5406619 | 20241027014857_VuRt8 | UK00C3 | 2024-10-29T12:14:25.250Z | 2024-11-04T14:28:55.924Z |
5406069 | 5406069 | 20241027011402_IEdi6 | UK00C3 | 2024-10-29T12:13:49.976Z | 2024-11-04T14:28:54.916Z |
5406036 | 5406036 | 20241027011245_Lj2ZT | UK00C3 | 2024-10-29T12:13:48.660Z | 2024-11-04T14:28:54.896Z |
5404755 | 5404755 | 20241026235057_U75k9 | UK00C3 | 2024-10-29T12:11:56.082Z | 2024-11-04T14:28:51.905Z |
5404713 | 5404713 | 20241026234709_lYqMt | UK00C3 | 2024-10-29T12:11:53.948Z | 2024-11-04T14:28:51.689Z |
5404578 | 5404578 | 20241026233905_qFuyg | UK00C3 | 2024-10-29T12:11:43.932Z | 2024-11-04T14:28:51.349Z |
5404553 | 5404553 | 20241026233627_UriQw | UK00C3 | 2024-10-29T12:11:42.161Z | 2024-11-04T14:28:51.318Z |
5385311 | 5385311 | 20241024222101_Hul7N | UK00C3 | 2024-10-27T12:18:43.709Z | 2024-11-02T12:28:29.539Z |
5372271 | 5372271 | 20241024004204_iXmt9 | UK00C3 | 2024-10-26T12:19:17.433Z | 2024-11-01T12:26:57.334Z |
5365182 | 5365182 | 20241023231952_lvqb2 | UK00C3 | 2024-10-25T12:17:50.396Z | 2024-11-01T12:26:55.959Z |
5365066 | 5365066 | 20241023231206_2woE1 | UK00C3 | 2024-10-25T12:17:44.884Z | 2024-11-01T12:26:55.846Z |
5364671 | 5364671 | 20241023224535_3czGB | UK00C3 | 2024-10-25T12:17:29.062Z | 2024-11-01T12:26:55.351Z |
5348957 | 5348957 | 20241022191151_McGs9 | UK00C3 | 2024-10-24T12:12:38.418Z | 2024-10-31T12:29:54.233Z |
5348622 | 5348622 | 20241022183639_9J5Ex | UK00C3 | 2024-10-24T12:11:49.918Z | 2024-10-31T12:29:53.159Z |
5348565 | 5348565 | 20241022183048_gtIyQ | UK00C3 | 2024-10-24T12:11:41.438Z | 2024-10-31T12:29:52.944Z |
5348339 | 5348339 | 20241022180606_yttNM | UK00C3 | 2024-10-24T12:11:01.387Z | 2024-10-31T12:29:52.242Z |
5335407 | 5335407 | 20241021045951_s4Ekq | UK00C3 | 2024-10-22T12:18:11.480Z | 2024-10-29T12:26:36.249Z |
5311094 | 5311094 | 20241014230519_GulM4 | UK00C3 | 2024-10-16T12:08:19.918Z | 2024-10-23T12:24:40.996Z |
5310885 | 5310885 | 20241014211637_n3Soc | UK00C3 | 2024-10-16T12:07:57.489Z | 2024-10-23T12:24:39.474Z |
5310835 | 5310835 | 20241014204913_3FL3U | UK00C3 | 2024-10-16T12:07:52.997Z | 2024-10-23T12:24:39.215Z |
5310817 | 5310817 | 20241014203733_243c1 | UK00C3 | 2024-10-16T12:07:50.662Z | 2024-10-23T12:24:38.898Z |
5306832 | 5306832 | 20241014041219_L4www | UK00C3 | 2024-10-15T12:08:29.130Z | 2024-10-22T12:24:44.677Z |
5306804 | 5306804 | 20241014040333_pXs2j | UK00C3 | 2024-10-15T12:08:25.672Z | 2024-10-22T12:24:43.752Z |
5306795 | 5306795 | 20241014035908_uWf2v | UK00C3 | 2024-10-15T12:08:24.537Z | 2024-10-22T12:24:43.652Z |
5306742 | 5306742 | 20241014034730_1nmls | UK00C3 | 2024-10-15T12:08:18.961Z | 2024-10-22T12:24:42.982Z |
5306737 | 5306737 | 20241014034616_9jch3 | UK00C3 | 2024-10-15T12:08:18.445Z | 2024-10-22T12:24:42.895Z |
5306695 | 5306695 | 20241014033636_803CP | UK00C3 | 2024-10-15T12:08:13.629Z | 2024-10-22T12:24:42.130Z |
5306668 | 5306668 | 20241014032746_6rHBB | UK00C3 | 2024-10-15T12:08:10.746Z | 2024-10-22T12:24:41.807Z |
5306657 | 5306657 | 20241014032439_Kz6BF | UK00C3 | 2024-10-15T12:08:09.690Z | 2024-10-22T12:24:41.745Z |
5306610 | 5306610 | 20241014030720_C37aC | UK00C3 | 2024-10-15T12:08:04.756Z | 2024-10-22T12:24:41.235Z |
5306588 | 5306588 | 20241014025726_nQmEK | UK00C3 | 2024-10-15T12:08:02.399Z | 2024-10-22T12:24:40.870Z |
5306580 | 5306580 | 20241014025615_HHFyE | UK00C3 | 2024-10-15T12:08:01.375Z | 2024-10-22T12:24:40.862Z |
5306568 | 5306568 | 20241014025352_7KoEy | UK00C3 | 2024-10-15T12:07:57.728Z | 2024-10-22T12:24:40.747Z |
5306328 | 5306328 | 20241014020105_2npzP | UK00C3 | 2024-10-15T12:07:12.429Z | 2024-10-22T12:24:38.278Z |
5306265 | 5306265 | 20241014014944_KkOBV | UK00C3 | 2024-10-15T12:07:05.698Z | 2024-10-22T12:24:37.664Z |
5306254 | 5306254 | 20241014014720_608OW | UK00C3 | 2024-10-15T12:07:04.366Z | 2024-10-22T12:24:37.484Z |
5306247 | 5306247 | 20241014014316_ZaKZW | UK00C3 | 2024-10-15T12:07:03.151Z | 2024-10-22T12:24:37.463Z |
5304409 | 5304409 | 20241014050550_rfa4j | UK00C3 | 2024-10-15T12:00:15.520Z | 2024-10-23T12:24:08.425Z |
5304406 | 5304406 | 20241014050432_2JR28 | UK00C3 | 2024-10-15T12:00:14.134Z | 2024-10-23T12:24:07.956Z |
5304395 | 5304395 | 20241014050102_JYMRk | UK00C3 | 2024-10-15T12:00:12.835Z | 2024-10-23T12:24:07.815Z |
5304386 | 5304386 | 20241014045822_nLIIf | UK00C3 | 2024-10-15T12:00:10.593Z | 2024-10-23T12:24:07.707Z |
5191455 | 5191455 | 20240928200741_2xRM3 | UK00C3 | 2024-09-30T12:17:47.918Z | 2024-10-06T12:28:22.666Z |
5182807 | 5182807 | 20240927231914_O2nFb | UK00C3 | 2024-09-29T12:16:17.297Z | 2024-10-05T12:29:09.131Z |
5182066 | 5182066 | 20240927220200_32Q5f | UK00C3 | 2024-09-29T12:15:41.968Z | 2024-10-05T12:29:07.757Z |
5181674 | 5181674 | 20240927212231_aIhnH | UK00C3 | 2024-09-29T12:15:20.789Z | 2024-10-05T12:29:06.534Z |
5181538 | 5181538 | 20240927210259_SC7HF | UK00C3 | 2024-09-29T12:15:11.937Z | 2024-10-05T12:29:05.954Z |
5178502 | 5178502 | 20240928030054_Vtml2 | UK00C3 | 2024-09-29T12:06:26.641Z | 2024-10-06T12:28:00.040Z |
5177322 | 5177322 | 20240928013352_iu56a | UK00C3 | 2024-09-29T12:04:08.791Z | 2024-10-06T12:27:54.897Z |
5176575 | 5176575 | 20240928004410_je3nC | UK00C3 | 2024-09-29T12:02:36.649Z | 2024-10-06T12:27:51.702Z |
5135778 | 5135778 | 20240918193422_BYgCL | UK00C3 | 2024-09-20T12:00:27.797Z | 2024-09-27T12:19:42.133Z |
5133991 | 5133991 | 20240916042709_7a9jH | UK00C3 | 2024-09-19T12:17:15.450Z | 2024-09-24T12:15:53.105Z |
5133897 | 5133897 | 20240916041615_yhgW6 | UK00C3 | 2024-09-19T12:17:12.673Z | 2024-09-24T12:15:52.146Z |
5133836 | 5133836 | 20240916040834_EWxyd | UK00C3 | 2024-09-19T12:17:10.044Z | 2024-09-24T12:15:51.610Z |
5133669 | 5133669 | 20240916035000_ySRCK | UK00C3 | 2024-09-19T12:17:04.958Z | 2024-09-24T12:15:50.623Z |
5133596 | 5133596 | 20240916034410_6xlig | UK00C3 | 2024-09-19T12:17:02.834Z | 2024-09-24T12:15:50.369Z |
5133489 | 5133489 | 20240916033229_MfMLr | UK00C3 | 2024-09-19T12:16:59.300Z | 2024-09-24T12:15:49.771Z |
5133439 | 5133439 | 20240916032951_wW9CU | UK00C3 | 2024-09-19T12:16:56.299Z | 2024-09-24T12:15:49.315Z |
5133401 | 5133401 | 20240916032749_bSoYG | UK00C3 | 2024-09-19T12:16:55.901Z | 2024-09-24T12:15:49.253Z |
5133108 | 5133108 | 20240916025621_vpekO | UK00C3 | 2024-09-19T12:16:44.228Z | 2024-09-24T12:15:47.267Z |
5132905 | 5132905 | 20240916022710_WFR7H | UK00C3 | 2024-09-19T12:16:35.660Z | 2024-09-24T12:15:45.974Z |
5132823 | 5132823 | 20240916021828_SSv83 | UK00C3 | 2024-09-19T12:16:33.509Z | 2024-09-24T12:15:45.464Z |
5132453 | 5132453 | 20240916011101_99Y5G | UK00C3 | 2024-09-19T12:16:13.528Z | 2024-09-24T12:15:42.854Z |
5132397 | 5132397 | 20240916005650_QVrvN | UK00C3 | 2024-09-19T12:16:10.829Z | 2024-09-24T12:15:42.596Z |
5132105 | 5132105 | 20240915232241_GU3I2 | UK00C3 | 2024-09-19T12:15:50.514Z | 2024-09-24T12:15:40.146Z |
5131886 | 5131886 | 20240915220029_xDUD3 | UK00C3 | 2024-09-19T12:15:32.238Z | 2024-09-24T12:15:38.431Z |
5131839 | 5131839 | 20240915213645_vrS3l | UK00C3 | 2024-09-19T12:15:27.661Z | 2024-09-24T12:15:37.474Z |
5131761 | 5131761 | 20240915210225_Qsc2I | UK00C3 | 2024-09-19T12:15:19.618Z | 2024-09-24T12:15:36.592Z |
5129577 | 5129577 | 20240917041036_NcG33 | UK00C3 | 2024-09-19T12:11:49.616Z | 2024-09-25T12:22:31.610Z |
5129335 | 5129335 | 20240917034940_Z32Lr | UK00C3 | 2024-09-19T12:11:29.344Z | 2024-09-25T12:22:30.279Z |
5129311 | 5129311 | 20240917034654_gA6cd | UK00C3 | 2024-09-19T12:11:26.439Z | 2024-09-25T12:22:30.033Z |
5129142 | 5129142 | 20240917032528_fq6Pu | UK00C3 | 2024-09-19T12:11:16.862Z | 2024-09-25T12:22:29.178Z |
5128956 | 5128956 | 20240917030146_KRAl1 | UK00C3 | 2024-09-19T12:11:09.333Z | 2024-09-25T12:22:27.994Z |
5128022 | 5128022 | 20240917002016_VD3L1 | UK00C3 | 2024-09-19T12:09:54.376Z | 2024-09-25T12:22:21.904Z |
5127487 | 5127487 | 20240916221109_8S1uG | UK00C3 | 2024-09-19T12:09:14.987Z | 2024-09-25T12:22:15.061Z |
5127409 | 5127409 | 20240916214524_3dbnT | UK00C3 | 2024-09-19T12:09:03.867Z | 2024-09-25T12:22:13.259Z |
5125764 | 5125764 | 20240918034300_Ez0Y2 | UK00C3 | 2024-09-19T12:04:02.654Z | 2024-09-26T12:18:43.512Z |
5125608 | 5125608 | 20240918030813_7iGdt | UK00C3 | 2024-09-19T12:03:39.236Z | 2024-09-26T12:18:42.190Z |
5125500 | 5125500 | 20240918024928_RkoXG | UK00C3 | 2024-09-19T12:03:23.270Z | 2024-09-26T12:18:41.428Z |
5125480 | 5125480 | 20240918024616_ZFEb1 | UK00C3 | 2024-09-19T12:03:20.583Z | 2024-09-26T12:18:41.405Z |
5125421 | 5125421 | 20240918023424_eVrc3 | UK00C3 | 2024-09-19T12:03:12.469Z | 2024-09-26T12:18:41.116Z |
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);