participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
459 rows where station_code = "BR000T" 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 |
---|---|---|---|---|---|
5509483 | 5509483 | 20241108232648_OLHxd | BR000T | 2024-11-10T14:13:26.593Z | 2024-11-12T14:23:20.127Z |
5454684 | 5454684 | 20241031045511_2efgm | BR000T | 2024-11-02T12:23:16.861Z | 2024-11-08T14:23:24.761Z |
5452941 | 5452941 | 20241101053636_gd4YC | BR000T | 2024-11-02T12:19:35.454Z | 2024-11-09T14:24:36.791Z |
5452596 | 5452596 | 20241101034812_bmFDD | BR000T | 2024-11-02T12:19:04.191Z | 2024-11-09T14:24:31.889Z |
5399964 | 5399964 | 20241026051802_Uo2LE | BR000T | 2024-10-28T12:20:17.612Z | 2024-11-03T14:27:40.898Z |
5246494 | 5246494 | 20241006015307_pY1Kr | BR000T | 2024-10-07T12:16:28.803Z | 2024-10-14T12:24:38.109Z |
5240523 | 5240523 | 20241005072309_ar7gc | BR000T | 2024-10-07T12:08:37.371Z | 2024-10-14T12:24:23.484Z |
5178650 | 5178650 | 20240928030940_ygFDK | BR000T | 2024-09-29T12:06:41.767Z | 2024-10-06T12:28:00.410Z |
5175606 | 5175606 | 20240927233540_39GIN | BR000T | 2024-09-29T12:00:23.698Z | 2024-10-06T12:27:47.490Z |
4981252 | 4981252 | 20240812001954_Tnnhi | BR000T | 2024-09-06T12:14:28.733Z | 2024-09-06T12:14:28.733Z |
4956000 | 4956000 | 20240811063508_UMojs | BR000T | 2024-09-03T12:19:43.337Z | 2024-09-06T12:30:06.974Z |
4955262 | 4955262 | 20240811041455_aLn3X | BR000T | 2024-09-03T12:19:02.682Z | 2024-09-06T12:29:29.827Z |
4954054 | 4954054 | 20240811025006_oJpT4 | BR000T | 2024-09-03T12:18:06.621Z | 2024-09-06T12:28:47.706Z |
4943137 | 4943137 | 20240811000643_CGR3J | BR000T | 2024-09-02T12:11:43.033Z | 2024-09-06T12:24:39.443Z |
4930870 | 4930870 | 20240810090908_KM1J0 | BR000T | 2024-08-31T12:24:00.727Z | 2024-09-02T12:30:30.037Z |
4930835 | 4930835 | 20240810090626_uxXFj | BR000T | 2024-08-31T12:23:59.292Z | 2024-09-02T12:30:28.587Z |
4826303 | 4826303 | 20240804023639_9No22 | BR000T | 2024-08-14T12:20:54.801Z | 2024-08-15T12:26:15.054Z |
4691990 | 4691990 | 20240726063805_TNQLq | BR000T | 2024-07-27T12:06:48.593Z | 2024-08-03T12:21:28.765Z |
4691986 | 4691986 | 20240726063416_XZNqm | BR000T | 2024-07-27T12:06:48.027Z | 2024-08-03T12:21:28.615Z |
4684676 | 4684676 | 20240725050109_G5OOD | BR000T | 2024-07-26T12:04:02.499Z | 2024-08-02T12:24:27.791Z |
4681270 | 4681270 | 20240724063439_sOsDV | BR000T | 2024-07-25T12:03:50.400Z | 2024-08-01T12:12:04.140Z |
4681216 | 4681216 | 20240724054319_4lK3Q | BR000T | 2024-07-25T12:03:45.270Z | 2024-08-01T12:12:03.900Z |
4681202 | 4681202 | 20240724052941_HXwlu | BR000T | 2024-07-25T12:03:43.822Z | 2024-08-01T12:12:03.870Z |
4680660 | 4680660 | 20240723233339_SCtvl | BR000T | 2024-07-25T12:02:34.575Z | 2024-08-01T12:12:02.238Z |
4678146 | 4678146 | 20240723062519_4krL8 | BR000T | 2024-07-24T12:03:14.692Z | 2024-07-31T12:17:58.394Z |
4677945 | 4677945 | 20240723015316_2EyTc | BR000T | 2024-07-24T12:02:35.919Z | 2024-07-31T12:17:55.954Z |
4672358 | 4672358 | 20240720012035_3aScO | BR000T | 2024-07-21T12:03:57.237Z | 2024-07-28T12:14:55.857Z |
4662978 | 4662978 | 20240718035256_ig0Ue | BR000T | 2024-07-19T12:05:30.373Z | 2024-07-26T12:17:48.160Z |
4535812 | 4535812 | 20240702081609_7pkzw | BR000T | 2024-07-03T12:03:50.500Z | 2024-07-10T12:15:31.648Z |
4535699 | 4535699 | 20240702074309_p2s7t | BR000T | 2024-07-03T12:03:40.173Z | 2024-07-10T12:15:31.147Z |
4535341 | 4535341 | 20240702060333_k3Uwf | BR000T | 2024-07-03T12:02:54.243Z | 2024-07-10T12:15:29.079Z |
4534948 | 4534948 | 20240702033021_2fzgn | BR000T | 2024-07-03T12:02:06.368Z | 2024-07-10T12:15:26.686Z |
4532239 | 4532239 | 20240701081516_Kw8OE | BR000T | 2024-07-02T12:04:07.690Z | 2024-07-09T12:08:07.030Z |
4532202 | 4532202 | 20240701074603_kfEJX | BR000T | 2024-07-02T12:04:04.844Z | 2024-07-09T12:08:06.936Z |
4532200 | 4532200 | 20240701074556_GFxyg | BR000T | 2024-07-02T12:04:04.739Z | 2024-07-09T12:08:06.936Z |
4532079 | 4532079 | 20240701061600_BWVIQ | BR000T | 2024-07-02T12:03:55.672Z | 2024-07-09T12:08:06.523Z |
4522731 | 4522731 | 20240629085640_GCfU5 | BR000T | 2024-06-30T12:05:53.406Z | 2024-07-07T12:13:51.965Z |
4522461 | 4522461 | 20240629074229_1yd9p | BR000T | 2024-06-30T12:05:32.805Z | 2024-07-07T12:13:51.346Z |
4522457 | 4522457 | 20240629074100_ZHjGt | BR000T | 2024-06-30T12:05:32.468Z | 2024-07-07T12:13:51.342Z |
4522250 | 4522250 | 20240629055849_DwrRv | BR000T | 2024-06-30T12:05:23.045Z | 2024-07-07T12:13:50.567Z |
4522117 | 4522117 | 20240629042353_bjaSj | BR000T | 2024-06-30T12:05:17.937Z | 2024-07-07T12:13:50.244Z |
4522027 | 4522027 | 20240629022016_kFhge | BR000T | 2024-06-30T12:05:13.421Z | 2024-07-07T12:13:49.894Z |
4509723 | 4509723 | 20240627051946_z2Gh7 | BR000T | 2024-06-28T12:04:04.606Z | 2024-07-05T12:11:28.948Z |
4494865 | 4494865 | 20240622220821_PEBFb | BR000T | 2024-06-24T12:01:30.377Z | 2024-07-01T12:12:20.614Z |
4472682 | 4472682 | 20240616083656_qF6Wu | BR000T | 2024-06-18T12:02:40.697Z | 2024-06-24T12:11:11.017Z |
4472334 | 4472334 | 20240616065511_LVcZu | BR000T | 2024-06-18T12:02:00.758Z | 2024-06-24T12:11:07.523Z |
4460748 | 4460748 | 20240614062621_qOY27 | BR000T | 2024-06-15T12:02:55.029Z | 2024-06-22T12:16:24.957Z |
4460727 | 4460727 | 20240614061617_1FCwJ | BR000T | 2024-06-15T12:02:52.007Z | 2024-06-22T12:16:24.771Z |
4460705 | 4460705 | 20240614060101_3I2GO | BR000T | 2024-06-15T12:02:47.386Z | 2024-06-22T12:16:24.582Z |
4460691 | 4460691 | 20240614054636_BVC4O | BR000T | 2024-06-15T12:02:45.429Z | 2024-06-22T12:16:24.410Z |
4460688 | 4460688 | 20240614054622_3wKyR | BR000T | 2024-06-15T12:02:45.132Z | 2024-06-22T12:16:24.401Z |
4460683 | 4460683 | 20240614054321_xPlH4 | BR000T | 2024-06-15T12:02:44.030Z | 2024-06-22T12:16:24.332Z |
4460664 | 4460664 | 20240614051703_eWGsO | BR000T | 2024-06-15T12:02:41.324Z | 2024-06-22T12:16:24.228Z |
4460616 | 4460616 | 20240614033629_vjGcp | BR000T | 2024-06-15T12:02:24.293Z | 2024-06-22T12:16:23.750Z |
4457571 | 4457571 | 20240613084316_Iy6kl | BR000T | 2024-06-14T12:03:12.175Z | 2024-06-21T12:11:40.057Z |
4457280 | 4457280 | 20240613071412_G5Nnz | BR000T | 2024-06-14T12:02:49.917Z | 2024-06-21T12:11:38.368Z |
4457277 | 4457277 | 20240613071310_NojwD | BR000T | 2024-06-14T12:02:49.734Z | 2024-06-21T12:11:38.367Z |
4457029 | 4457029 | 20240613060156_yy3rq | BR000T | 2024-06-14T12:02:30.526Z | 2024-06-21T12:11:36.748Z |
4456733 | 4456733 | 20240613021121_63MDe | BR000T | 2024-06-14T12:02:02.287Z | 2024-06-21T12:11:33.551Z |
4450085 | 4450085 | 20240612063603_zTFiz | BR000T | 2024-06-13T12:02:18.860Z | 2024-06-20T12:11:57.142Z |
4450045 | 4450045 | 20240612062010_ilxQh | BR000T | 2024-06-13T12:02:14.174Z | 2024-06-20T12:11:56.978Z |
4449937 | 4449937 | 20240612053239_W7YQW | BR000T | 2024-06-13T12:02:03.897Z | 2024-06-20T12:11:55.939Z |
4449688 | 4449688 | 20240612014630_mUDu1 | BR000T | 2024-06-13T12:01:40.824Z | 2024-06-20T12:11:54.213Z |
4448522 | 4448522 | 20240609042400_70ogM | BR000T | 2024-06-12T12:07:17.769Z | 2024-06-17T12:15:15.419Z |
4442826 | 4442826 | 20240610082243_lsdPc | BR000T | 2024-06-11T12:02:34.829Z | 2024-06-18T12:11:09.161Z |
4442413 | 4442413 | 20240610050321_5r1i4 | BR000T | 2024-06-11T12:01:48.116Z | 2024-06-18T12:11:06.014Z |
4439044 | 4439044 | 20240609040256_8HUPh | BR000T | 2024-06-10T12:01:54.423Z | 2024-06-17T12:15:15.102Z |
4429117 | 4429117 | 20240607081806_b8e2x | BR000T | 2024-06-08T12:07:04.457Z | 2024-06-15T12:17:04.378Z |
4429101 | 4429101 | 20240607080551_gY97c | BR000T | 2024-06-08T12:07:01.445Z | 2024-06-15T12:17:04.205Z |
4429085 | 4429085 | 20240607072204_nmS2S | BR000T | 2024-06-08T12:06:58.788Z | 2024-06-15T12:17:03.798Z |
4428905 | 4428905 | 20240607040913_iYjLu | BR000T | 2024-06-08T12:06:38.810Z | 2024-06-15T12:17:01.155Z |
4428618 | 4428618 | 20240607014643_3ePB9 | BR000T | 2024-06-08T12:06:25.487Z | 2024-06-15T12:16:59.930Z |
4407383 | 4407383 | 20240602054919_rhPa3 | BR000T | 2024-06-04T12:09:37.716Z | 2024-06-10T12:06:48.350Z |
4407260 | 4407260 | 20240602042941_pFd5g | BR000T | 2024-06-04T12:09:19.269Z | 2024-06-10T12:06:48.069Z |
4397160 | 4397160 | 20240531021453_f4vj7 | BR000T | 2024-06-01T12:08:43.025Z | 2024-06-08T12:14:11.637Z |
4396981 | 4396981 | 20240531005632_aNqpi | BR000T | 2024-06-01T12:08:16.976Z | 2024-06-08T12:14:09.947Z |
4396975 | 4396975 | 20240531005459_sbCZJ | BR000T | 2024-06-01T12:08:16.245Z | 2024-06-08T12:14:09.914Z |
4394499 | 4394499 | 20240530060851_c3G1Q | BR000T | 2024-05-31T12:10:21.997Z | 2024-06-07T12:16:09.308Z |
4394439 | 4394439 | 20240530053258_d403K | BR000T | 2024-05-31T12:10:10.455Z | 2024-06-07T12:16:08.339Z |
4389537 | 4389537 | 20240530065459_eOSC7 | BR000T | 2024-05-31T12:00:21.583Z | 2024-06-08T12:14:00.761Z |
4388187 | 4388187 | 20240529083802_rp3w8 | BR000T | 2024-05-30T12:01:15.014Z | 2024-06-07T12:15:51.862Z |
4388039 | 4388039 | 20240529074047_P4tMX | BR000T | 2024-05-30T12:00:53.142Z | 2024-06-07T12:15:50.967Z |
4356454 | 4356454 | 20240512052724_2qNw3 | BR000T | 2024-05-22T12:07:15.311Z | 2024-05-22T12:07:15.311Z |
4335187 | 4335187 | 20240509080937_0VShi | BR000T | 2024-05-18T12:13:23.183Z | 2024-05-19T12:15:48.822Z |
4334968 | 4334968 | 20240509073744_e3KcZ | BR000T | 2024-05-18T12:12:57.767Z | 2024-05-19T12:15:43.642Z |
4323163 | 4323163 | 20240508083822_QwWX1 | BR000T | 2024-05-16T12:11:48.392Z | 2024-05-17T12:13:10.615Z |
4322928 | 4322928 | 20240508073328_YyPIA | BR000T | 2024-05-16T12:11:28.779Z | 2024-05-17T12:13:02.737Z |
4322892 | 4322892 | 20240508072923_tf9n2 | BR000T | 2024-05-16T12:11:26.001Z | 2024-05-17T12:13:01.213Z |
4322802 | 4322802 | 20240508065956_5b4qT | BR000T | 2024-05-16T12:11:17.550Z | 2024-05-17T12:12:57.177Z |
4322790 | 4322790 | 20240508065748_tel5L | BR000T | 2024-05-16T12:11:16.363Z | 2024-05-17T12:12:55.762Z |
4322596 | 4322596 | 20240508055948_WkFQe | BR000T | 2024-05-16T12:10:55.226Z | 2024-05-17T12:12:50.032Z |
4322405 | 4322405 | 20240508033016_01rqA | BR000T | 2024-05-16T12:10:33.515Z | 2024-05-17T12:12:40.668Z |
4316232 | 4316232 | 20240507083433_Pr6J1 | BR000T | 2024-05-15T12:12:44.830Z | 2024-05-16T12:13:58.059Z |
4316184 | 4316184 | 20240507082656_QeznY | BR000T | 2024-05-15T12:12:41.177Z | 2024-05-16T12:13:57.058Z |
4316161 | 4316161 | 20240507082112_dOhYg | BR000T | 2024-05-15T12:12:37.495Z | 2024-05-16T12:13:56.410Z |
4315957 | 4315957 | 20240507074711_orkyq | BR000T | 2024-05-15T12:12:14.730Z | 2024-05-16T12:13:52.873Z |
4315946 | 4315946 | 20240507074312_KppaF | BR000T | 2024-05-15T12:12:11.940Z | 2024-05-16T12:13:52.670Z |
4315643 | 4315643 | 20240507063904_4ol2G | BR000T | 2024-05-15T12:11:35.711Z | 2024-05-16T12:13:45.931Z |
4315568 | 4315568 | 20240507060804_dhk4p | BR000T | 2024-05-15T12:11:21.585Z | 2024-05-16T12:13:44.021Z |
4302746 | 4302746 | 20240505230729_ZXz6R | BR000T | 2024-05-09T12:08:43.516Z | 2024-05-14T12:14:40.314Z |
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);