participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
128 rows where station_code = "BR0002" 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 |
---|---|---|---|---|---|
4983803 | 4983803 | 20240901080358_lEocE | BR0002 | 2024-09-07T12:00:48.667Z | 2024-09-10T12:19:03.482Z |
4979869 | 4979869 | 20240812000538_ZWEK3 | BR0002 | 2024-09-06T12:13:32.597Z | 2024-09-06T12:13:32.597Z |
4955066 | 4955066 | 20240811033208_NiA8J | BR0002 | 2024-09-03T12:18:40.651Z | 2024-09-06T12:29:17.026Z |
4858424 | 4858424 | 20240806082432_pSWAw | BR0002 | 2024-08-18T12:00:51.209Z | 2024-08-27T12:00:58.935Z |
4847729 | 4847729 | 20240805053314_k2LL1 | BR0002 | 2024-08-16T12:21:08.632Z | 2024-08-17T12:33:14.160Z |
4817910 | 4817910 | 20240804080324_UegTb | BR0002 | 2024-08-14T12:01:31.343Z | 2024-08-17T12:24:00.686Z |
4817804 | 4817804 | 20240804074818_f9lNo | BR0002 | 2024-08-14T12:01:17.124Z | 2024-08-17T12:23:49.107Z |
4806744 | 4806744 | 20240803034830_fwn81 | BR0002 | 2024-08-12T12:19:18.950Z | 2024-08-13T12:17:49.913Z |
4806731 | 4806731 | 20240803032728_QorF7 | BR0002 | 2024-08-12T12:19:18.014Z | 2024-08-13T12:17:49.257Z |
4806725 | 4806725 | 20240803031502_cuc9L | BR0002 | 2024-08-12T12:19:16.986Z | 2024-08-13T12:17:49.054Z |
4806336 | 4806336 | 20240803015109_4WO62 | BR0002 | 2024-08-12T12:18:44.001Z | 2024-08-13T12:17:37.338Z |
4806134 | 4806134 | 20240803013056_m2cxM | BR0002 | 2024-08-12T12:18:27.644Z | 2024-08-13T12:17:31.930Z |
4797619 | 4797619 | 20240803065319_QkkMP | BR0002 | 2024-08-12T12:01:08.594Z | 2024-08-15T12:17:16.244Z |
4797600 | 4797600 | 20240803064634_DnDFS | BR0002 | 2024-08-12T12:01:04.698Z | 2024-08-15T12:17:15.345Z |
4797578 | 4797578 | 20240803063945_EzmSE | BR0002 | 2024-08-12T12:01:01.292Z | 2024-08-15T12:17:14.634Z |
4797412 | 4797412 | 20240803053125_szgrd | BR0002 | 2024-08-12T12:00:27.906Z | 2024-08-15T12:17:09.032Z |
4797334 | 4797334 | 20240803043945_cW38K | BR0002 | 2024-08-12T12:00:13.254Z | 2024-08-15T12:17:06.099Z |
4788084 | 4788084 | 20240802083023_3TqEw | BR0002 | 2024-08-11T12:03:40.961Z | 2024-08-13T12:15:44.188Z |
4787985 | 4787985 | 20240802081709_kJda8 | BR0002 | 2024-08-11T12:03:29.206Z | 2024-08-13T12:15:43.148Z |
4787121 | 4787121 | 20240802044816_t6bTH | BR0002 | 2024-08-11T12:00:57.065Z | 2024-08-13T12:15:18.614Z |
4771327 | 4771327 | 20240731010655_uOHgI | BR0002 | 2024-08-06T12:14:13.680Z | 2024-08-08T12:25:21.544Z |
4763889 | 4763889 | 20240731072154_kLmJC | BR0002 | 2024-08-06T12:05:26.699Z | 2024-08-10T12:18:32.752Z |
4763425 | 4763425 | 20240731054026_pdckl | BR0002 | 2024-08-06T12:04:33.263Z | 2024-08-10T12:18:18.611Z |
4763384 | 4763384 | 20240731053235_ersAQ | BR0002 | 2024-08-06T12:04:30.112Z | 2024-08-10T12:18:16.458Z |
4737056 | 4737056 | 20240729075225_As5O3 | BR0002 | 2024-08-01T12:06:06.240Z | 2024-08-06T12:15:05.551Z |
4736982 | 4736982 | 20240729070359_BLuu9 | BR0002 | 2024-08-01T12:06:01.067Z | 2024-08-06T12:15:03.624Z |
4736754 | 4736754 | 20240729035651_6XwI4 | BR0002 | 2024-08-01T12:05:45.617Z | 2024-08-06T12:14:57.227Z |
4736666 | 4736666 | 20240729030800_rkswv | BR0002 | 2024-08-01T12:05:35.007Z | 2024-08-06T12:14:56.668Z |
4734722 | 4734722 | 20240729015527_kmylP | BR0002 | 2024-08-01T12:04:40.924Z | 2024-08-06T12:14:50.923Z |
4721869 | 4721869 | 20240728052620_9smSY | BR0002 | 2024-07-31T12:07:22.462Z | 2024-08-05T12:20:02.302Z |
4721356 | 4721356 | 20240728025839_EfAU6 | BR0002 | 2024-07-31T12:06:35.876Z | 2024-08-05T12:19:56.681Z |
4718382 | 4718382 | 20240728023119_0ATfs | BR0002 | 2024-07-30T12:09:30.301Z | 2024-08-05T12:19:55.140Z |
4694957 | 4694957 | 20240724030403_53N2x | BR0002 | 2024-07-27T12:13:03.835Z | 2024-08-01T12:12:03.354Z |
4683900 | 4683900 | 20240724223540_ra1PJ | BR0002 | 2024-07-26T12:01:28.286Z | 2024-08-02T12:24:00.012Z |
4678477 | 4678477 | 20240723084417_DV0oC | BR0002 | 2024-07-24T12:04:00.413Z | 2024-07-31T12:18:00.456Z |
4678116 | 4678116 | 20240723055738_ASGOo | BR0002 | 2024-07-24T12:03:10.871Z | 2024-07-31T12:17:58.183Z |
4676000 | 4676000 | 20240722035033_vGtFM | BR0002 | 2024-07-23T12:02:01.470Z | 2024-07-30T12:18:10.531Z |
4669160 | 4669160 | 20240719083729_7iwMr | BR0002 | 2024-07-20T12:05:37.340Z | 2024-07-27T12:17:23.418Z |
4663304 | 4663304 | 20240718084500_U2CaP | BR0002 | 2024-07-19T12:05:52.211Z | 2024-07-26T12:17:51.969Z |
4663001 | 4663001 | 20240718045659_mn2I3 | BR0002 | 2024-07-19T12:05:33.943Z | 2024-07-26T12:17:48.394Z |
4659339 | 4659339 | 20240715063111_AkI86 | BR0002 | 2024-07-18T12:13:25.131Z | 2024-07-23T12:08:49.618Z |
4628424 | 4628424 | 20240713081514_Ov6pi | BR0002 | 2024-07-15T12:00:40.074Z | 2024-07-22T12:09:54.499Z |
4597276 | 4597276 | 20240708032940_KoZC2 | BR0002 | 2024-07-11T12:02:07.523Z | 2024-07-16T12:09:10.881Z |
4571963 | 4571963 | 20240706081404_nBLVe | BR0002 | 2024-07-08T12:04:51.307Z | 2024-07-14T12:14:00.045Z |
4571950 | 4571950 | 20240706081325_VFn26 | BR0002 | 2024-07-08T12:04:50.089Z | 2024-07-14T12:13:59.929Z |
4571255 | 4571255 | 20240706062047_eM3O3 | BR0002 | 2024-07-08T12:03:49.827Z | 2024-07-14T12:13:56.782Z |
4535225 | 4535225 | 20240702052426_Br5kB | BR0002 | 2024-07-03T12:02:42.468Z | 2024-07-10T12:15:28.642Z |
4489967 | 4489967 | 20240621085202_K3sPR | BR0002 | 2024-06-22T12:00:33.391Z | 2024-06-30T12:09:34.804Z |
4485733 | 4485733 | 20240619041949_L7w33 | BR0002 | 2024-06-21T12:01:15.923Z | 2024-06-28T12:09:24.828Z |
4485114 | 4485114 | 20240620054629_dKn4J | BR0002 | 2024-06-21T12:00:12.433Z | 2024-06-29T12:13:17.894Z |
4479302 | 4479302 | 20240618005802_dtkBk | BR0002 | 2024-06-19T12:07:55.360Z | 2024-06-26T12:14:54.111Z |
4475295 | 4475295 | 20240617050928_Ltnuw | BR0002 | 2024-06-19T12:01:32.148Z | 2024-06-26T12:14:09.567Z |
4475082 | 4475082 | 20240617014713_smTdr | BR0002 | 2024-06-19T12:01:06.154Z | 2024-06-26T12:14:05.453Z |
4474616 | 4474616 | 20240618042609_MRWTR | BR0002 | 2024-06-19T12:00:16.832Z | 2024-06-27T12:11:00.055Z |
4471928 | 4471928 | 20240616043607_jf612 | BR0002 | 2024-06-18T12:01:14.645Z | 2024-06-24T12:11:01.254Z |
4464552 | 4464552 | 20240615054249_FRgbM | BR0002 | 2024-06-16T12:02:34.430Z | 2024-06-23T12:11:49.401Z |
4460644 | 4460644 | 20240614044042_X6PRk | BR0002 | 2024-06-15T12:02:37.465Z | 2024-06-22T12:16:24.047Z |
4460601 | 4460601 | 20240614031107_8xC2w | BR0002 | 2024-06-15T12:02:21.680Z | 2024-06-22T12:16:23.674Z |
4457863 | 4457863 | 20240612001050_sjc2E | BR0002 | 2024-06-14T12:03:45.926Z | 2024-06-20T12:11:50.134Z |
4456944 | 4456944 | 20240613051858_DQKuW | BR0002 | 2024-06-14T12:02:23.827Z | 2024-06-21T12:11:35.524Z |
4456912 | 4456912 | 20240613045759_r8NaC | BR0002 | 2024-06-14T12:02:21.064Z | 2024-06-21T12:11:35.328Z |
4446558 | 4446558 | 20240611065945_3g73v | BR0002 | 2024-06-12T12:03:02.190Z | 2024-06-19T12:13:35.148Z |
4446554 | 4446554 | 20240611065737_Wh5lf | BR0002 | 2024-06-12T12:03:01.633Z | 2024-06-19T12:13:35.107Z |
4446335 | 4446335 | 20240611035006_K3BjC | BR0002 | 2024-06-12T12:02:39.615Z | 2024-06-19T12:13:33.190Z |
4442557 | 4442557 | 20240610063856_N3aCL | BR0002 | 2024-06-11T12:02:11.578Z | 2024-06-18T12:11:07.161Z |
4442456 | 4442456 | 20240610055349_GDRlK | BR0002 | 2024-06-11T12:01:56.686Z | 2024-06-18T12:11:06.299Z |
4440146 | 4440146 | 20240608075018_FfIwM | BR0002 | 2024-06-10T12:03:36.863Z | 2024-06-16T12:14:15.629Z |
4439276 | 4439276 | 20240609075151_44l3Q | BR0002 | 2024-06-10T12:02:11.464Z | 2024-06-17T12:15:18.566Z |
4439153 | 4439153 | 20240609061318_6dKX1 | BR0002 | 2024-06-10T12:02:03.084Z | 2024-06-17T12:15:16.794Z |
4429864 | 4429864 | 20240606083452_p8OjX | BR0002 | 2024-06-08T12:09:43.304Z | 2024-06-14T12:08:28.421Z |
4429697 | 4429697 | 20240606072751_tXIKz | BR0002 | 2024-06-08T12:09:33.136Z | 2024-06-14T12:08:27.612Z |
4429593 | 4429593 | 20240606070128_xYx1z | BR0002 | 2024-06-08T12:09:26.533Z | 2024-06-14T12:08:27.097Z |
4429483 | 4429483 | 20240606053405_VdfWO | BR0002 | 2024-06-08T12:09:17.684Z | 2024-06-14T12:08:26.267Z |
4428549 | 4428549 | 20240607013319_1PGaL | BR0002 | 2024-06-08T12:06:22.400Z | 2024-06-15T12:16:59.488Z |
4423228 | 4423228 | 20240605073410_1amhs | BR0002 | 2024-06-07T12:11:08.395Z | 2024-06-13T12:08:36.072Z |
4417455 | 4417455 | 20240604025824_hs2Ih | BR0002 | 2024-06-06T12:09:17.854Z | 2024-06-12T12:10:42.134Z |
4407380 | 4407380 | 20240602054439_LjsYi | BR0002 | 2024-06-04T12:09:36.736Z | 2024-06-10T12:06:48.349Z |
4397325 | 4397325 | 20240531050443_K3xxn | BR0002 | 2024-06-01T12:09:02.028Z | 2024-06-08T12:14:12.952Z |
4394351 | 4394351 | 20240530041858_MWq63 | BR0002 | 2024-05-31T12:09:56.899Z | 2024-06-07T12:16:07.579Z |
4394319 | 4394319 | 20240530031442_ASyu2 | BR0002 | 2024-05-31T12:09:51.762Z | 2024-06-07T12:16:07.354Z |
4389648 | 4389648 | 20240530075353_HsPEg | BR0002 | 2024-05-31T12:00:41.170Z | 2024-06-08T12:14:01.970Z |
4388230 | 4388230 | 20240529085220_9Tbla | BR0002 | 2024-05-30T12:01:28.829Z | 2024-06-07T12:15:51.997Z |
4382604 | 4382604 | 20240524045926_LFjLr | BR0002 | 2024-05-28T12:10:11.118Z | 2024-06-02T12:16:11.191Z |
4356556 | 4356556 | 20240512064612_jebT3 | BR0002 | 2024-05-22T12:07:25.241Z | 2024-05-22T12:07:25.241Z |
4348810 | 4348810 | 20240510083315_UoW7u | BR0002 | 2024-05-20T12:12:51.091Z | 2024-05-21T12:12:05.021Z |
4322845 | 4322845 | 20240508071506_UDrlM | BR0002 | 2024-05-16T12:11:20.758Z | 2024-05-17T12:12:58.417Z |
4322803 | 4322803 | 20240508070256_Ti3HE | BR0002 | 2024-05-16T12:11:17.867Z | 2024-05-17T12:12:57.203Z |
4322379 | 4322379 | 20240508031017_4Rtdl | BR0002 | 2024-05-16T12:10:32.037Z | 2024-05-17T12:12:38.859Z |
4315893 | 4315893 | 20240507073412_rFmhx | BR0002 | 2024-05-15T12:12:01.944Z | 2024-05-16T12:13:51.826Z |
4315626 | 4315626 | 20240507063235_1v6YM | BR0002 | 2024-05-15T12:11:32.170Z | 2024-05-16T12:13:45.585Z |
4315511 | 4315511 | 20240507054742_V3yq1 | BR0002 | 2024-05-15T12:11:12.290Z | 2024-05-16T12:13:42.737Z |
4315495 | 4315495 | 20240507054454_blC3i | BR0002 | 2024-05-15T12:11:10.901Z | 2024-05-16T12:13:42.365Z |
4309738 | 4309738 | 20240507005047_1mNjJ | BR0002 | 2024-05-14T12:09:51.099Z | 2024-05-16T12:13:27.399Z |
4303621 | 4303621 | 20240506083315_uuyBp | BR0002 | 2024-05-11T12:09:14.100Z | 2024-05-14T12:14:40.651Z |
4303531 | 4303531 | 20240506074739_sFYzn | BR0002 | 2024-05-11T12:08:52.987Z | 2024-05-14T12:14:40.613Z |
4303292 | 4303292 | 20240506050608_4S0Mw | BR0002 | 2024-05-09T12:09:51.035Z | 2024-05-14T12:14:40.546Z |
4291046 | 4291046 | 20240504052544_29jCm | BR0002 | 2024-05-07T12:13:37.361Z | 2024-05-12T12:21:13.683Z |
4272403 | 4272403 | 20240503080225_wIg9y | BR0002 | 2024-05-05T12:01:07.195Z | 2024-05-12T12:15:06.297Z |
4267582 | 4267582 | 20240502082911_8holq | BR0002 | 2024-05-04T12:02:20.457Z | 2024-05-11T12:25:27.735Z |
4243613 | 4243613 | 20240428055242_9QarN | BR0002 | 2024-04-29T12:00:31.970Z | 2024-05-07T12:18:09.790Z |
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);