participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
77 rows where station_code = "BR000M" 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 |
---|---|---|---|---|---|
5237432 | 5237432 | 20241006041415_9tSWC | BR000M | 2024-10-07T12:01:35.861Z | 2024-10-15T12:28:42.018Z |
5095362 | 5095362 | 20240912072151_vQ0W1 | BR000M | 2024-09-16T12:15:37.045Z | 2024-09-20T12:21:59.543Z |
4983561 | 4983561 | 20240901070850_HOHhM | BR000M | 2024-09-07T12:00:17.878Z | 2024-09-10T12:19:01.913Z |
4956223 | 4956223 | 20240811065759_WwQqM | BR000M | 2024-09-03T12:20:05.368Z | 2024-09-06T12:30:21.705Z |
4955714 | 4955714 | 20240811055247_TJkwA | BR000M | 2024-09-03T12:19:25.250Z | 2024-09-06T12:29:54.921Z |
4868166 | 4868166 | 20240806055406_mxjMa | BR000M | 2024-08-18T12:24:01.112Z | 2024-08-19T12:28:37.926Z |
4826630 | 4826630 | 20240804051354_i7Dpg | BR000M | 2024-08-14T12:21:17.323Z | 2024-08-15T12:26:23.050Z |
4691900 | 4691900 | 20240726045452_0U2zi | BR000M | 2024-07-27T12:06:38.969Z | 2024-08-03T12:21:27.110Z |
4691822 | 4691822 | 20240726032432_7afa3 | BR000M | 2024-07-27T12:06:16.780Z | 2024-08-03T12:21:24.895Z |
4691614 | 4691614 | 20240726021445_pchqv | BR000M | 2024-07-27T12:05:54.152Z | 2024-08-03T12:21:22.544Z |
4684917 | 4684917 | 20240725071700_6xZPx | BR000M | 2024-07-26T12:04:41.068Z | 2024-08-02T12:24:34.046Z |
4684473 | 4684473 | 20240725015143_22Gol | BR000M | 2024-07-26T12:03:24.711Z | 2024-08-02T12:24:19.844Z |
4681437 | 4681437 | 20240724072425_8Uilv | BR000M | 2024-07-25T12:04:01.510Z | 2024-08-01T12:12:04.572Z |
4665040 | 4665040 | 20240717053636_ajCYk | BR000M | 2024-07-19T12:09:23.195Z | 2024-07-25T12:14:11.759Z |
4651094 | 4651094 | 20240715041701_4N0oY | BR000M | 2024-07-17T12:09:46.753Z | 2024-07-23T12:08:48.763Z |
4649025 | 4649025 | 20240715002345_bi2A2 | BR000M | 2024-07-17T12:08:28.402Z | 2024-07-23T12:08:44.634Z |
4580307 | 4580307 | 20240707075727_Hko4l | BR000M | 2024-07-09T12:03:19.017Z | 2024-07-15T12:12:10.700Z |
4579600 | 4579600 | 20240707025244_pN3z3 | BR000M | 2024-07-09T12:02:37.014Z | 2024-07-15T12:12:03.883Z |
4571142 | 4571142 | 20240706052702_u3Ygm | BR000M | 2024-07-08T12:03:38.508Z | 2024-07-14T12:13:56.350Z |
4539067 | 4539067 | 20240703064806_3xYuV | BR000M | 2024-07-04T12:03:13.172Z | 2024-07-11T12:14:41.204Z |
4515127 | 4515127 | 20240628021841_pyQbL | BR000M | 2024-06-29T12:07:25.442Z | 2024-07-06T12:16:30.224Z |
4515103 | 4515103 | 20240628020317_d2thW | BR000M | 2024-06-29T12:07:22.457Z | 2024-07-06T12:16:30.084Z |
4515007 | 4515007 | 20240628014511_LLT9t | BR000M | 2024-06-29T12:07:14.549Z | 2024-07-06T12:16:29.418Z |
4501648 | 4501648 | 20240625022334_Qx1Vw | BR000M | 2024-06-26T12:05:31.557Z | 2024-07-03T12:13:19.541Z |
4492776 | 4492776 | 20240618055421_xTOoc | BR000M | 2024-06-22T12:09:12.937Z | 2024-06-27T12:11:01.022Z |
4486044 | 4486044 | 20240619074857_Lucnv | BR000M | 2024-06-21T12:01:53.585Z | 2024-06-28T12:09:26.723Z |
4475084 | 4475084 | 20240617014911_R3jyT | BR000M | 2024-06-19T12:01:06.490Z | 2024-06-26T12:14:05.472Z |
4474833 | 4474833 | 20240617010327_qsApr | BR000M | 2024-06-19T12:00:43.195Z | 2024-06-26T12:14:02.918Z |
4472656 | 4472656 | 20240616082940_m3Kzh | BR000M | 2024-06-18T12:02:37.923Z | 2024-06-24T12:11:10.760Z |
4472593 | 4472593 | 20240616081615_KeRSJ | BR000M | 2024-06-18T12:02:30.733Z | 2024-06-24T12:11:09.994Z |
4472089 | 4472089 | 20240616053938_i9V63 | BR000M | 2024-06-18T12:01:33.089Z | 2024-06-24T12:11:02.926Z |
4471695 | 4471695 | 20240616013634_y96Xt | BR000M | 2024-06-18T12:00:38.736Z | 2024-06-24T12:10:58.794Z |
4455561 | 4455561 | 20240612225020_L5bMN | BR000M | 2024-06-14T12:00:56.149Z | 2024-06-21T12:11:28.598Z |
4446665 | 4446665 | 20240611074300_7KHkk | BR000M | 2024-06-12T12:03:11.302Z | 2024-06-19T12:13:36.287Z |
4446398 | 4446398 | 20240611051145_dHE2J | BR000M | 2024-06-12T12:02:46.481Z | 2024-06-19T12:13:33.680Z |
4442162 | 4442162 | 20240610002040_wus2p | BR000M | 2024-06-11T12:01:22.122Z | 2024-06-18T12:11:03.354Z |
4411372 | 4411372 | 20240603032738_aa3Mm | BR000M | 2024-06-05T12:09:01.347Z | 2024-06-11T12:13:39.939Z |
4397422 | 4397422 | 20240531060548_lr3EH | BR000M | 2024-06-01T12:09:17.595Z | 2024-06-08T12:14:13.575Z |
4394489 | 4394489 | 20240530060731_uxdTu | BR000M | 2024-05-31T12:10:21.061Z | 2024-06-07T12:16:09.284Z |
4370956 | 4370956 | 20240523054732_2y0pB | BR000M | 2024-05-27T12:00:37.212Z | 2024-05-31T12:16:00.890Z |
4368084 | 4368084 | 20240518021015_DKqxA | BR000M | 2024-05-26T12:05:46.985Z | 2024-05-26T12:09:52.880Z |
4348632 | 4348632 | 20240510074237_OvBro | BR000M | 2024-05-20T12:12:23.049Z | 2024-05-21T12:11:57.602Z |
4334300 | 4334300 | 20240509022819_KILhK | BR000M | 2024-05-18T12:11:39.153Z | 2024-05-19T12:15:19.819Z |
4315669 | 4315669 | 20240507064954_IySRN | BR000M | 2024-05-15T12:11:38.035Z | 2024-05-16T12:13:46.541Z |
4315530 | 4315530 | 20240507055453_pSW9c | BR000M | 2024-05-15T12:11:17.125Z | 2024-05-16T12:13:43.529Z |
4303215 | 4303215 | 20240506022605_yBi2w | BR000M | 2024-05-09T12:09:44.986Z | 2024-05-14T12:14:40.503Z |
4291231 | 4291231 | 20240504065721_MMWyd | BR000M | 2024-05-07T12:13:46.955Z | 2024-05-12T12:21:22.395Z |
4291078 | 4291078 | 20240504055306_FZ1ee | BR000M | 2024-05-07T12:13:38.629Z | 2024-05-12T12:21:16.017Z |
4285655 | 4285655 | 20240504083015_43Ujh | BR000M | 2024-05-07T12:01:05.344Z | 2024-05-13T12:07:19.792Z |
4285490 | 4285490 | 20240504080401_TOeXZ | BR000M | 2024-05-07T12:00:38.731Z | 2024-05-13T12:07:04.620Z |
4285445 | 4285445 | 20240504075748_rwm34 | BR000M | 2024-05-07T12:00:28.052Z | 2024-05-13T12:07:03.094Z |
4272237 | 4272237 | 20240503072133_2NUor | BR000M | 2024-05-05T12:00:29.656Z | 2024-05-12T12:14:50.901Z |
4258009 | 4258009 | 20240430045154_QaM3y | BR000M | 2024-05-02T12:00:24.542Z | 2024-05-09T12:20:48.250Z |
4256991 | 4256991 | 20240429023304_z3kMP | BR000M | 2024-05-01T12:13:02.286Z | 2024-05-07T12:18:54.552Z |
4243726 | 4243726 | 20240428075243_2hzVM | BR000M | 2024-04-29T12:00:57.217Z | 2024-05-07T12:18:12.809Z |
4231134 | 4231134 | 20240422074544_3Tg7G | BR000M | 2024-04-23T12:10:35.773Z | 2024-04-30T12:17:17.066Z |
4231130 | 4231130 | 20240422074049_0uCJr | BR000M | 2024-04-23T12:10:35.587Z | 2024-04-30T12:17:16.770Z |
4223827 | 4223827 | 20240420081349_DaxAh | BR000M | 2024-04-22T12:04:37.840Z | 2024-04-28T12:21:33.734Z |
4223770 | 4223770 | 20240420065105_5qNtD | BR000M | 2024-04-22T12:04:24.178Z | 2024-04-28T12:21:32.461Z |
4223696 | 4223696 | 20240420041256_KMHYL | BR000M | 2024-04-22T12:04:06.810Z | 2024-04-28T12:21:29.913Z |
4223685 | 4223685 | 20240420035000_vEzxE | BR000M | 2024-04-22T12:04:00.509Z | 2024-04-28T12:21:28.913Z |
4223492 | 4223492 | 20240421041641_N02jW | BR000M | 2024-04-22T12:02:23.610Z | 2024-04-29T12:18:31.917Z |
4171208 | 4171208 | 20240411083909_2IiCI | BR000M | 2024-04-12T12:05:11.293Z | 2024-04-19T12:13:22.781Z |
4139526 | 4139526 | 20240403061446_WGrNy | BR000M | 2024-04-04T12:07:30.387Z | 2024-04-11T12:23:47.868Z |
4139516 | 4139516 | 20240403061009_s2205 | BR000M | 2024-04-04T12:07:29.478Z | 2024-04-11T12:23:47.809Z |
4129668 | 4129668 | 20240331024206_a75Kn | BR000M | 2024-04-01T12:07:13.097Z | 2024-04-08T12:18:43.875Z |
4065734 | 4065734 | 20240313030709_ZhvGg | BR000M | 2024-03-14T12:08:08.231Z | 2024-03-21T12:22:16.390Z |
4065630 | 4065630 | 20240312222557_9f3yY | BR000M | 2024-03-14T12:07:49.454Z | 2024-03-21T12:22:09.880Z |
2696034 | 2696034 | 20230805011455_rYM33 | BR000M | 2024-01-06T00:00:15.112Z | 2024-01-06T00:00:15.112Z |
2692104 | 2692104 | 20230804002804_2iPDC | BR000M | 2024-01-06T00:00:13.374Z | 2024-01-06T00:00:13.374Z |
2565968 | 2565968 | 20230626023636_1eQeq | BR000M | 2024-01-05T23:59:01.448Z | 2024-01-05T23:59:01.448Z |
2552411 | 2552411 | 20230622041057_2UTfW | BR000M | 2024-01-05T23:58:54.002Z | 2024-01-05T23:58:54.002Z |
2457788 | 2457788 | 20230515060035_12EqG | BR000M | 2024-01-05T23:57:43.143Z | 2024-01-05T23:57:43.143Z |
2423500 | 2423500 | 20230427063340_NbZdZ | BR000M | 2024-01-05T23:57:16.030Z | 2024-01-05T23:57:16.030Z |
2399564 | 2399564 | 20230420083445_ViCOU | BR000M | 2024-01-05T23:57:03.683Z | 2024-01-05T23:57:03.683Z |
2399347 | 2399347 | 20230420072134_nLfOo | BR000M | 2024-01-05T23:57:03.637Z | 2024-01-05T23:57:03.637Z |
2342475 | 2342475 | 20230323063730_cHcdI | BR000M | 2024-01-05T23:56:20.675Z | 2024-01-05T23:56:20.675Z |
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);