participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
794 rows where station_code = "BR0015" 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 |
---|---|---|---|---|---|
5557081 | 5557081 | 20241119034744_74q5U | BR0015 | 2024-11-20T14:12:13.846Z | 2024-11-22T14:22:22.116Z |
5553998 | 5553998 | 20241119051924_R2MIS | BR0015 | 2024-11-20T14:00:21.006Z | 2024-11-22T14:19:26.007Z |
5553948 | 5553948 | 20241119044600_mkdKB | BR0015 | 2024-11-20T14:00:09.295Z | 2024-11-22T14:19:24.246Z |
5553787 | 5553787 | 20241118041705_Efy2p | BR0015 | 2024-11-19T14:11:26.580Z | 2024-11-22T14:22:56.189Z |
5553678 | 5553678 | 20241118035214_0kJbR | BR0015 | 2024-11-19T14:11:15.041Z | 2024-11-22T14:22:55.297Z |
5553288 | 5553288 | 20241118015758_ylB2s | BR0015 | 2024-11-19T14:10:15.048Z | 2024-11-22T14:22:51.732Z |
5553183 | 5553183 | 20241118012521_Wl146 | BR0015 | 2024-11-19T14:10:08.445Z | 2024-11-22T14:22:50.979Z |
5553101 | 5553101 | 20241118004204_7ccc1 | BR0015 | 2024-11-19T14:10:03.198Z | 2024-11-22T14:22:50.482Z |
5549818 | 5549818 | 20241118070825_MPnW3 | BR0015 | 2024-11-19T14:00:55.687Z | 2024-11-22T14:21:53.636Z |
5549812 | 5549812 | 20241118070422_gAiyl | BR0015 | 2024-11-19T14:00:55.186Z | 2024-11-22T14:21:53.535Z |
5549808 | 5549808 | 20241118070401_wRry0 | BR0015 | 2024-11-19T14:00:54.615Z | 2024-11-22T14:21:53.384Z |
5532349 | 5532349 | 20241112050956_tzrEC | BR0015 | 2024-11-13T14:16:38.485Z | 2024-11-20T14:26:22.135Z |
5531364 | 5531364 | 20241112033350_UkLiX | BR0015 | 2024-11-13T14:15:35.712Z | 2024-11-20T14:26:10.613Z |
5531218 | 5531218 | 20241112032258_l0Ef3 | BR0015 | 2024-11-13T14:15:25.824Z | 2024-11-20T14:26:08.602Z |
5530709 | 5530709 | 20241112023921_i66UC | BR0015 | 2024-11-13T14:14:29.744Z | 2024-11-20T14:26:02.714Z |
5524444 | 5524444 | 20241111041437_oGcMg | BR0015 | 2024-11-12T14:17:22.074Z | 2024-11-19T14:22:21.394Z |
5524426 | 5524426 | 20241111041043_pm0ew | BR0015 | 2024-11-12T14:17:20.341Z | 2024-11-19T14:22:21.238Z |
5524259 | 5524259 | 20241111034148_RHpk7 | BR0015 | 2024-11-12T14:16:51.991Z | 2024-11-19T14:22:19.224Z |
5524220 | 5524220 | 20241111033510_d0Bhp | BR0015 | 2024-11-12T14:16:47.979Z | 2024-11-19T14:22:18.887Z |
5523006 | 5523006 | 20241110233250_gknY1 | BR0015 | 2024-11-12T14:14:37.688Z | 2024-11-19T14:22:09.484Z |
5443503 | 5443503 | 20241030064424_f6Baj | BR0015 | 2024-11-01T12:20:32.488Z | 2024-11-07T14:26:51.838Z |
5431581 | 5431581 | 20241029013506_ADuR8 | BR0015 | 2024-10-31T12:20:22.831Z | 2024-11-06T14:27:24.103Z |
5095329 | 5095329 | 20240912071520_8enZP | BR0015 | 2024-09-16T12:15:32.755Z | 2024-09-20T12:21:59.299Z |
4990832 | 4990832 | 20240901011715_PU7lX | BR0015 | 2024-09-07T12:11:11.918Z | 2024-09-09T12:26:47.469Z |
4990634 | 4990634 | 20240901004758_BHuWw | BR0015 | 2024-09-07T12:10:51.557Z | 2024-09-09T12:26:25.681Z |
4938305 | 4938305 | 20240810221634_DdUmc | BR0015 | 2024-09-01T12:09:03.553Z | 2024-09-06T12:22:49.983Z |
4847706 | 4847706 | 20240805052420_9r8L2 | BR0015 | 2024-08-16T12:21:07.220Z | 2024-08-17T12:33:11.954Z |
4847701 | 4847701 | 20240805052230_VSkYL | BR0015 | 2024-08-16T12:21:06.918Z | 2024-08-17T12:33:11.631Z |
4837907 | 4837907 | 20240805080548_ZIEDc | BR0015 | 2024-08-16T12:01:31.752Z | 2024-08-19T12:15:28.373Z |
4837532 | 4837532 | 20240805071954_8ASFv | BR0015 | 2024-08-16T12:00:57.652Z | 2024-08-19T12:15:15.061Z |
4837172 | 4837172 | 20240805063612_rC0Tq | BR0015 | 2024-08-16T12:00:15.061Z | 2024-08-19T12:14:43.250Z |
4833939 | 4833939 | 20240805003710_MMFem | BR0015 | 2024-08-15T12:14:16.322Z | 2024-08-17T12:31:46.858Z |
4831747 | 4831747 | 20240804225513_KHC4m | BR0015 | 2024-08-15T12:12:05.853Z | 2024-08-17T12:30:40.463Z |
4830821 | 4830821 | 20240804220100_DdRIi | BR0015 | 2024-08-15T12:11:00.009Z | 2024-08-17T12:30:04.119Z |
4805522 | 4805522 | 20240803002214_XyCxG | BR0015 | 2024-08-12T12:17:54.956Z | 2024-08-13T12:17:17.123Z |
4797296 | 4797296 | 20240802031752_RsSX8 | BR0015 | 2024-08-11T12:16:23.965Z | 2024-08-11T12:16:23.965Z |
4797278 | 4797278 | 20240802031512_sv3dv | BR0015 | 2024-08-11T12:16:23.727Z | 2024-08-11T12:16:23.727Z |
4797276 | 4797276 | 20240802031459_Lygjh | BR0015 | 2024-08-11T12:16:23.649Z | 2024-08-11T12:16:23.649Z |
4797048 | 4797048 | 20240802024845_UccCc | BR0015 | 2024-08-11T12:16:16.958Z | 2024-08-11T12:16:16.958Z |
4796055 | 4796055 | 20240802015351_uKyBS | BR0015 | 2024-08-11T12:15:56.030Z | 2024-08-11T12:15:56.030Z |
4787438 | 4787438 | 20240802064529_hWvP1 | BR0015 | 2024-08-11T12:02:03.643Z | 2024-08-13T12:15:31.767Z |
4787326 | 4787326 | 20240802060625_5JstC | BR0015 | 2024-08-11T12:01:39.980Z | 2024-08-13T12:15:27.592Z |
4787312 | 4787312 | 20240802060027_kuVIT | BR0015 | 2024-08-11T12:01:36.758Z | 2024-08-13T12:15:25.786Z |
4787117 | 4787117 | 20240802044717_k8SxE | BR0015 | 2024-08-11T12:00:56.358Z | 2024-08-13T12:15:18.567Z |
4778302 | 4778302 | 20240731223752_3oYB8 | BR0015 | 2024-08-07T12:13:40.668Z | 2024-08-10T12:21:03.555Z |
4734265 | 4734265 | 20240729014347_vnnoZ | BR0015 | 2024-08-01T12:04:21.772Z | 2024-08-06T12:14:49.727Z |
4723254 | 4723254 | 20240728083912_ID27g | BR0015 | 2024-07-31T12:09:14.460Z | 2024-08-05T12:20:12.677Z |
4723094 | 4723094 | 20240728082342_JBGBl | BR0015 | 2024-07-31T12:09:07.944Z | 2024-08-05T12:20:11.225Z |
4723021 | 4723021 | 20240728081400_RS8Sx | BR0015 | 2024-07-31T12:09:04.832Z | 2024-08-05T12:20:10.800Z |
4722335 | 4722335 | 20240728065101_EAwZh | BR0015 | 2024-07-31T12:08:13.108Z | 2024-08-05T12:20:05.368Z |
4722146 | 4722146 | 20240728062542_uaxGm | BR0015 | 2024-07-31T12:07:50.835Z | 2024-08-05T12:20:03.522Z |
4722143 | 4722143 | 20240728062528_IkltE | BR0015 | 2024-07-31T12:07:50.325Z | 2024-08-05T12:20:03.521Z |
4721827 | 4721827 | 20240728051627_PM7aX | BR0015 | 2024-07-31T12:07:17.768Z | 2024-08-05T12:20:02.077Z |
4721555 | 4721555 | 20240728035814_mbjNk | BR0015 | 2024-07-31T12:06:50.140Z | 2024-08-05T12:19:58.527Z |
4717828 | 4717828 | 20240728021603_fJI4p | BR0015 | 2024-07-30T12:08:55.096Z | 2024-08-05T12:19:53.713Z |
4716442 | 4716442 | 20240728013924_flUF1 | BR0015 | 2024-07-30T12:07:40.515Z | 2024-08-05T12:19:48.488Z |
4716238 | 4716238 | 20240728013309_0CGhp | BR0015 | 2024-07-30T12:07:19.017Z | 2024-08-05T12:19:47.311Z |
4714180 | 4714180 | 20240728002904_6tNwO | BR0015 | 2024-07-30T12:04:41.133Z | 2024-08-05T12:19:39.243Z |
4692064 | 4692064 | 20240726071228_rqSq5 | BR0015 | 2024-07-27T12:06:58.340Z | 2024-08-03T12:21:30.106Z |
4691878 | 4691878 | 20240726041124_p9jgn | BR0015 | 2024-07-27T12:06:34.896Z | 2024-08-03T12:21:26.677Z |
4691866 | 4691866 | 20240726040338_vHbwi | BR0015 | 2024-07-27T12:06:31.183Z | 2024-08-03T12:21:26.410Z |
4691811 | 4691811 | 20240726031306_XLUwK | BR0015 | 2024-07-27T12:06:14.250Z | 2024-08-03T12:21:24.818Z |
4691655 | 4691655 | 20240726022316_k557O | BR0015 | 2024-07-27T12:05:57.125Z | 2024-08-03T12:21:22.908Z |
4690837 | 4690837 | 20240726003750_vB0iw | BR0015 | 2024-07-27T12:04:12.576Z | 2024-08-03T12:21:13.553Z |
4690474 | 4690474 | 20240725235402_K5X3h | BR0015 | 2024-07-27T12:03:20.373Z | 2024-08-03T12:21:10.153Z |
4690064 | 4690064 | 20240725230814_AbYS8 | BR0015 | 2024-07-27T12:02:25.558Z | 2024-08-03T12:21:07.015Z |
4685249 | 4685249 | 20240725083735_99gDx | BR0015 | 2024-07-26T12:05:16.464Z | 2024-08-02T12:24:39.616Z |
4684921 | 4684921 | 20240725071740_qBbbP | BR0015 | 2024-07-26T12:04:41.258Z | 2024-08-02T12:24:34.047Z |
4684724 | 4684724 | 20240725060907_wka2t | BR0015 | 2024-07-26T12:04:15.170Z | 2024-08-02T12:24:28.960Z |
4684671 | 4684671 | 20240725045830_SqdDO | BR0015 | 2024-07-26T12:04:01.786Z | 2024-08-02T12:24:27.697Z |
4684640 | 4684640 | 20240725040933_86PR7 | BR0015 | 2024-07-26T12:03:56.301Z | 2024-08-02T12:24:26.508Z |
4684230 | 4684230 | 20240725004613_9frDE | BR0015 | 2024-07-26T12:02:46.561Z | 2024-08-02T12:24:11.516Z |
4684029 | 4684029 | 20240724234412_z3ITx | BR0015 | 2024-07-26T12:02:03.495Z | 2024-08-02T12:24:03.811Z |
4683922 | 4683922 | 20240724225106_NtAbW | BR0015 | 2024-07-26T12:01:33.596Z | 2024-08-02T12:24:00.559Z |
4681207 | 4681207 | 20240724053401_IZPpi | BR0015 | 2024-07-25T12:03:44.298Z | 2024-08-01T12:12:03.877Z |
4681178 | 4681178 | 20240724051524_2i3FE | BR0015 | 2024-07-25T12:03:40.423Z | 2024-08-01T12:12:03.762Z |
4681111 | 4681111 | 20240724034411_kKJMj | BR0015 | 2024-07-25T12:03:21.781Z | 2024-08-01T12:12:03.470Z |
4681100 | 4681100 | 20240724032958_ZvWvC | BR0015 | 2024-07-25T12:03:20.217Z | 2024-08-01T12:12:03.406Z |
4681085 | 4681085 | 20240724025450_mZv62 | BR0015 | 2024-07-25T12:03:16.873Z | 2024-08-01T12:12:03.352Z |
4681065 | 4681065 | 20240724023330_IQTbk | BR0015 | 2024-07-25T12:03:11.119Z | 2024-08-01T12:12:03.282Z |
4680909 | 4680909 | 20240724011548_bbrSD | BR0015 | 2024-07-25T12:02:57.961Z | 2024-08-01T12:12:02.913Z |
4680841 | 4680841 | 20240724005102_ROrb2 | BR0015 | 2024-07-25T12:02:51.800Z | 2024-08-01T12:12:02.684Z |
4680825 | 4680825 | 20240724004243_3OUvT | BR0015 | 2024-07-25T12:02:51.223Z | 2024-08-01T12:12:02.564Z |
4680753 | 4680753 | 20240724001255_zDvBS | BR0015 | 2024-07-25T12:02:46.415Z | 2024-08-01T12:12:02.391Z |
4680700 | 4680700 | 20240723235121_fO8cG | BR0015 | 2024-07-25T12:02:41.692Z | 2024-08-01T12:12:02.305Z |
4680661 | 4680661 | 20240723233339_SCtvl | BR0015 | 2024-07-25T12:02:34.575Z | 2024-08-01T12:12:02.238Z |
4680444 | 4680444 | 20240723220814_Ght2D | BR0015 | 2024-07-25T12:02:03.789Z | 2024-08-01T12:12:01.851Z |
4678038 | 4678038 | 20240723033624_G9jdy | BR0015 | 2024-07-24T12:02:49.083Z | 2024-07-31T12:17:57.190Z |
4678023 | 4678023 | 20240723030721_mCgv8 | BR0015 | 2024-07-24T12:02:47.035Z | 2024-07-31T12:17:56.868Z |
4678021 | 4678021 | 20240723030558_sUfdO | BR0015 | 2024-07-24T12:02:46.797Z | 2024-07-31T12:17:56.810Z |
4678016 | 4678016 | 20240723025919_v4jhA | BR0015 | 2024-07-24T12:02:46.110Z | 2024-07-31T12:17:56.792Z |
4678005 | 4678005 | 20240723024651_C2bsf | BR0015 | 2024-07-24T12:02:44.352Z | 2024-07-31T12:17:56.695Z |
4677972 | 4677972 | 20240723021239_zXXXf | BR0015 | 2024-07-24T12:02:39.471Z | 2024-07-31T12:17:56.248Z |
4677966 | 4677966 | 20240723020824_nnhG0 | BR0015 | 2024-07-24T12:02:38.939Z | 2024-07-31T12:17:56.247Z |
4677916 | 4677916 | 20240723013725_4zRg4 | BR0015 | 2024-07-24T12:02:32.057Z | 2024-07-31T12:17:55.722Z |
4677909 | 4677909 | 20240723013341_R5sVP | BR0015 | 2024-07-24T12:02:31.086Z | 2024-07-31T12:17:55.685Z |
4677606 | 4677606 | 20240722231542_Rb2K1 | BR0015 | 2024-07-24T12:01:32.992Z | 2024-07-31T12:17:52.571Z |
4677552 | 4677552 | 20240722225257_KGxqY | BR0015 | 2024-07-24T12:01:19.918Z | 2024-07-31T12:17:52.244Z |
4672974 | 4672974 | 20240720045354_syWIF | BR0015 | 2024-07-21T12:04:41.443Z | 2024-07-28T12:14:58.055Z |
4672913 | 4672913 | 20240720033621_W3Sq7 | BR0015 | 2024-07-21T12:04:33.162Z | 2024-07-28T12:14:57.713Z |
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);