participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00P" 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 |
---|---|---|---|---|---|
5318276 | 5318276 | 20241017020820_qsc5r | USL00P | 2024-10-18T12:03:17.501Z | 2024-10-25T12:24:34.387Z |
5317681 | 5317681 | 20241017082851_G51Vj | USL00P | 2024-10-18T12:00:30.208Z | 2024-10-26T12:27:50.827Z |
5317046 | 5317046 | 20241016024259_8xT70 | USL00P | 2024-10-17T12:07:41.857Z | 2024-10-24T12:27:58.684Z |
5317030 | 5317030 | 20241016023919_PaX8i | USL00P | 2024-10-17T12:07:38.676Z | 2024-10-24T12:27:58.613Z |
5315384 | 5315384 | 20241015123818_UxsPf | USL00P | 2024-10-17T12:04:34.238Z | 2024-10-24T12:27:52.721Z |
5315355 | 5315355 | 20241015122544_hTUcf | USL00P | 2024-10-17T12:04:29.136Z | 2024-10-24T12:27:52.192Z |
5315303 | 5315303 | 20241015121348_phSG9 | USL00P | 2024-10-17T12:04:24.991Z | 2024-10-24T12:27:51.892Z |
5315278 | 5315278 | 20241015121158_vowYr | USL00P | 2024-10-17T12:04:23.812Z | 2024-10-24T12:27:51.787Z |
5315202 | 5315202 | 20241015120058_DqIK2 | USL00P | 2024-10-17T12:04:18.404Z | 2024-10-24T12:27:51.076Z |
5315175 | 5315175 | 20241015115448_Mivd5 | USL00P | 2024-10-17T12:04:16.516Z | 2024-10-24T12:27:50.686Z |
5315115 | 5315115 | 20241015114517_gdhZ1 | USL00P | 2024-10-17T12:04:13.064Z | 2024-10-24T12:27:49.921Z |
5315103 | 5315103 | 20241015114442_FJeaa | USL00P | 2024-10-17T12:04:12.647Z | 2024-10-24T12:27:49.778Z |
5315016 | 5315016 | 20241015112919_yeeh0 | USL00P | 2024-10-17T12:04:06.512Z | 2024-10-24T12:27:49.092Z |
5314405 | 5314405 | 20241016124448_7ZyQY | USL00P | 2024-10-17T12:02:17.764Z | 2024-10-25T12:24:30.129Z |
5314400 | 5314400 | 20241016124348_YRTWf | USL00P | 2024-10-17T12:02:15.587Z | 2024-10-25T12:24:30.104Z |
5314397 | 5314397 | 20241016124332_6TE75 | USL00P | 2024-10-17T12:02:15.167Z | 2024-10-25T12:24:30.084Z |
5314371 | 5314371 | 20241016123353_f18dt | USL00P | 2024-10-17T12:02:12.347Z | 2024-10-25T12:24:30.026Z |
5314366 | 5314366 | 20241016123313_OlkTB | USL00P | 2024-10-17T12:02:11.948Z | 2024-10-25T12:24:30.022Z |
5314323 | 5314323 | 20241016122517_7tLml | USL00P | 2024-10-17T12:02:05.127Z | 2024-10-25T12:24:29.677Z |
5314317 | 5314317 | 20241016122316_C1wRh | USL00P | 2024-10-17T12:02:04.444Z | 2024-10-25T12:24:29.607Z |
5314270 | 5314270 | 20241016120830_hmwVy | USL00P | 2024-10-17T12:01:55.512Z | 2024-10-25T12:24:29.380Z |
5314237 | 5314237 | 20241016120358_ORIQZ | USL00P | 2024-10-17T12:01:53.367Z | 2024-10-25T12:24:29.245Z |
5314233 | 5314233 | 20241016120311_ODblK | USL00P | 2024-10-17T12:01:53.137Z | 2024-10-25T12:24:29.241Z |
5314196 | 5314196 | 20241016115725_D9nwC | USL00P | 2024-10-17T12:01:50.133Z | 2024-10-25T12:24:29.006Z |
5314186 | 5314186 | 20241016115248_1Rcc1 | USL00P | 2024-10-17T12:01:49.185Z | 2024-10-25T12:24:28.975Z |
5314102 | 5314102 | 20241016113524_22bvO | USL00P | 2024-10-17T12:01:41.862Z | 2024-10-25T12:24:28.746Z |
5314079 | 5314079 | 20241016112929_95aKL | USL00P | 2024-10-17T12:01:40.286Z | 2024-10-25T12:24:28.673Z |
5314056 | 5314056 | 20241016112338_lJ22E | USL00P | 2024-10-17T12:01:37.990Z | 2024-10-25T12:24:28.598Z |
5313993 | 5313993 | 20241016105943_ZZUIs | USL00P | 2024-10-17T12:01:32.353Z | 2024-10-25T12:24:28.297Z |
5313987 | 5313987 | 20241016105844_aCn9B | USL00P | 2024-10-17T12:01:31.707Z | 2024-10-25T12:24:28.293Z |
5313931 | 5313931 | 20241016104605_mf0KC | USL00P | 2024-10-17T12:01:20.683Z | 2024-10-25T12:24:27.919Z |
5313919 | 5313919 | 20241016104226_CBRdL | USL00P | 2024-10-17T12:01:18.678Z | 2024-10-25T12:24:27.844Z |
5313915 | 5313915 | 20241016104215_e3VcK | USL00P | 2024-10-17T12:01:17.637Z | 2024-10-25T12:24:27.819Z |
5313891 | 5313891 | 20241016103742_UxzFh | USL00P | 2024-10-17T12:01:15.412Z | 2024-10-25T12:24:27.728Z |
5313861 | 5313861 | 20241016103357_QWHx0 | USL00P | 2024-10-17T12:01:12.116Z | 2024-10-25T12:24:27.443Z |
5313837 | 5313837 | 20241016102805_FZmnM | USL00P | 2024-10-17T12:01:06.985Z | 2024-10-25T12:24:27.208Z |
5313818 | 5313818 | 20241016102127_09w2Z | USL00P | 2024-10-17T12:01:04.621Z | 2024-10-25T12:24:27.165Z |
5313759 | 5313759 | 20241016100113_89Kb2 | USL00P | 2024-10-17T12:00:58.304Z | 2024-10-25T12:24:26.962Z |
5313688 | 5313688 | 20241016093354_Bqte7 | USL00P | 2024-10-17T12:00:50.657Z | 2024-10-25T12:24:26.579Z |
5313663 | 5313663 | 20241016092654_b9Eh2 | USL00P | 2024-10-17T12:00:47.738Z | 2024-10-25T12:24:26.366Z |
5313641 | 5313641 | 20241016091540_GTask | USL00P | 2024-10-17T12:00:43.892Z | 2024-10-25T12:24:26.271Z |
5313524 | 5313524 | 20241016081833_UnlZc | USL00P | 2024-10-17T12:00:27.760Z | 2024-10-25T12:24:25.522Z |
5312721 | 5312721 | 20241015043830_Zzw2I | USL00P | 2024-10-16T12:10:56.228Z | 2024-10-23T12:24:53.000Z |
5312140 | 5312140 | 20241015024953_dne0y | USL00P | 2024-10-16T12:10:03.102Z | 2024-10-23T12:24:48.757Z |
5309517 | 5309517 | 20241014123442_2boyZ | USL00P | 2024-10-16T12:05:34.047Z | 2024-10-23T12:24:26.092Z |
5309502 | 5309502 | 20241014122834_jl78A | USL00P | 2024-10-16T12:05:33.187Z | 2024-10-23T12:24:25.986Z |
5309470 | 5309470 | 20241014122024_PK7PJ | USL00P | 2024-10-16T12:05:30.255Z | 2024-10-23T12:24:25.689Z |
5309457 | 5309457 | 20241014121935_BVAux | USL00P | 2024-10-16T12:05:29.503Z | 2024-10-23T12:24:25.493Z |
5309414 | 5309414 | 20241014121044_yIOSz | USL00P | 2024-10-16T12:05:26.737Z | 2024-10-23T12:24:25.342Z |
5309384 | 5309384 | 20241014120704_zeoFu | USL00P | 2024-10-16T12:05:22.249Z | 2024-10-23T12:24:25.195Z |
5309368 | 5309368 | 20241014120414_7ygM7 | USL00P | 2024-10-16T12:05:17.161Z | 2024-10-23T12:24:25.160Z |
5309275 | 5309275 | 20241014114940_3H7G7 | USL00P | 2024-10-16T12:05:04.664Z | 2024-10-23T12:24:24.735Z |
5309268 | 5309268 | 20241014114926_SYMWV | USL00P | 2024-10-16T12:05:04.461Z | 2024-10-23T12:24:24.715Z |
5309238 | 5309238 | 20241014114538_gArE2 | USL00P | 2024-10-16T12:05:01.712Z | 2024-10-23T12:24:24.587Z |
5309207 | 5309207 | 20241014114037_2aRNc | USL00P | 2024-10-16T12:04:59.264Z | 2024-10-23T12:24:24.097Z |
5309153 | 5309153 | 20241014113223_arkhi | USL00P | 2024-10-16T12:04:55.001Z | 2024-10-23T12:24:23.932Z |
5309138 | 5309138 | 20241014113108_1N2in | USL00P | 2024-10-16T12:04:54.292Z | 2024-10-23T12:24:23.902Z |
5309008 | 5309008 | 20241014111418_AdD7O | USL00P | 2024-10-16T12:04:43.075Z | 2024-10-23T12:24:21.991Z |
5308958 | 5308958 | 20241014110601_r3VRT | USL00P | 2024-10-16T12:04:33.824Z | 2024-10-23T12:24:21.701Z |
5308951 | 5308951 | 20241014110510_qfo6n | USL00P | 2024-10-16T12:04:32.073Z | 2024-10-23T12:24:21.605Z |
5308882 | 5308882 | 20241014105649_91Koo | USL00P | 2024-10-16T12:04:23.607Z | 2024-10-23T12:24:21.212Z |
5308822 | 5308822 | 20241014104605_MTu6x | USL00P | 2024-10-16T12:04:18.405Z | 2024-10-23T12:24:20.185Z |
5308808 | 5308808 | 20241014104450_Z35tH | USL00P | 2024-10-16T12:04:17.543Z | 2024-10-23T12:24:20.151Z |
5308789 | 5308789 | 20241014104305_2z5AC | USL00P | 2024-10-16T12:04:15.974Z | 2024-10-23T12:24:19.946Z |
5308747 | 5308747 | 20241014103623_MpUys | USL00P | 2024-10-16T12:04:12.195Z | 2024-10-23T12:24:19.438Z |
5308722 | 5308722 | 20241014103303_otQmM | USL00P | 2024-10-16T12:04:10.779Z | 2024-10-23T12:24:19.260Z |
5308718 | 5308718 | 20241014103206_2Ms3y | USL00P | 2024-10-16T12:04:10.578Z | 2024-10-23T12:24:19.256Z |
5308701 | 5308701 | 20241014103104_1mLoD | USL00P | 2024-10-16T12:04:09.353Z | 2024-10-23T12:24:19.159Z |
5308660 | 5308660 | 20241014102457_OJtFk | USL00P | 2024-10-16T12:04:06.270Z | 2024-10-23T12:24:18.893Z |
5308620 | 5308620 | 20241014101854_FZIU3 | USL00P | 2024-10-16T12:04:03.393Z | 2024-10-23T12:24:18.585Z |
5308603 | 5308603 | 20241014101631_S4VhX | USL00P | 2024-10-16T12:04:02.265Z | 2024-10-23T12:24:18.536Z |
5308585 | 5308585 | 20241014101358_9g9IR | USL00P | 2024-10-16T12:04:00.868Z | 2024-10-23T12:24:17.868Z |
5308540 | 5308540 | 20241014101035_PYQpO | USL00P | 2024-10-16T12:03:53.875Z | 2024-10-23T12:24:17.622Z |
5308524 | 5308524 | 20241014100759_3PcjO | USL00P | 2024-10-16T12:03:50.455Z | 2024-10-23T12:24:17.224Z |
5308517 | 5308517 | 20241014100747_3RtdF | USL00P | 2024-10-16T12:03:49.922Z | 2024-10-23T12:24:17.208Z |
5308513 | 5308513 | 20241014100729_Xgj2p | USL00P | 2024-10-16T12:03:49.403Z | 2024-10-23T12:24:17.009Z |
5308482 | 5308482 | 20241014095911_3tMAu | USL00P | 2024-10-16T12:03:43.060Z | 2024-10-23T12:24:16.667Z |
5308445 | 5308445 | 20241014095337_uT9ds | USL00P | 2024-10-16T12:03:40.257Z | 2024-10-23T12:24:16.464Z |
5308242 | 5308242 | 20241014090503_xQcpW | USL00P | 2024-10-16T12:03:22.052Z | 2024-10-23T12:24:14.409Z |
5308236 | 5308236 | 20241014090427_lR19v | USL00P | 2024-10-16T12:03:21.833Z | 2024-10-23T12:24:14.396Z |
5308150 | 5308150 | 20241014083602_vXxM7 | USL00P | 2024-10-16T12:03:04.812Z | 2024-10-23T12:24:13.742Z |
5308044 | 5308044 | 20241014075416_6WlqR | USL00P | 2024-10-16T12:02:54.516Z | 2024-10-23T12:24:12.409Z |
5307917 | 5307917 | 20241014061010_wnBAF | USL00P | 2024-10-16T12:02:41.047Z | 2024-10-23T12:24:10.545Z |
5307866 | 5307866 | 20241014051620_BcaJz | USL00P | 2024-10-16T12:02:27.547Z | 2024-10-23T12:24:09.088Z |
5307841 | 5307841 | 20241014050148_qy2L2 | USL00P | 2024-10-16T12:02:23.871Z | 2024-10-23T12:24:07.872Z |
5307823 | 5307823 | 20241015110945_SK1iH | USL00P | 2024-10-16T12:02:19.163Z | 2024-10-24T12:27:46.798Z |
5307820 | 5307820 | 20241015110832_FdjvW | USL00P | 2024-10-16T12:02:18.675Z | 2024-10-24T12:27:46.796Z |
5307814 | 5307814 | 20241015110820_pbSNH | USL00P | 2024-10-16T12:02:18.397Z | 2024-10-24T12:27:46.792Z |
5307756 | 5307756 | 20241015105818_8jDOt | USL00P | 2024-10-16T12:02:11.928Z | 2024-10-24T12:27:46.172Z |
5307739 | 5307739 | 20241015105549_zTjmU | USL00P | 2024-10-16T12:02:10.442Z | 2024-10-24T12:27:46.046Z |
5307714 | 5307714 | 20241015105008_Zvg67 | USL00P | 2024-10-16T12:02:08.079Z | 2024-10-24T12:27:45.815Z |
5307566 | 5307566 | 20241015102900_moGNY | USL00P | 2024-10-16T12:01:45.266Z | 2024-10-24T12:27:44.893Z |
5307550 | 5307550 | 20241015102715_eCURo | USL00P | 2024-10-16T12:01:43.557Z | 2024-10-24T12:27:44.854Z |
5307439 | 5307439 | 20241015095807_YMDtx | USL00P | 2024-10-16T12:01:31.564Z | 2024-10-24T12:27:43.554Z |
5307272 | 5307272 | 20241015091252_p3ZsC | USL00P | 2024-10-16T12:01:04.673Z | 2024-10-24T12:27:41.852Z |
5307263 | 5307263 | 20241015090952_yQkFo | USL00P | 2024-10-16T12:01:03.701Z | 2024-10-24T12:27:41.830Z |
5307210 | 5307210 | 20241015084459_axDhd | USL00P | 2024-10-16T12:00:56.695Z | 2024-10-24T12:27:41.034Z |
5307175 | 5307175 | 20241015082105_GTETA | USL00P | 2024-10-16T12:00:52.242Z | 2024-10-24T12:27:40.811Z |
5307107 | 5307107 | 20241015075652_qVLEP | USL00P | 2024-10-16T12:00:41.547Z | 2024-10-24T12:27:40.191Z |
5306954 | 5306954 | 20241015061047_M0upv | USL00P | 2024-10-16T12:00:19.315Z | 2024-10-24T12:27:37.736Z |
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);