participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,253 rows where station_code = "BR0013" 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 |
---|---|---|---|---|---|
5166509 | 5166509 | 20240926072049_Fngof | BR0013 | 2024-09-27T12:02:58.218Z | 2024-10-04T12:25:15.931Z |
5166356 | 5166356 | 20240926063708_sixB0 | BR0013 | 2024-09-27T12:02:32.015Z | 2024-10-04T12:25:15.401Z |
5159019 | 5159019 | 20240925070351_W96Vn | BR0013 | 2024-09-26T12:03:47.714Z | 2024-10-03T12:25:17.173Z |
5158904 | 5158904 | 20240925062541_2smJy | BR0013 | 2024-09-26T12:03:38.228Z | 2024-10-03T12:25:16.559Z |
5095589 | 5095589 | 20240912081358_BF2mv | BR0013 | 2024-09-16T12:15:49.848Z | 2024-09-20T12:22:01.784Z |
5095477 | 5095477 | 20240912074431_TBm9y | BR0013 | 2024-09-16T12:15:42.522Z | 2024-09-20T12:22:00.571Z |
5095302 | 5095302 | 20240912070220_0bzYl | BR0013 | 2024-09-16T12:15:30.827Z | 2024-09-20T12:21:59.037Z |
4992013 | 4992013 | 20240901045559_j2qta | BR0013 | 2024-09-07T12:12:48.916Z | 2024-09-09T12:27:40.593Z |
4991137 | 4991137 | 20240901020135_OxDqt | BR0013 | 2024-09-07T12:11:36.167Z | 2024-09-09T12:27:00.803Z |
4983951 | 4983951 | 20240901083323_cN6m9 | BR0013 | 2024-09-07T12:01:06.443Z | 2024-09-10T12:19:03.948Z |
4983949 | 4983949 | 20240901083158_wsIWY | BR0013 | 2024-09-07T12:01:06.100Z | 2024-09-10T12:19:03.923Z |
4983661 | 4983661 | 20240901073226_AH3G2 | BR0013 | 2024-09-07T12:00:33.993Z | 2024-09-10T12:19:02.257Z |
4957422 | 4957422 | 20240811084050_JCEFl | BR0013 | 2024-09-03T12:21:13.008Z | 2024-09-06T12:31:18.212Z |
4957352 | 4957352 | 20240811083148_RuTMZ | BR0013 | 2024-09-03T12:21:07.389Z | 2024-09-06T12:31:15.898Z |
4957243 | 4957243 | 20240811082318_CNhsV | BR0013 | 2024-09-03T12:20:58.635Z | 2024-09-06T12:31:10.322Z |
4957067 | 4957067 | 20240811081133_QYSen | BR0013 | 2024-09-03T12:20:48.456Z | 2024-09-06T12:31:00.467Z |
4955233 | 4955233 | 20240811040539_bkrBE | BR0013 | 2024-09-03T12:18:58.784Z | 2024-09-06T12:29:27.028Z |
4955207 | 4955207 | 20240811040108_lIW0j | BR0013 | 2024-09-03T12:18:56.141Z | 2024-09-06T12:29:25.921Z |
4955108 | 4955108 | 20240811034111_WBq3s | BR0013 | 2024-09-03T12:18:44.064Z | 2024-09-06T12:29:19.516Z |
4954099 | 4954099 | 20240811025212_6ub1E | BR0013 | 2024-09-03T12:18:07.613Z | 2024-09-06T12:28:50.135Z |
4905054 | 4905054 | 20240808081730_Tls76 | BR0013 | 2024-08-28T12:20:56.777Z | 2024-08-28T12:20:56.777Z |
4904266 | 4904266 | 20240808044910_nMCpw | BR0013 | 2024-08-28T12:20:13.769Z | 2024-08-28T12:20:13.769Z |
4904255 | 4904255 | 20240808044452_T6sA2 | BR0013 | 2024-08-28T12:20:13.103Z | 2024-08-28T12:20:13.103Z |
4904210 | 4904210 | 20240808043112_cxPZ7 | BR0013 | 2024-08-28T12:20:10.648Z | 2024-08-28T12:20:10.648Z |
4868488 | 4868488 | 20240806064058_TyXo9 | BR0013 | 2024-08-18T12:24:11.356Z | 2024-08-19T12:28:46.625Z |
4868036 | 4868036 | 20240806052301_4SH00 | BR0013 | 2024-08-18T12:23:57.226Z | 2024-08-19T12:28:32.688Z |
4867898 | 4867898 | 20240806043704_b5uVt | BR0013 | 2024-08-18T12:23:52.703Z | 2024-08-19T12:28:29.927Z |
4858425 | 4858425 | 20240806082432_pSWAw | BR0013 | 2024-08-18T12:00:51.209Z | 2024-08-27T12:00:58.935Z |
4857832 | 4857832 | 20240806032121_PLl5F | BR0013 | 2024-08-17T12:23:09.773Z | 2024-08-19T12:28:24.252Z |
4857610 | 4857610 | 20240806023947_XR3r4 | BR0013 | 2024-08-17T12:22:44.607Z | 2024-08-19T12:28:19.379Z |
4857136 | 4857136 | 20240806020932_2c0A4 | BR0013 | 2024-08-17T12:22:10.029Z | 2024-08-19T12:27:58.162Z |
4847730 | 4847730 | 20240805053314_k2LL1 | BR0013 | 2024-08-16T12:21:08.645Z | 2024-08-17T12:33:14.160Z |
4847549 | 4847549 | 20240805042609_ejOVb | BR0013 | 2024-08-16T12:21:00.338Z | 2024-08-17T12:33:06.133Z |
4837473 | 4837473 | 20240805071230_zZMY0 | BR0013 | 2024-08-16T12:00:52.086Z | 2024-08-19T12:15:10.246Z |
4837456 | 4837456 | 20240805071101_gVPtN | BR0013 | 2024-08-16T12:00:50.028Z | 2024-08-19T12:15:08.370Z |
4837412 | 4837412 | 20240805070702_pwCIx | BR0013 | 2024-08-16T12:00:46.359Z | 2024-08-19T12:15:05.471Z |
4837006 | 4837006 | 20240805024431_hxFnk | BR0013 | 2024-08-15T12:16:37.892Z | 2024-08-17T12:32:51.275Z |
4832658 | 4832658 | 20240804234600_WNc4u | BR0013 | 2024-08-15T12:13:08.548Z | 2024-08-17T12:31:12.241Z |
4832406 | 4832406 | 20240804233109_bZV2m | BR0013 | 2024-08-15T12:12:58.486Z | 2024-08-17T12:31:03.016Z |
4830860 | 4830860 | 20240804220501_lk02V | BR0013 | 2024-08-15T12:11:06.443Z | 2024-08-17T12:30:06.906Z |
4826517 | 4826517 | 20240804035032_sPmip | BR0013 | 2024-08-14T12:21:10.003Z | 2024-08-15T12:26:20.528Z |
4826338 | 4826338 | 20240804025003_yMvl0 | BR0013 | 2024-08-14T12:20:56.763Z | 2024-08-15T12:26:16.821Z |
4826248 | 4826248 | 20240804023151_74umD | BR0013 | 2024-08-14T12:20:52.126Z | 2024-08-15T12:26:13.491Z |
4826065 | 4826065 | 20240804020843_C86n9 | BR0013 | 2024-08-14T12:20:40.302Z | 2024-08-15T12:26:07.917Z |
4825850 | 4825850 | 20240804014720_drU6u | BR0013 | 2024-08-14T12:20:28.476Z | 2024-08-15T12:26:00.939Z |
4825661 | 4825661 | 20240804013229_S4OhP | BR0013 | 2024-08-14T12:20:17.098Z | 2024-08-15T12:25:57.120Z |
4817958 | 4817958 | 20240804080931_1P3Ck | BR0013 | 2024-08-14T12:01:37.115Z | 2024-08-17T12:24:04.999Z |
4817911 | 4817911 | 20240804080324_UegTb | BR0013 | 2024-08-14T12:01:31.343Z | 2024-08-17T12:24:00.686Z |
4817805 | 4817805 | 20240804074818_f9lNo | BR0013 | 2024-08-14T12:01:17.126Z | 2024-08-17T12:23:49.107Z |
4817574 | 4817574 | 20240804064928_BtcMk | BR0013 | 2024-08-14T12:00:39.145Z | 2024-08-17T12:23:31.571Z |
4806677 | 4806677 | 20240803024920_wQfVF | BR0013 | 2024-08-12T12:19:13.213Z | 2024-08-13T12:17:46.840Z |
4806480 | 4806480 | 20240803021521_eLjuN | BR0013 | 2024-08-12T12:18:58.695Z | 2024-08-13T12:17:42.252Z |
4806338 | 4806338 | 20240803015109_4WO62 | BR0013 | 2024-08-12T12:18:44.001Z | 2024-08-13T12:17:37.338Z |
4806300 | 4806300 | 20240803014621_yzE4H | BR0013 | 2024-08-12T12:18:41.391Z | 2024-08-13T12:17:35.770Z |
4797784 | 4797784 | 20240803072229_f7cTr | BR0013 | 2024-08-12T12:01:38.736Z | 2024-08-15T12:17:20.951Z |
4797641 | 4797641 | 20240803065626_76gDo | BR0013 | 2024-08-12T12:01:11.277Z | 2024-08-15T12:17:16.735Z |
4797601 | 4797601 | 20240803064634_DnDFS | BR0013 | 2024-08-12T12:01:04.698Z | 2024-08-15T12:17:15.345Z |
4797486 | 4797486 | 20240803060136_oATxt | BR0013 | 2024-08-12T12:00:43.445Z | 2024-08-15T12:17:11.668Z |
4797305 | 4797305 | 20240802031926_6lTox | BR0013 | 2024-08-11T12:16:24.199Z | 2024-08-11T12:16:24.199Z |
4787151 | 4787151 | 20240802045828_ZOpVi | BR0013 | 2024-08-11T12:01:01.947Z | 2024-08-13T12:15:19.755Z |
4787037 | 4787037 | 20240802041008_o8p2a | BR0013 | 2024-08-11T12:00:42.592Z | 2024-08-13T12:15:15.180Z |
4786959 | 4786959 | 20240802034446_bSEQc | BR0013 | 2024-08-11T12:00:29.291Z | 2024-08-13T12:15:12.985Z |
4786945 | 4786945 | 20240802034107_tLSVy | BR0013 | 2024-08-11T12:00:26.366Z | 2024-08-13T12:15:12.108Z |
4786903 | 4786903 | 20240802032604_9VmbX | BR0013 | 2024-08-11T12:00:15.928Z | 2024-08-13T12:15:10.421Z |
4771328 | 4771328 | 20240731010655_uOHgI | BR0013 | 2024-08-06T12:14:13.680Z | 2024-08-08T12:25:21.544Z |
4763997 | 4763997 | 20240731074349_JEF5i | BR0013 | 2024-08-06T12:05:34.671Z | 2024-08-10T12:18:36.845Z |
4763622 | 4763622 | 20240731062832_vzaOM | BR0013 | 2024-08-06T12:04:51.042Z | 2024-08-10T12:18:23.140Z |
4763529 | 4763529 | 20240731061349_4DBZR | BR0013 | 2024-08-06T12:04:42.676Z | 2024-08-10T12:18:21.369Z |
4761560 | 4761560 | 20240731012153_Ah2hR | BR0013 | 2024-08-06T12:00:37.063Z | 2024-08-10T12:17:20.737Z |
4751679 | 4751679 | 20240730075053_vHmS8 | BR0013 | 2024-08-05T12:03:48.404Z | 2024-08-08T12:19:23.599Z |
4746235 | 4746235 | 20240730030019_L2E3Y | BR0013 | 2024-08-04T12:08:15.177Z | 2024-08-08T12:18:33.603Z |
4737020 | 4737020 | 20240729072434_4KLfF | BR0013 | 2024-08-01T12:06:03.221Z | 2024-08-06T12:15:04.326Z |
4737018 | 4737018 | 20240729072428_FPInT | BR0013 | 2024-08-01T12:06:03.102Z | 2024-08-06T12:15:04.275Z |
4736983 | 4736983 | 20240729070359_BLuu9 | BR0013 | 2024-08-01T12:06:01.067Z | 2024-08-06T12:15:03.624Z |
4736808 | 4736808 | 20240729045015_KgWXf | BR0013 | 2024-08-01T12:05:49.625Z | 2024-08-06T12:14:58.498Z |
4736790 | 4736790 | 20240729042348_k7E08 | BR0013 | 2024-08-01T12:05:48.059Z | 2024-08-06T12:14:57.546Z |
4736763 | 4736763 | 20240729040419_gyijV | BR0013 | 2024-08-01T12:05:46.140Z | 2024-08-06T12:14:57.323Z |
4736712 | 4736712 | 20240729032227_Cx0UR | BR0013 | 2024-08-01T12:05:39.372Z | 2024-08-06T12:14:56.826Z |
4700271 | 4700271 | 20240727072336_EQHlJ | BR0013 | 2024-07-28T12:07:40.388Z | 2024-08-04T12:19:25.827Z |
4700203 | 4700203 | 20240727063004_v9iBO | BR0013 | 2024-07-28T12:07:36.467Z | 2024-08-04T12:19:22.346Z |
4700123 | 4700123 | 20240727053501_IYyy6 | BR0013 | 2024-07-28T12:07:31.203Z | 2024-08-04T12:19:19.777Z |
4700110 | 4700110 | 20240727052754_fllkY | BR0013 | 2024-07-28T12:07:30.410Z | 2024-08-04T12:19:19.678Z |
4700099 | 4700099 | 20240727051658_0m9i6 | BR0013 | 2024-07-28T12:07:30.093Z | 2024-08-04T12:19:19.623Z |
4700040 | 4700040 | 20240727043048_JuGSZ | BR0013 | 2024-07-28T12:07:25.750Z | 2024-08-04T12:19:18.731Z |
4692248 | 4692248 | 20240726081134_aC7eW | BR0013 | 2024-07-27T12:07:24.419Z | 2024-08-03T12:21:31.759Z |
4692013 | 4692013 | 20240726065049_DkSgf | BR0013 | 2024-07-27T12:06:50.349Z | 2024-08-03T12:21:29.111Z |
4691920 | 4691920 | 20240726052612_PgTNI | BR0013 | 2024-07-27T12:06:41.479Z | 2024-08-03T12:21:27.604Z |
4691890 | 4691890 | 20240726044524_3D7Dt | BR0013 | 2024-07-27T12:06:37.444Z | 2024-08-03T12:21:26.923Z |
4685060 | 4685060 | 20240725075720_LV5M2 | BR0013 | 2024-07-26T12:04:53.425Z | 2024-08-02T12:24:36.793Z |
4684845 | 4684845 | 20240725065450_KrtfQ | BR0013 | 2024-07-26T12:04:35.188Z | 2024-08-02T12:24:32.365Z |
4684709 | 4684709 | 20240725055034_d2H7I | BR0013 | 2024-07-26T12:04:12.032Z | 2024-08-02T12:24:28.685Z |
4684649 | 4684649 | 20240725041610_nc7FK | BR0013 | 2024-07-26T12:03:57.525Z | 2024-08-02T12:24:26.728Z |
4684584 | 4684584 | 20240725025434_F4kUm | BR0013 | 2024-07-26T12:03:48.062Z | 2024-08-02T12:24:23.457Z |
4681252 | 4681252 | 20240724061853_3jwqb | BR0013 | 2024-07-25T12:03:48.494Z | 2024-08-01T12:12:04.056Z |
4678177 | 4678177 | 20240723064543_zE5EM | BR0013 | 2024-07-24T12:03:18.042Z | 2024-07-31T12:17:58.489Z |
4676191 | 4676191 | 20240722065814_XPBMC | BR0013 | 2024-07-23T12:02:19.075Z | 2024-07-30T12:18:12.796Z |
4676107 | 4676107 | 20240722061208_nq3jT | BR0013 | 2024-07-23T12:02:11.968Z | 2024-07-30T12:18:12.185Z |
4674532 | 4674532 | 20240721073422_RlxMn | BR0013 | 2024-07-22T12:01:56.835Z | 2024-07-29T12:17:16.143Z |
4673177 | 4673177 | 20240720084737_27g2f | BR0013 | 2024-07-21T12:05:08.363Z | 2024-07-28T12:14:59.074Z |
4673051 | 4673051 | 20240720070215_jRdYD | BR0013 | 2024-07-21T12:04:52.282Z | 2024-07-28T12:14:58.441Z |
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);