participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,806 rows where station_code = "UK001S" 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 |
---|---|---|---|---|---|
5433572 | 5433572 | 20241029202504_hmqx6 | UK001S | 2024-10-31T12:22:22.416Z | 2024-11-07T14:26:40.215Z |
5433420 | 5433420 | 20241029195032_XUZ1b | UK001S | 2024-10-31T12:22:14.159Z | 2024-11-07T14:26:39.315Z |
5433391 | 5433391 | 20241029193615_WvQGF | UK001S | 2024-10-31T12:22:12.044Z | 2024-11-07T14:26:38.919Z |
5421310 | 5421310 | 20241028054451_bXJU0 | UK001S | 2024-10-30T12:19:50.154Z | 2024-11-05T14:27:18.172Z |
5410335 | 5410335 | 20241027050707_1K6eG | UK001S | 2024-10-29T12:17:53.420Z | 2024-11-04T14:29:04.346Z |
5410290 | 5410290 | 20241027050526_0Wr2Q | UK001S | 2024-10-29T12:17:52.607Z | 2024-11-04T14:29:04.314Z |
5410221 | 5410221 | 20241027050029_2hblT | UK001S | 2024-10-29T12:17:50.921Z | 2024-11-04T14:29:04.202Z |
5409841 | 5409841 | 20241027043820_W8Geq | UK001S | 2024-10-29T12:17:42.362Z | 2024-11-04T14:29:02.816Z |
5409625 | 5409625 | 20241027042827_h9c2W | UK001S | 2024-10-29T12:17:34.168Z | 2024-11-04T14:29:02.023Z |
5409473 | 5409473 | 20241027042008_j3uvR | UK001S | 2024-10-29T12:17:25.662Z | 2024-11-04T14:29:01.853Z |
5409277 | 5409277 | 20241027040846_rxzqP | UK001S | 2024-10-29T12:17:14.575Z | 2024-11-04T14:29:01.447Z |
5408985 | 5408985 | 20241027035230_OoKjm | UK001S | 2024-10-29T12:16:59.827Z | 2024-11-04T14:29:00.898Z |
5408917 | 5408917 | 20241027034956_e8IYl | UK001S | 2024-10-29T12:16:57.132Z | 2024-11-04T14:29:00.824Z |
5408636 | 5408636 | 20241027033405_Yu5Dt | UK001S | 2024-10-29T12:16:41.913Z | 2024-11-04T14:28:59.711Z |
5408589 | 5408589 | 20241027033120_FgEod | UK001S | 2024-10-29T12:16:38.400Z | 2024-11-04T14:28:59.668Z |
5408551 | 5408551 | 20241027033015_JimKY | UK001S | 2024-10-29T12:16:35.922Z | 2024-11-04T14:28:59.615Z |
5408527 | 5408527 | 20241027032901_2BMhE | UK001S | 2024-10-29T12:16:34.560Z | 2024-11-04T14:28:59.605Z |
5408520 | 5408520 | 20241027032901_tVlBs | UK001S | 2024-10-29T12:16:34.284Z | 2024-11-04T14:28:59.593Z |
5408497 | 5408497 | 20241027032816_MnvOW | UK001S | 2024-10-29T12:16:33.266Z | 2024-11-04T14:28:59.566Z |
5407985 | 5407985 | 20241027030058_62XJv | UK001S | 2024-10-29T12:15:57.179Z | 2024-11-04T14:28:58.552Z |
5407979 | 5407979 | 20241027030058_7Ut9V | UK001S | 2024-10-29T12:15:56.966Z | 2024-11-04T14:28:58.551Z |
5407880 | 5407880 | 20241027025623_Pyuft | UK001S | 2024-10-29T12:15:50.494Z | 2024-11-04T14:28:58.289Z |
5407627 | 5407627 | 20241027024517_RVdVd | UK001S | 2024-10-29T12:15:31.926Z | 2024-11-04T14:28:57.954Z |
5407304 | 5407304 | 20241027023112_vVxL4 | UK001S | 2024-10-29T12:15:20.463Z | 2024-11-04T14:28:57.326Z |
5407172 | 5407172 | 20241027022457_RalF2 | UK001S | 2024-10-29T12:15:15.865Z | 2024-11-04T14:28:57.168Z |
5407094 | 5407094 | 20241027022218_4q33v | UK001S | 2024-10-29T12:15:12.227Z | 2024-11-04T14:28:56.843Z |
5406974 | 5406974 | 20241027021455_QR9Gj | UK001S | 2024-10-29T12:15:03.683Z | 2024-11-04T14:28:56.741Z |
5406779 | 5406779 | 20241027015943_0Y222 | UK001S | 2024-10-29T12:14:41.859Z | 2024-11-04T14:28:56.379Z |
5406758 | 5406758 | 20241027015842_R53Zk | UK001S | 2024-10-29T12:14:39.731Z | 2024-11-04T14:28:56.361Z |
5402760 | 5402760 | 20241026202223_wo2Vn | UK001S | 2024-10-29T12:08:06.522Z | 2024-11-04T14:28:46.477Z |
5402628 | 5402628 | 20241026200646_rsevq | UK001S | 2024-10-29T12:07:50.182Z | 2024-11-04T14:28:45.813Z |
5375646 | 5375646 | 20241024032257_eQfVm | UK001S | 2024-10-26T12:21:34.694Z | 2024-11-01T12:27:01.146Z |
5374530 | 5374530 | 20241024023211_yRHxo | UK001S | 2024-10-26T12:20:52.438Z | 2024-11-01T12:26:59.459Z |
5366366 | 5366366 | 20241024001750_NUMLr | UK001S | 2024-10-25T12:18:24.416Z | 2024-11-01T12:26:56.910Z |
5366358 | 5366358 | 20241024001707_X9aKI | UK001S | 2024-10-25T12:18:24.016Z | 2024-11-01T12:26:56.907Z |
5366218 | 5366218 | 20241024000929_Rmuhs | UK001S | 2024-10-25T12:18:19.369Z | 2024-11-01T12:26:56.799Z |
5366156 | 5366156 | 20241024000740_waCpp | UK001S | 2024-10-25T12:18:18.203Z | 2024-11-01T12:26:56.775Z |
5365968 | 5365968 | 20241023235944_NSQuX | UK001S | 2024-10-25T12:18:12.703Z | 2024-11-01T12:26:56.507Z |
5365831 | 5365831 | 20241023235138_hu64H | UK001S | 2024-10-25T12:18:08.456Z | 2024-11-01T12:26:56.445Z |
5365738 | 5365738 | 20241023234640_HGCci | UK001S | 2024-10-25T12:18:06.547Z | 2024-11-01T12:26:56.382Z |
5365281 | 5365281 | 20241023232429_YFEdx | UK001S | 2024-10-25T12:17:53.878Z | 2024-11-01T12:26:56.016Z |
5365123 | 5365123 | 20241023231600_Y4QEc | UK001S | 2024-10-25T12:17:46.926Z | 2024-11-01T12:26:55.886Z |
5364536 | 5364536 | 20241023223631_y30Tg | UK001S | 2024-10-25T12:17:24.093Z | 2024-11-01T12:26:55.181Z |
5364493 | 5364493 | 20241023223332_oDDfN | UK001S | 2024-10-25T12:17:22.837Z | 2024-11-01T12:26:55.156Z |
5364060 | 5364060 | 20241023220446_4dTBn | UK001S | 2024-10-25T12:17:07.480Z | 2024-11-01T12:26:54.358Z |
5363781 | 5363781 | 20241023214359_9A0tL | UK001S | 2024-10-25T12:16:45.015Z | 2024-11-01T12:26:53.621Z |
5341543 | 5341543 | 20241022013953_vMfXi | UK001S | 2024-10-23T12:15:57.685Z | 2024-10-30T12:26:47.199Z |
5341242 | 5341242 | 20241022012127_lKfFH | UK001S | 2024-10-23T12:15:32.670Z | 2024-10-30T12:26:46.690Z |
5340899 | 5340899 | 20241022005758_QH08c | UK001S | 2024-10-23T12:15:02.457Z | 2024-10-30T12:26:46.348Z |
5340873 | 5340873 | 20241022005649_qiIGj | UK001S | 2024-10-23T12:15:00.036Z | 2024-10-30T12:26:46.339Z |
5338455 | 5338455 | 20241021193839_lsT78 | UK001S | 2024-10-23T12:11:07.513Z | 2024-10-30T12:26:42.387Z |
5338387 | 5338387 | 20241021192716_LMoZ9 | UK001S | 2024-10-23T12:10:52.903Z | 2024-10-30T12:26:42.211Z |
5338365 | 5338365 | 20241021192259_h9d3d | UK001S | 2024-10-23T12:10:50.604Z | 2024-10-30T12:26:42.192Z |
5338133 | 5338133 | 20241021184355_JPQUU | UK001S | 2024-10-23T12:10:21.609Z | 2024-10-30T12:26:41.783Z |
5338054 | 5338054 | 20241021182746_I8SOs | UK001S | 2024-10-23T12:10:00.578Z | 2024-10-30T12:26:41.417Z |
5333108 | 5333108 | 20241020233850_BpsZn | UK001S | 2024-10-22T12:14:41.940Z | 2024-10-29T12:26:34.065Z |
5319699 | 5319699 | 20241017200852_oANdV | UK001S | 2024-10-19T12:03:33.063Z | 2024-10-26T12:27:52.910Z |
5319664 | 5319664 | 20241017194312_RU3Rs | UK001S | 2024-10-19T12:03:30.220Z | 2024-10-26T12:27:52.819Z |
5318506 | 5318506 | 20241017034024_6ftCB | UK001S | 2024-10-18T12:03:54.747Z | 2024-10-25T12:24:36.068Z |
5318474 | 5318474 | 20241017033408_KGaKP | UK001S | 2024-10-18T12:03:51.489Z | 2024-10-25T12:24:35.752Z |
5318439 | 5318439 | 20241017032606_F4Jti | UK001S | 2024-10-18T12:03:48.333Z | 2024-10-25T12:24:35.531Z |
5303374 | 5303374 | 20241013025521_0C3K3 | UK001S | 2024-10-14T12:17:22.942Z | 2024-10-21T12:24:17.708Z |
5301546 | 5301546 | 20241012234218_oSzDR | UK001S | 2024-10-14T12:15:30.767Z | 2024-10-21T12:23:59.011Z |
5300680 | 5300680 | 20241012212353_EmtQZ | UK001S | 2024-10-14T12:14:22.422Z | 2024-10-21T12:23:51.734Z |
5299770 | 5299770 | 20241012192951_3Zk58 | UK001S | 2024-10-14T12:13:08.447Z | 2024-10-21T12:23:43.746Z |
5299748 | 5299748 | 20241012192751_3zd30 | UK001S | 2024-10-14T12:13:06.960Z | 2024-10-21T12:23:43.670Z |
5294947 | 5294947 | 20241013051115_bS02h | UK001S | 2024-10-14T12:00:39.780Z | 2024-10-22T12:24:06.816Z |
5294825 | 5294825 | 20241013045905_ZoNGb | UK001S | 2024-10-14T12:00:25.219Z | 2024-10-22T12:24:05.889Z |
5294735 | 5294735 | 20241013044340_yLDNS | UK001S | 2024-10-14T12:00:15.545Z | 2024-10-22T12:24:04.889Z |
5291594 | 5291594 | 20241011212752_2VBYl | UK001S | 2024-10-13T12:14:50.832Z | 2024-10-20T12:24:33.804Z |
5291473 | 5291473 | 20241011210240_3Qjxj | UK001S | 2024-10-13T12:14:38.021Z | 2024-10-20T12:24:31.847Z |
5291442 | 5291442 | 20241011205920_KXpDK | UK001S | 2024-10-13T12:14:34.849Z | 2024-10-20T12:24:31.592Z |
5291339 | 5291339 | 20241011203728_xzVyw | UK001S | 2024-10-13T12:14:18.670Z | 2024-10-20T12:24:29.361Z |
5290892 | 5290892 | 20241011191512_uufnf | UK001S | 2024-10-13T12:13:35.292Z | 2024-10-20T12:24:22.161Z |
5283010 | 5283010 | 20241011002927_RgVdS | UK001S | 2024-10-12T12:16:18.112Z | 2024-10-19T12:27:48.138Z |
5282915 | 5282915 | 20241011000915_W2ZEw | UK001S | 2024-10-12T12:16:11.753Z | 2024-10-19T12:27:47.508Z |
5282877 | 5282877 | 20241011000230_B0XIF | UK001S | 2024-10-12T12:16:09.779Z | 2024-10-19T12:27:47.183Z |
5282376 | 5282376 | 20241010212906_XaBD2 | UK001S | 2024-10-12T12:15:30.285Z | 2024-10-19T12:27:43.580Z |
5282279 | 5282279 | 20241010210415_wakuG | UK001S | 2024-10-12T12:15:25.848Z | 2024-10-19T12:27:43.100Z |
5282074 | 5282074 | 20241010201434_UMcjp | UK001S | 2024-10-12T12:15:10.739Z | 2024-10-19T12:27:40.561Z |
5281997 | 5281997 | 20241010200349_Jjahx | UK001S | 2024-10-12T12:15:06.962Z | 2024-10-19T12:27:39.314Z |
5276861 | 5276861 | 20241011051346_YGi2U | UK001S | 2024-10-12T12:01:56.934Z | 2024-10-20T12:23:14.456Z |
5276593 | 5276593 | 20241011045120_JCkF9 | UK001S | 2024-10-12T12:01:24.070Z | 2024-10-20T12:23:11.953Z |
5276560 | 5276560 | 20241011045036_tu5en | UK001S | 2024-10-12T12:01:22.019Z | 2024-10-20T12:23:11.581Z |
5276480 | 5276480 | 20241011044339_MODZ2 | UK001S | 2024-10-12T12:01:14.748Z | 2024-10-20T12:23:10.012Z |
5276464 | 5276464 | 20241011044233_w2oHK | UK001S | 2024-10-12T12:01:13.989Z | 2024-10-20T12:23:09.977Z |
5276409 | 5276409 | 20241011043929_sHHDS | UK001S | 2024-10-12T12:01:04.022Z | 2024-10-20T12:23:09.304Z |
5276352 | 5276352 | 20241011043438_OWGzQ | UK001S | 2024-10-12T12:00:56.201Z | 2024-10-20T12:23:08.256Z |
5276285 | 5276285 | 20241011042935_gbk3P | UK001S | 2024-10-12T12:00:49.558Z | 2024-10-20T12:23:07.616Z |
5275985 | 5275985 | 20241011040914_AkCe1 | UK001S | 2024-10-12T12:00:09.412Z | 2024-10-20T12:23:03.669Z |
5263409 | 5263409 | 20241009042715_PItF1 | UK001S | 2024-10-10T12:00:53.296Z | 2024-10-18T12:21:34.182Z |
5263395 | 5263395 | 20241009042423_3Hu1B | UK001S | 2024-10-10T12:00:50.527Z | 2024-10-18T12:21:34.060Z |
5263360 | 5263360 | 20241009041810_0vshJ | UK001S | 2024-10-10T12:00:43.802Z | 2024-10-18T12:21:33.738Z |
5247595 | 5247595 | 20241005021615_IfKWJ | UK001S | 2024-10-07T12:18:56.781Z | 2024-10-13T12:26:26.481Z |
5247541 | 5247541 | 20241005021248_j2ETq | UK001S | 2024-10-07T12:18:56.232Z | 2024-10-13T12:26:26.452Z |
5240023 | 5240023 | 20241005045612_YIDv8 | UK001S | 2024-10-07T12:07:36.673Z | 2024-10-14T12:24:21.125Z |
5240012 | 5240012 | 20241005045423_dxZjZ | UK001S | 2024-10-07T12:07:35.736Z | 2024-10-14T12:24:21.103Z |
5239952 | 5239952 | 20241005044402_WaiXh | UK001S | 2024-10-07T12:07:25.013Z | 2024-10-14T12:24:21.010Z |
5239809 | 5239809 | 20241005042912_EhW0e | UK001S | 2024-10-07T12:07:09.971Z | 2024-10-14T12:24:20.779Z |
5239678 | 5239678 | 20241005042145_NZwrq | UK001S | 2024-10-07T12:06:59.105Z | 2024-10-14T12:24:20.507Z |
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);