participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,492 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 |
---|---|---|---|---|---|
5524835 | 5524835 | 20241111055919_vK0bQ | BR000F | 2024-11-12T14:18:02.892Z | 2024-11-12T14:18:08.796Z |
5524785 | 5524785 | 20241111054255_fix2w | BR000F | 2024-11-12T14:18:01.123Z | 2024-11-12T14:18:08.779Z |
5524764 | 5524764 | 20241111053444_1PylX | BR000F | 2024-11-12T14:18:00.279Z | 2024-11-12T14:18:08.770Z |
5524725 | 5524725 | 20241111052005_m333B | BR000F | 2024-11-12T14:17:58.069Z | 2024-11-12T14:18:08.750Z |
5524626 | 5524626 | 20241111044742_9a6Sw | BR000F | 2024-11-12T14:17:46.962Z | 2024-11-12T14:18:08.708Z |
5524573 | 5524573 | 20241111043822_QFLog | BR000F | 2024-11-12T14:17:42.193Z | 2024-11-12T14:18:08.687Z |
5524443 | 5524443 | 20241111041437_oGcMg | BR000F | 2024-11-12T14:17:22.074Z | 2024-11-12T14:18:08.626Z |
5524425 | 5524425 | 20241111041043_pm0ew | BR000F | 2024-11-12T14:17:20.340Z | 2024-11-12T14:18:08.616Z |
5524365 | 5524365 | 20241111040105_Az0af | BR000F | 2024-11-12T14:17:09.949Z | 2024-11-12T14:18:08.584Z |
5524258 | 5524258 | 20241111034148_RHpk7 | BR000F | 2024-11-12T14:16:51.990Z | 2024-11-12T14:18:08.532Z |
5524219 | 5524219 | 20241111033510_d0Bhp | BR000F | 2024-11-12T14:16:47.979Z | 2024-11-12T14:18:08.518Z |
5523804 | 5523804 | 20241111022610_t9PS2 | BR000F | 2024-11-12T14:16:14.126Z | 2024-11-12T14:18:08.351Z |
5523496 | 5523496 | 20241111013525_vQYjg | BR000F | 2024-11-12T14:15:49.204Z | 2024-11-12T14:18:08.223Z |
5523005 | 5523005 | 20241110233250_gknY1 | BR000F | 2024-11-12T14:14:37.688Z | 2024-11-12T14:18:07.994Z |
5518405 | 5518405 | 20241111072958_slWSq | BR000F | 2024-11-12T14:00:51.603Z | 2024-11-12T14:00:51.603Z |
5518403 | 5518403 | 20241111072843_kTxFs | BR000F | 2024-11-12T14:00:51.322Z | 2024-11-12T14:00:51.322Z |
5518345 | 5518345 | 20241111071219_oypXH | BR000F | 2024-11-12T14:00:40.633Z | 2024-11-12T14:00:40.633Z |
5518335 | 5518335 | 20241111071032_dOlYQ | BR000F | 2024-11-12T14:00:39.041Z | 2024-11-12T14:00:39.041Z |
5518328 | 5518328 | 20241111070944_MgPht | BR000F | 2024-11-12T14:00:36.084Z | 2024-11-12T14:00:36.084Z |
5518326 | 5518326 | 20241111070640_ZgQtC | BR000F | 2024-11-12T14:00:35.504Z | 2024-11-12T14:00:35.504Z |
5518251 | 5518251 | 20241111063750_mSA3X | BR000F | 2024-11-12T14:00:22.148Z | 2024-11-12T14:00:22.148Z |
5518230 | 5518230 | 20241111062456_1nMH7 | BR000F | 2024-11-12T14:00:19.113Z | 2024-11-12T14:00:19.113Z |
5518202 | 5518202 | 20241111061127_apYmK | BR000F | 2024-11-12T14:00:12.922Z | 2024-11-12T14:00:12.922Z |
5517847 | 5517847 | 20241110050125_CNsaO | BR000F | 2024-11-11T14:14:56.139Z | 2024-11-12T14:21:56.584Z |
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 |
5156511 | 5156511 | 20240924051752_FaZFw | BR000F | 2024-09-25T12:08:36.632Z | 2024-10-02T12:18:50.551Z |
5150725 | 5150725 | 20240923003459_1FwCw | BR000F | 2024-09-24T12:01:05.165Z | 2024-10-01T12:22:02.618Z |
5150695 | 5150695 | 20240923002119_PbJl7 | BR000F | 2024-09-24T12:01:01.497Z | 2024-10-01T12:22:02.506Z |
5146643 | 5146643 | 20240922020055_NEE0J | BR000F | 2024-09-23T12:03:23.459Z | 2024-09-30T12:22:38.681Z |
5146505 | 5146505 | 20240922012705_901HG | BR000F | 2024-09-23T12:02:54.359Z | 2024-09-30T12:22:37.484Z |
5146293 | 5146293 | 20240922003743_NgS0F | BR000F | 2024-09-23T12:02:25.230Z | 2024-09-30T12:22:36.179Z |
5095328 | 5095328 | 20240912071520_8enZP | BR000F | 2024-09-16T12:15:32.755Z | 2024-09-20T12:21:59.299Z |
5095291 | 5095291 | 20240912070103_wbNhw | BR000F | 2024-09-16T12:15:30.173Z | 2024-09-20T12:21:58.984Z |
5095267 | 5095267 | 20240912065554_ZJDMB | BR000F | 2024-09-16T12:15:28.690Z | 2024-09-20T12:21:58.898Z |
5095250 | 5095250 | 20240912065251_uhXn1 | BR000F | 2024-09-16T12:15:28.034Z | 2024-09-20T12:21:58.846Z |
5095234 | 5095234 | 20240912064833_Ivjhi | BR000F | 2024-09-16T12:15:25.594Z | 2024-09-20T12:21:58.747Z |
5095232 | 5095232 | 20240912064758_GguFM | BR000F | 2024-09-16T12:15:25.382Z | 2024-09-20T12:21:58.739Z |
5095219 | 5095219 | 20240912064607_Ov63F | BR000F | 2024-09-16T12:15:24.254Z | 2024-09-20T12:21:58.600Z |
5095217 | 5095217 | 20240912064243_9CT1v | BR000F | 2024-09-16T12:15:23.935Z | 2024-09-20T12:21:58.596Z |
5011410 | 5011410 | 20240904062814_OsQV3 | BR000F | 2024-09-09T12:09:39.776Z | 2024-09-12T12:19:31.657Z |
5010731 | 5010731 | 20240904033625_2wG7q | BR000F | 2024-09-09T12:08:58.730Z | 2024-09-12T12:19:28.844Z |
4992247 | 4992247 | 20240901064312_OnXA3 | BR000F | 2024-09-07T12:13:06.747Z | 2024-09-09T12:27:57.616Z |
4992199 | 4992199 | 20240901062424_5QXOJ | BR000F | 2024-09-07T12:13:01.988Z | 2024-09-09T12:27:54.662Z |
4992143 | 4992143 | 20240901055442_2PHP2 | BR000F | 2024-09-07T12:12:56.893Z | 2024-09-09T12:27:49.966Z |
4992111 | 4992111 | 20240901054621_QRy3z | BR000F | 2024-09-07T12:12:55.574Z | 2024-09-09T12:27:48.691Z |
4990919 | 4990919 | 20240901013406_Ellp5 | BR000F | 2024-09-07T12:11:18.542Z | 2024-09-09T12:26:55.200Z |
4990831 | 4990831 | 20240901011715_PU7lX | BR000F | 2024-09-07T12:11:11.917Z | 2024-09-09T12:26:47.469Z |
4990633 | 4990633 | 20240901004758_BHuWw | BR000F | 2024-09-07T12:10:51.557Z | 2024-09-09T12:26:25.681Z |
4989990 | 4989990 | 20240831231130_GLkSm | BR000F | 2024-09-07T12:09:53.674Z | 2024-09-09T12:26:08.199Z |
4983555 | 4983555 | 20240901070626_1FJyk | BR000F | 2024-09-07T12:00:16.627Z | 2024-09-10T12:19:01.791Z |
4973597 | 4973597 | 20240811225835_ycnI0 | BR000F | 2024-09-05T12:11:00.759Z | 2024-09-06T12:10:01.086Z |
4957484 | 4957484 | 20240811084818_OeCFK | BR000F | 2024-09-03T12:21:20.510Z | 2024-09-06T12:31:21.024Z |
4957110 | 4957110 | 20240811081355_YuZ3g | BR000F | 2024-09-03T12:20:50.130Z | 2024-09-06T12:31:04.736Z |
4957064 | 4957064 | 20240811081120_5VcBY | BR000F | 2024-09-03T12:20:48.297Z | 2024-09-06T12:31:00.346Z |
4956935 | 4956935 | 20240811080129_9SDy5 | BR000F | 2024-09-03T12:20:43.774Z | 2024-09-06T12:30:55.476Z |
4956885 | 4956885 | 20240811075833_sTRAu | BR000F | 2024-09-03T12:20:42.044Z | 2024-09-06T12:30:53.081Z |
4956880 | 4956880 | 20240811075743_AVkDv | BR000F | 2024-09-03T12:20:41.845Z | 2024-09-06T12:30:52.563Z |
4956872 | 4956872 | 20240811075648_RIuNP | BR000F | 2024-09-03T12:20:41.609Z | 2024-09-06T12:30:52.197Z |
4956865 | 4956865 | 20240811075631_ELt6V | BR000F | 2024-09-03T12:20:41.467Z | 2024-09-06T12:30:51.680Z |
4956857 | 4956857 | 20240811075510_9d2TO | BR000F | 2024-09-03T12:20:41.208Z | 2024-09-06T12:30:50.153Z |
4956727 | 4956727 | 20240811074211_T9Azl | BR000F | 2024-09-03T12:20:37.258Z | 2024-09-06T12:30:45.639Z |
4956695 | 4956695 | 20240811074029_bV1Pj | BR000F | 2024-09-03T12:20:36.325Z | 2024-09-06T12:30:43.895Z |
4956688 | 4956688 | 20240811074005_btihK | BR000F | 2024-09-03T12:20:35.902Z | 2024-09-06T12:30:43.572Z |
4956574 | 4956574 | 20240811073331_dMqAt | BR000F | 2024-09-03T12:20:32.331Z | 2024-09-06T12:30:39.652Z |
4956338 | 4956338 | 20240811070847_OFHTl | BR000F | 2024-09-03T12:20:15.766Z | 2024-09-06T12:30:26.075Z |
4956272 | 4956272 | 20240811070157_wTn7Q | BR000F | 2024-09-03T12:20:09.345Z | 2024-09-06T12:30:23.479Z |
4956202 | 4956202 | 20240811065430_xGq2j | BR000F | 2024-09-03T12:20:03.692Z | 2024-09-06T12:30:20.900Z |
4956073 | 4956073 | 20240811064134_ydkYa | BR000F | 2024-09-03T12:19:49.159Z | 2024-09-06T12:30:12.617Z |
4955999 | 4955999 | 20240811063508_UMojs | BR000F | 2024-09-03T12:19:43.337Z | 2024-09-06T12:30:06.974Z |
4955997 | 4955997 | 20240811063450_OSsxO | BR000F | 2024-09-03T12:19:43.074Z | 2024-09-06T12:30:06.930Z |
4955988 | 4955988 | 20240811063302_7JbrH | BR000F | 2024-09-03T12:19:42.400Z | 2024-09-06T12:30:06.680Z |
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);