participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
242 rows where station_code = "FR0015" 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 |
---|---|---|---|---|---|
5128425 | 5128425 | 20240917014141_IQuYX | FR0015 | 2024-09-19T12:10:34.431Z | 2024-09-19T12:10:34.431Z |
5125471 | 5125471 | 20240918024222_N0SBA | FR0015 | 2024-09-19T12:03:19.264Z | 2024-09-19T12:06:42.038Z |
5120875 | 5120875 | 20240914033908_dn0TO | FR0015 | 2024-09-18T12:10:48.326Z | 2024-09-19T12:20:00.990Z |
5120367 | 5120367 | 20240914031805_ygy9k | FR0015 | 2024-09-18T12:10:38.524Z | 2024-09-19T12:20:00.069Z |
5120350 | 5120350 | 20240914031647_ebDCw | FR0015 | 2024-09-18T12:10:37.902Z | 2024-09-19T12:19:59.960Z |
5119999 | 5119999 | 20240914025613_NKcHL | FR0015 | 2024-09-18T12:10:30.981Z | 2024-09-19T12:19:59.298Z |
5119657 | 5119657 | 20240914024301_WDNph | FR0015 | 2024-09-18T12:10:23.272Z | 2024-09-19T12:19:58.667Z |
5116681 | 5116681 | 20240915033617_t2WnM | FR0015 | 2024-09-18T12:07:16.419Z | 2024-09-19T12:19:12.011Z |
5115119 | 5115119 | 20240915022110_a7Esi | FR0015 | 2024-09-18T12:06:01.000Z | 2024-09-19T12:19:01.688Z |
5114807 | 5114807 | 20240915020000_wvB83 | FR0015 | 2024-09-18T12:05:35.335Z | 2024-09-19T12:19:00.045Z |
5114135 | 5114135 | 20240915012809_Zeb33 | FR0015 | 2024-09-18T12:05:03.429Z | 2024-09-19T12:18:56.217Z |
5114015 | 5114015 | 20240915012300_9lgcl | FR0015 | 2024-09-18T12:04:58.355Z | 2024-09-19T12:18:55.269Z |
5113666 | 5113666 | 20240915010441_jNcrg | FR0015 | 2024-09-18T12:04:38.013Z | 2024-09-19T12:18:50.935Z |
5113575 | 5113575 | 20240915005852_RNtrB | FR0015 | 2024-09-18T12:04:32.003Z | 2024-09-19T12:18:50.432Z |
5113473 | 5113473 | 20240915005143_C0H5r | FR0015 | 2024-09-18T12:04:22.132Z | 2024-09-19T12:18:49.501Z |
5113370 | 5113370 | 20240915004059_gJe92 | FR0015 | 2024-09-18T12:04:10.373Z | 2024-09-19T12:18:48.638Z |
5112518 | 5112518 | 20240914232450_1254s | FR0015 | 2024-09-18T12:03:11.495Z | 2024-09-19T12:18:41.237Z |
5112481 | 5112481 | 20240914232005_tS8Dk | FR0015 | 2024-09-18T12:03:09.989Z | 2024-09-19T12:18:41.137Z |
5110852 | 5110852 | 20240914191250_W3qZH | FR0015 | 2024-09-18T12:01:05.552Z | 2024-09-19T12:18:24.259Z |
5110837 | 5110837 | 20240914190227_4zvH5 | FR0015 | 2024-09-18T12:01:03.818Z | 2024-09-19T12:18:24.144Z |
5105934 | 5105934 | 20240913030319_p2THx | FR0015 | 2024-09-17T12:12:33.462Z | 2024-09-19T12:20:45.058Z |
5105771 | 5105771 | 20240913025726_16u4x | FR0015 | 2024-09-17T12:12:28.743Z | 2024-09-19T12:20:44.873Z |
5105543 | 5105543 | 20240913025106_lwO8F | FR0015 | 2024-09-17T12:12:20.726Z | 2024-09-19T12:20:44.652Z |
5105104 | 5105104 | 20240913023041_WI3xA | FR0015 | 2024-09-17T12:11:54.702Z | 2024-09-19T12:20:43.511Z |
5105018 | 5105018 | 20240913022721_yiFq6 | FR0015 | 2024-09-17T12:11:50.027Z | 2024-09-19T12:20:43.418Z |
5104147 | 5104147 | 20240913015518_4ZPou | FR0015 | 2024-09-17T12:11:27.201Z | 2024-09-19T12:20:41.146Z |
5104089 | 5104089 | 20240913015052_hiGrm | FR0015 | 2024-09-17T12:11:24.460Z | 2024-09-19T12:20:40.960Z |
5103596 | 5103596 | 20240913013343_0933s | FR0015 | 2024-09-17T12:11:05.050Z | 2024-09-19T12:20:40.360Z |
5103489 | 5103489 | 20240913013131_NoK0e | FR0015 | 2024-09-17T12:10:59.999Z | 2024-09-19T12:20:40.222Z |
5103344 | 5103344 | 20240913012805_I3V2N | FR0015 | 2024-09-17T12:10:54.112Z | 2024-09-19T12:20:40.089Z |
5102891 | 5102891 | 20240914015153_MJM8w | FR0015 | 2024-09-17T12:07:41.909Z | 2024-09-19T12:19:56.050Z |
5102455 | 5102455 | 20240914012646_jPIK5 | FR0015 | 2024-09-17T12:07:13.398Z | 2024-09-19T12:19:54.480Z |
5100138 | 5100138 | 20240913225530_TATbF | FR0015 | 2024-09-17T12:04:01.244Z | 2024-09-19T12:19:46.970Z |
5099755 | 5099755 | 20240913215345_UncOl | FR0015 | 2024-09-17T12:03:32.292Z | 2024-09-19T12:19:45.801Z |
5099665 | 5099665 | 20240913214632_omTm0 | FR0015 | 2024-09-17T12:03:19.961Z | 2024-09-19T12:19:45.601Z |
5099435 | 5099435 | 20240913211427_mdNbq | FR0015 | 2024-09-17T12:02:56.955Z | 2024-09-19T12:19:44.905Z |
5099243 | 5099243 | 20240913204343_41NqP | FR0015 | 2024-09-17T12:02:33.696Z | 2024-09-19T12:19:44.222Z |
5099054 | 5099054 | 20240913201615_saO2R | FR0015 | 2024-09-17T12:02:14.958Z | 2024-09-19T12:19:43.219Z |
5097171 | 5097171 | 20240913003453_5FnCH | FR0015 | 2024-09-16T12:17:06.902Z | 2024-09-19T12:20:37.803Z |
5094110 | 5094110 | 20240912034852_x8hyQ | FR0015 | 2024-09-16T12:14:34.995Z | 2024-09-19T12:21:15.890Z |
5093712 | 5093712 | 20240912033322_rgOkc | FR0015 | 2024-09-16T12:14:24.453Z | 2024-09-19T12:21:15.613Z |
5093660 | 5093660 | 20240912033202_ay3gp | FR0015 | 2024-09-16T12:14:23.592Z | 2024-09-19T12:21:15.580Z |
5092941 | 5092941 | 20240912030210_3Hm15 | FR0015 | 2024-09-16T12:14:07.608Z | 2024-09-19T12:21:14.725Z |
5092794 | 5092794 | 20240912025753_R9p66 | FR0015 | 2024-09-16T12:14:04.361Z | 2024-09-19T12:21:14.553Z |
5092663 | 5092663 | 20240912025405_3d1qD | FR0015 | 2024-09-16T12:14:01.494Z | 2024-09-19T12:21:14.390Z |
5091414 | 5091414 | 20240912020815_wBVU4 | FR0015 | 2024-09-16T12:13:05.375Z | 2024-09-19T12:21:13.000Z |
5090886 | 5090886 | 20240912014959_PlfBO | FR0015 | 2024-09-16T12:12:40.505Z | 2024-09-19T12:21:12.277Z |
5090156 | 5090156 | 20240912011323_lIwno | FR0015 | 2024-09-16T12:12:05.203Z | 2024-09-19T12:21:11.041Z |
5090149 | 5090149 | 20240912011238_SD57S | FR0015 | 2024-09-16T12:12:03.252Z | 2024-09-19T12:21:11.033Z |
5087481 | 5087481 | 20240912232915_rRyM7 | FR0015 | 2024-09-16T12:06:58.866Z | 2024-09-19T12:20:35.203Z |
5085694 | 5085694 | 20240912214407_trsu1 | FR0015 | 2024-09-16T12:04:41.724Z | 2024-09-19T12:20:29.463Z |
5085628 | 5085628 | 20240912213550_Jknj8 | FR0015 | 2024-09-16T12:04:31.705Z | 2024-09-19T12:20:29.280Z |
5085194 | 5085194 | 20240912205639_qlNlQ | FR0015 | 2024-09-16T12:03:41.573Z | 2024-09-19T12:20:28.209Z |
5084681 | 5084681 | 20240912200418_0B9FV | FR0015 | 2024-09-16T12:02:46.528Z | 2024-09-19T12:20:26.903Z |
5073986 | 5073986 | 20240911220144_V7arc | FR0015 | 2024-09-15T12:07:49.016Z | 2024-09-19T12:21:06.779Z |
5073303 | 5073303 | 20240911211405_65Nny | FR0015 | 2024-09-15T12:07:02.197Z | 2024-09-19T12:21:05.649Z |
5054823 | 5054823 | 20240908041200_Vg7Cr | FR0015 | 2024-09-13T12:16:56.453Z | 2024-09-16T12:21:16.940Z |
5054760 | 5054760 | 20240908035139_kBNGZ | FR0015 | 2024-09-13T12:16:55.198Z | 2024-09-16T12:21:16.797Z |
5054722 | 5054722 | 20240908034352_sC3T6 | FR0015 | 2024-09-13T12:16:53.847Z | 2024-09-16T12:21:16.667Z |
5054688 | 5054688 | 20240908033659_jb1CS | FR0015 | 2024-09-13T12:16:52.050Z | 2024-09-16T12:21:16.637Z |
5054598 | 5054598 | 20240908031727_Wk6Np | FR0015 | 2024-09-13T12:16:48.037Z | 2024-09-16T12:21:16.161Z |
5054496 | 5054496 | 20240908030118_ILB8c | FR0015 | 2024-09-13T12:16:44.524Z | 2024-09-16T12:21:15.711Z |
5054398 | 5054398 | 20240908024545_TwmjV | FR0015 | 2024-09-13T12:16:40.073Z | 2024-09-16T12:21:15.451Z |
5054082 | 5054082 | 20240908020714_rYpOa | FR0015 | 2024-09-13T12:16:29.050Z | 2024-09-16T12:21:13.890Z |
5053475 | 5053475 | 20240908004230_fqRDz | FR0015 | 2024-09-13T12:16:05.566Z | 2024-09-16T12:21:11.503Z |
5053340 | 5053340 | 20240908001408_PHV2y | FR0015 | 2024-09-13T12:15:59.375Z | 2024-09-16T12:21:10.351Z |
5052789 | 5052789 | 20240907220708_8FjKJ | FR0015 | 2024-09-13T12:15:27.219Z | 2024-09-16T12:21:07.704Z |
5001140 | 5001140 | 20240902033703_XIuYw | FR0015 | 2024-09-08T12:16:11.555Z | 2024-09-10T12:19:32.049Z |
5000839 | 5000839 | 20240902025417_BBYxj | FR0015 | 2024-09-08T12:15:53.681Z | 2024-09-10T12:19:29.939Z |
5000449 | 5000449 | 20240902021506_Y8FDE | FR0015 | 2024-09-08T12:15:24.965Z | 2024-09-10T12:19:27.208Z |
5000409 | 5000409 | 20240902020924_rrCUl | FR0015 | 2024-09-08T12:15:23.236Z | 2024-09-10T12:19:26.893Z |
5000213 | 5000213 | 20240902014520_pA4uE | FR0015 | 2024-09-08T12:15:16.081Z | 2024-09-10T12:19:26.113Z |
4999859 | 4999859 | 20240902010407_UATl3 | FR0015 | 2024-09-08T12:14:47.662Z | 2024-09-10T12:19:23.541Z |
4999816 | 4999816 | 20240902010035_XQtCX | FR0015 | 2024-09-08T12:14:45.874Z | 2024-09-10T12:19:22.906Z |
4990749 | 4990749 | 20240901010446_bjikF | FR0015 | 2024-09-07T12:11:00.942Z | 2024-09-09T12:26:36.429Z |
4989892 | 4989892 | 20240831225337_vB7w5 | FR0015 | 2024-09-07T12:09:45.962Z | 2024-09-09T12:26:05.248Z |
4989880 | 4989880 | 20240831225128_IHn7J | FR0015 | 2024-09-07T12:09:45.238Z | 2024-09-09T12:26:03.612Z |
4989622 | 4989622 | 20240901235936_mrenI | FR0015 | 2024-09-07T12:09:13.159Z | 2024-09-10T12:19:18.165Z |
4989238 | 4989238 | 20240901225940_jhOny | FR0015 | 2024-09-07T12:08:41.105Z | 2024-09-10T12:19:17.195Z |
4988552 | 4988552 | 20240901210322_GxLZK | FR0015 | 2024-09-07T12:07:40.271Z | 2024-09-10T12:19:14.634Z |
4988024 | 4988024 | 20240901194306_oHjcd | FR0015 | 2024-09-07T12:06:44.295Z | 2024-09-10T12:19:12.289Z |
4983256 | 4983256 | 20240812004228_OD3nQ | FR0015 | 2024-09-06T12:15:22.453Z | 2024-09-06T12:15:22.453Z |
4982751 | 4982751 | 20240812003704_dQTep | FR0015 | 2024-09-06T12:15:00.604Z | 2024-09-06T12:15:00.604Z |
4981220 | 4981220 | 20240812001939_Uc1D2 | FR0015 | 2024-09-06T12:14:28.013Z | 2024-09-06T12:14:28.013Z |
4980995 | 4980995 | 20240812001810_0Mgsi | FR0015 | 2024-09-06T12:14:25.326Z | 2024-09-06T12:14:25.326Z |
4980417 | 4980417 | 20240812001203_LoysZ | FR0015 | 2024-09-06T12:13:59.358Z | 2024-09-06T12:13:59.358Z |
4980296 | 4980296 | 20240812001102_Y1q38 | FR0015 | 2024-09-06T12:13:55.374Z | 2024-09-06T12:13:55.374Z |
4979093 | 4979093 | 20240811235922_tgadw | FR0015 | 2024-09-06T12:12:57.102Z | 2024-09-06T12:12:57.102Z |
4978997 | 4978997 | 20240811235819_rq1yM | FR0015 | 2024-09-06T12:12:50.916Z | 2024-09-06T12:12:50.916Z |
4978986 | 4978986 | 20240811235803_zL1EV | FR0015 | 2024-09-06T12:12:49.078Z | 2024-09-06T12:12:49.078Z |
4978108 | 4978108 | 20240811234805_EnvL8 | FR0015 | 2024-09-06T12:12:29.689Z | 2024-09-06T12:12:29.689Z |
4977533 | 4977533 | 20240811234035_tmPrJ | FR0015 | 2024-09-06T12:12:18.919Z | 2024-09-06T12:12:18.919Z |
4977400 | 4977400 | 20240811233912_uPSCD | FR0015 | 2024-09-06T12:12:14.468Z | 2024-09-06T12:12:14.468Z |
4977308 | 4977308 | 20240811233834_za28l | FR0015 | 2024-09-06T12:12:11.652Z | 2024-09-06T12:12:11.652Z |
4976120 | 4976120 | 20240811232549_jewGq | FR0015 | 2024-09-06T12:11:12.027Z | 2024-09-06T12:11:12.027Z |
4975808 | 4975808 | 20240811232209_ThFoV | FR0015 | 2024-09-06T12:10:49.778Z | 2024-09-06T12:10:49.778Z |
4975662 | 4975662 | 20240811232054_V7HEn | FR0015 | 2024-09-06T12:10:47.006Z | 2024-09-06T12:10:47.006Z |
4975246 | 4975246 | 20240811231615_SM7fj | FR0015 | 2024-09-05T12:11:41.780Z | 2024-09-06T12:10:38.609Z |
4974981 | 4974981 | 20240811231315_RZMO6 | FR0015 | 2024-09-05T12:11:37.616Z | 2024-09-06T12:10:35.211Z |
4974638 | 4974638 | 20240811230924_xyeGm | FR0015 | 2024-09-05T12:11:28.582Z | 2024-09-06T12:10:29.810Z |
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);