participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,538 rows where station_code = "BR000F" 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 |
---|---|---|---|---|---|
5557185 | 5557185 | 20241119042718_5UM9S | BR000F | 2024-11-20T14:12:25.854Z | 2024-11-21T14:20:49.179Z |
5557080 | 5557080 | 20241119034744_74q5U | BR000F | 2024-11-20T14:12:13.846Z | 2024-11-21T14:20:45.889Z |
5556962 | 5556962 | 20241119030745_2SCm2 | BR000F | 2024-11-20T14:11:51.166Z | 2024-11-21T14:20:42.250Z |
5556958 | 5556958 | 20241119030731_tWTv4 | BR000F | 2024-11-20T14:11:49.939Z | 2024-11-21T14:20:42.153Z |
5556660 | 5556660 | 20241119005007_Bcbk3 | BR000F | 2024-11-20T14:11:05.945Z | 2024-11-21T14:20:31.889Z |
5556603 | 5556603 | 20241118235449_tc0cx | BR000F | 2024-11-20T14:10:50.676Z | 2024-11-21T14:20:29.361Z |
5556564 | 5556564 | 20241118233305_Q2cm4 | BR000F | 2024-11-20T14:10:45.100Z | 2024-11-21T14:20:27.941Z |
5554151 | 5554151 | 20241119062956_j9kzg | BR000F | 2024-11-20T14:00:51.525Z | 2024-11-21T14:18:52.987Z |
5553997 | 5553997 | 20241119051924_R2MIS | BR000F | 2024-11-20T14:00:21.006Z | 2024-11-21T14:18:52.952Z |
5553947 | 5553947 | 20241119044600_mkdKB | BR000F | 2024-11-20T14:00:09.258Z | 2024-11-21T14:18:52.939Z |
5553786 | 5553786 | 20241118041705_Efy2p | BR000F | 2024-11-19T14:11:26.580Z | 2024-11-21T14:22:21.207Z |
5553677 | 5553677 | 20241118035214_0kJbR | BR000F | 2024-11-19T14:11:15.041Z | 2024-11-21T14:22:19.615Z |
5553478 | 5553478 | 20241118025209_tftHL | BR000F | 2024-11-19T14:10:40.742Z | 2024-11-21T14:22:15.542Z |
5553469 | 5553469 | 20241118025117_Vb7xr | BR000F | 2024-11-19T14:10:39.008Z | 2024-11-21T14:22:15.426Z |
5553460 | 5553460 | 20241118024725_nfPnV | BR000F | 2024-11-19T14:10:38.070Z | 2024-11-21T14:22:15.142Z |
5553306 | 5553306 | 20241118020118_UGcNf | BR000F | 2024-11-19T14:10:16.261Z | 2024-11-21T14:22:11.385Z |
5553285 | 5553285 | 20241118015758_ylB2s | BR000F | 2024-11-19T14:10:15.040Z | 2024-11-21T14:22:10.982Z |
5553182 | 5553182 | 20241118012521_Wl146 | BR000F | 2024-11-19T14:10:08.445Z | 2024-11-21T14:22:08.334Z |
5553100 | 5553100 | 20241118004204_7ccc1 | BR000F | 2024-11-19T14:10:03.198Z | 2024-11-21T14:22:07.157Z |
5549822 | 5549822 | 20241118070941_4tNQr | BR000F | 2024-11-19T14:00:56.396Z | 2024-11-21T14:19:01.391Z |
5549817 | 5549817 | 20241118070825_MPnW3 | BR000F | 2024-11-19T14:00:55.687Z | 2024-11-21T14:19:01.335Z |
5549811 | 5549811 | 20241118070422_gAiyl | BR000F | 2024-11-19T14:00:55.186Z | 2024-11-21T14:19:01.235Z |
5549807 | 5549807 | 20241118070401_wRry0 | BR000F | 2024-11-19T14:00:54.614Z | 2024-11-21T14:19:01.161Z |
5549805 | 5549805 | 20241118070341_jSg24 | BR000F | 2024-11-19T14:00:54.191Z | 2024-11-21T14:19:01.105Z |
5549803 | 5549803 | 20241118065704_xbcKX | BR000F | 2024-11-19T14:00:53.715Z | 2024-11-21T14:19:01.037Z |
5549801 | 5549801 | 20241118065525_WMu91 | BR000F | 2024-11-19T14:00:53.180Z | 2024-11-21T14:19:00.950Z |
5549262 | 5549262 | 20241117040428_2Qlbb | BR000F | 2024-11-18T14:11:23.003Z | 2024-11-21T14:23:14.906Z |
5543802 | 5543802 | 20241115033903_3xNJQ | BR000F | 2024-11-16T14:07:15.282Z | 2024-11-21T14:24:33.959Z |
5532718 | 5532718 | 20241112055412_rTd6V | BR000F | 2024-11-13T14:17:12.130Z | 2024-11-20T14:26:25.800Z |
5532462 | 5532462 | 20241112052719_DgitL | BR000F | 2024-11-13T14:16:50.871Z | 2024-11-20T14:26:23.761Z |
5532450 | 5532450 | 20241112052448_gWRf6 | BR000F | 2024-11-13T14:16:49.597Z | 2024-11-20T14:26:23.506Z |
5532353 | 5532353 | 20241112051207_wixIP | BR000F | 2024-11-13T14:16:38.783Z | 2024-11-20T14:26:22.148Z |
5532348 | 5532348 | 20241112050956_tzrEC | BR000F | 2024-11-13T14:16:38.485Z | 2024-11-20T14:26:22.135Z |
5532132 | 5532132 | 20241112043940_F3EPw | BR000F | 2024-11-13T14:16:20.952Z | 2024-11-20T14:26:20.115Z |
5531298 | 5531298 | 20241112032939_TDNJ2 | BR000F | 2024-11-13T14:15:33.276Z | 2024-11-20T14:26:10.003Z |
5531217 | 5531217 | 20241112032258_l0Ef3 | BR000F | 2024-11-13T14:15:25.824Z | 2024-11-20T14:26:08.602Z |
5530183 | 5530183 | 20241112015431_1g2nM | BR000F | 2024-11-13T14:14:00.658Z | 2024-11-20T14:25:55.354Z |
5529688 | 5529688 | 20241112005419_Ih3nz | BR000F | 2024-11-13T14:13:06.188Z | 2024-11-20T14:25:47.438Z |
5528968 | 5528968 | 20241111231311_bvMwC | BR000F | 2024-11-13T14:11:49.289Z | 2024-11-20T14:25:37.933Z |
5528818 | 5528818 | 20241111224556_88GFY | BR000F | 2024-11-13T14:11:28.287Z | 2024-11-20T14:25:36.206Z |
5525937 | 5525937 | 20241112072422_SvHl1 | BR000F | 2024-11-13T14:01:16.138Z | 2024-11-21T14:25:29.137Z |
5525787 | 5525787 | 20241112064312_juCya | BR000F | 2024-11-13T14:00:45.486Z | 2024-11-21T14:25:26.675Z |
5525747 | 5525747 | 20241112062247_EnlOg | BR000F | 2024-11-13T14:00:37.912Z | 2024-11-21T14:25:26.196Z |
5525736 | 5525736 | 20241112062024_DdAJS | BR000F | 2024-11-13T14:00:33.999Z | 2024-11-21T14:25:26.091Z |
5525734 | 5525734 | 20241112061905_wYfjI | BR000F | 2024-11-13T14:00:33.243Z | 2024-11-21T14:25:26.028Z |
5525682 | 5525682 | 20241112060640_HlCj2 | BR000F | 2024-11-13T14:00:20.112Z | 2024-11-21T14:25:24.999Z |
5524835 | 5524835 | 20241111055919_vK0bQ | BR000F | 2024-11-12T14:18:02.892Z | 2024-11-19T14:22:24.273Z |
5524785 | 5524785 | 20241111054255_fix2w | BR000F | 2024-11-12T14:18:01.123Z | 2024-11-19T14:22:23.967Z |
5524764 | 5524764 | 20241111053444_1PylX | BR000F | 2024-11-12T14:18:00.279Z | 2024-11-19T14:22:23.868Z |
5524725 | 5524725 | 20241111052005_m333B | BR000F | 2024-11-12T14:17:58.069Z | 2024-11-19T14:22:23.542Z |
5524626 | 5524626 | 20241111044742_9a6Sw | BR000F | 2024-11-12T14:17:46.962Z | 2024-11-19T14:22:23.010Z |
5524573 | 5524573 | 20241111043822_QFLog | BR000F | 2024-11-12T14:17:42.193Z | 2024-11-19T14:22:22.455Z |
5524443 | 5524443 | 20241111041437_oGcMg | BR000F | 2024-11-12T14:17:22.074Z | 2024-11-19T14:22:21.394Z |
5524425 | 5524425 | 20241111041043_pm0ew | BR000F | 2024-11-12T14:17:20.340Z | 2024-11-19T14:22:21.238Z |
5524365 | 5524365 | 20241111040105_Az0af | BR000F | 2024-11-12T14:17:09.949Z | 2024-11-19T14:22:20.766Z |
5524258 | 5524258 | 20241111034148_RHpk7 | BR000F | 2024-11-12T14:16:51.990Z | 2024-11-19T14:22:19.224Z |
5524219 | 5524219 | 20241111033510_d0Bhp | BR000F | 2024-11-12T14:16:47.979Z | 2024-11-19T14:22:18.887Z |
5523804 | 5523804 | 20241111022610_t9PS2 | BR000F | 2024-11-12T14:16:14.126Z | 2024-11-19T14:22:15.119Z |
5523496 | 5523496 | 20241111013525_vQYjg | BR000F | 2024-11-12T14:15:49.204Z | 2024-11-19T14:22:12.994Z |
5523005 | 5523005 | 20241110233250_gknY1 | BR000F | 2024-11-12T14:14:37.688Z | 2024-11-19T14:22:09.484Z |
5518405 | 5518405 | 20241111072958_slWSq | BR000F | 2024-11-12T14:00:51.603Z | 2024-11-20T14:24:33.611Z |
5518403 | 5518403 | 20241111072843_kTxFs | BR000F | 2024-11-12T14:00:51.322Z | 2024-11-20T14:24:33.587Z |
5518345 | 5518345 | 20241111071219_oypXH | BR000F | 2024-11-12T14:00:40.633Z | 2024-11-20T14:24:32.414Z |
5518335 | 5518335 | 20241111071032_dOlYQ | BR000F | 2024-11-12T14:00:39.041Z | 2024-11-20T14:24:32.289Z |
5518328 | 5518328 | 20241111070944_MgPht | BR000F | 2024-11-12T14:00:36.084Z | 2024-11-20T14:24:32.232Z |
5518326 | 5518326 | 20241111070640_ZgQtC | BR000F | 2024-11-12T14:00:35.504Z | 2024-11-20T14:24:32.231Z |
5518251 | 5518251 | 20241111063750_mSA3X | BR000F | 2024-11-12T14:00:22.148Z | 2024-11-20T14:24:30.786Z |
5518230 | 5518230 | 20241111062456_1nMH7 | BR000F | 2024-11-12T14:00:19.113Z | 2024-11-20T14:24:30.338Z |
5518202 | 5518202 | 20241111061127_apYmK | BR000F | 2024-11-12T14:00:12.922Z | 2024-11-20T14:24:29.553Z |
5517847 | 5517847 | 20241110050125_CNsaO | BR000F | 2024-11-11T14:14:56.139Z | 2024-11-18T14:26:38.590Z |
5453039 | 5453039 | 20241031002746_mi6vm | BR000F | 2024-11-02T12:22:18.513Z | 2024-11-08T14:23:13.178Z |
5453037 | 5453037 | 20241031001413_ogSRN | BR000F | 2024-11-02T12:22:15.922Z | 2024-11-08T14:23:12.189Z |
5452964 | 5452964 | 20241101055802_0q19L | BR000F | 2024-11-02T12:19:38.600Z | 2024-11-09T14:24:37.253Z |
5452940 | 5452940 | 20241101053636_gd4YC | BR000F | 2024-11-02T12:19:35.454Z | 2024-11-09T14:24:36.791Z |
5452934 | 5452934 | 20241101053451_OY0cJ | BR000F | 2024-11-02T12:19:34.984Z | 2024-11-09T14:24:36.434Z |
5443502 | 5443502 | 20241030064424_f6Baj | BR000F | 2024-11-01T12:20:32.488Z | 2024-11-07T14:26:51.838Z |
5443073 | 5443073 | 20241030032906_qnit0 | BR000F | 2024-11-01T12:20:17.220Z | 2024-11-07T14:26:49.437Z |
5442889 | 5442889 | 20241030025227_C6oP6 | BR000F | 2024-11-01T12:20:11.980Z | 2024-11-07T14:26:48.690Z |
5433849 | 5433849 | 20241030071857_hqnT2 | BR000F | 2024-11-01T12:00:19.700Z | 2024-11-08T14:22:43.428Z |
5248493 | 5248493 | 20241007044202_42uFe | BR000F | 2024-10-08T12:02:30.357Z | 2024-10-16T12:21:00.064Z |
5246493 | 5246493 | 20241006015307_pY1Kr | BR000F | 2024-10-07T12:16:28.803Z | 2024-10-14T12:24:38.109Z |
5245172 | 5245172 | 20241005221111_8zs52 | BR000F | 2024-10-07T12:15:32.618Z | 2024-10-14T12:24:34.722Z |
5238185 | 5238185 | 20241006080320_0j9yF | BR000F | 2024-10-07T12:03:50.513Z | 2024-10-15T12:28:47.342Z |
5238164 | 5238164 | 20241006075757_PxYkt | BR000F | 2024-10-07T12:03:47.499Z | 2024-10-15T12:28:47.263Z |
5237985 | 5237985 | 20241006071327_aUuLM | BR000F | 2024-10-07T12:03:13.166Z | 2024-10-15T12:28:46.482Z |
5237403 | 5237403 | 20241006040811_HIZby | BR000F | 2024-10-07T12:01:31.444Z | 2024-10-15T12:28:41.742Z |
5206434 | 5206434 | 20241002035410_23YhV | BR000F | 2024-10-03T12:02:18.861Z | 2024-10-11T12:23:22.322Z |
5205466 | 5205466 | 20240930234923_KGSrK | BR000F | 2024-10-02T12:12:44.121Z | 2024-10-09T12:29:16.359Z |
5201604 | 5201604 | 20241001073331_KrI2H | BR000F | 2024-10-02T12:04:42.540Z | 2024-10-10T12:24:36.931Z |
5201585 | 5201585 | 20241001072534_829V1 | BR000F | 2024-10-02T12:04:40.520Z | 2024-10-10T12:24:36.815Z |
5201533 | 5201533 | 20241001071343_n9L3a | BR000F | 2024-10-02T12:04:36.528Z | 2024-10-10T12:24:36.265Z |
5201439 | 5201439 | 20241001065007_OAA9R | BR000F | 2024-10-02T12:04:27.421Z | 2024-10-10T12:24:35.591Z |
5201381 | 5201381 | 20241001063732_Cox29 | BR000F | 2024-10-02T12:04:15.711Z | 2024-10-10T12:24:35.340Z |
5201350 | 5201350 | 20241001063017_aySNP | BR000F | 2024-10-02T12:04:08.733Z | 2024-10-10T12:24:35.181Z |
5201190 | 5201190 | 20241001053510_9i7xL | BR000F | 2024-10-02T12:03:46.158Z | 2024-10-10T12:24:33.987Z |
5201134 | 5201134 | 20241001051651_lfK1d | BR000F | 2024-10-02T12:03:41.164Z | 2024-10-10T12:24:33.654Z |
5201075 | 5201075 | 20241001050239_YV1No | BR000F | 2024-10-02T12:03:35.436Z | 2024-10-10T12:24:33.539Z |
5200587 | 5200587 | 20241001033923_z8Rdi | BR000F | 2024-10-02T12:02:27.512Z | 2024-10-10T12:24:31.758Z |
5200399 | 5200399 | 20241001031700_Y5Ljr | BR000F | 2024-10-02T12:01:56.599Z | 2024-10-10T12:24:30.743Z |
5199930 | 5199930 | 20241001020013_mg2Tg | BR000F | 2024-10-02T12:00:57.173Z | 2024-10-10T12:24:29.163Z |
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);