participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
886 rows where station_code = "BR001H" 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 |
---|---|---|---|---|---|
5095363 | 5095363 | 20240912072151_vQ0W1 | BR001H | 2024-09-16T12:15:37.045Z | 2024-09-19T12:21:18.210Z |
5095330 | 5095330 | 20240912071520_8enZP | BR001H | 2024-09-16T12:15:32.755Z | 2024-09-19T12:21:18.141Z |
5095292 | 5095292 | 20240912070103_wbNhw | BR001H | 2024-09-16T12:15:30.173Z | 2024-09-19T12:21:17.974Z |
5095268 | 5095268 | 20240912065554_ZJDMB | BR001H | 2024-09-16T12:15:28.690Z | 2024-09-19T12:21:17.853Z |
5095235 | 5095235 | 20240912064833_Ivjhi | BR001H | 2024-09-16T12:15:25.594Z | 2024-09-19T12:21:17.599Z |
5095233 | 5095233 | 20240912064758_GguFM | BR001H | 2024-09-16T12:15:25.382Z | 2024-09-19T12:21:17.598Z |
5095220 | 5095220 | 20240912064607_Ov63F | BR001H | 2024-09-16T12:15:24.254Z | 2024-09-19T12:21:17.544Z |
5095218 | 5095218 | 20240912064243_9CT1v | BR001H | 2024-09-16T12:15:24.042Z | 2024-09-19T12:21:17.541Z |
4992248 | 4992248 | 20240901064312_OnXA3 | BR001H | 2024-09-07T12:13:06.747Z | 2024-09-09T12:27:57.616Z |
4992200 | 4992200 | 20240901062424_5QXOJ | BR001H | 2024-09-07T12:13:01.988Z | 2024-09-09T12:27:54.662Z |
4992144 | 4992144 | 20240901055442_2PHP2 | BR001H | 2024-09-07T12:12:56.893Z | 2024-09-09T12:27:49.966Z |
4992112 | 4992112 | 20240901054621_QRy3z | BR001H | 2024-09-07T12:12:55.574Z | 2024-09-09T12:27:48.691Z |
4990920 | 4990920 | 20240901013406_Ellp5 | BR001H | 2024-09-07T12:11:18.599Z | 2024-09-09T12:26:55.200Z |
4989991 | 4989991 | 20240831231130_GLkSm | BR001H | 2024-09-07T12:09:53.674Z | 2024-09-09T12:26:08.199Z |
4983562 | 4983562 | 20240901070850_HOHhM | BR001H | 2024-09-07T12:00:17.878Z | 2024-09-10T12:19:01.913Z |
4983556 | 4983556 | 20240901070626_1FJyk | BR001H | 2024-09-07T12:00:16.647Z | 2024-09-10T12:19:01.791Z |
4957111 | 4957111 | 20240811081355_YuZ3g | BR001H | 2024-09-03T12:20:50.130Z | 2024-09-06T12:31:04.736Z |
4957065 | 4957065 | 20240811081120_5VcBY | BR001H | 2024-09-03T12:20:48.297Z | 2024-09-06T12:31:00.346Z |
4956936 | 4956936 | 20240811080129_9SDy5 | BR001H | 2024-09-03T12:20:43.775Z | 2024-09-06T12:30:55.476Z |
4956886 | 4956886 | 20240811075833_sTRAu | BR001H | 2024-09-03T12:20:42.044Z | 2024-09-06T12:30:53.081Z |
4956881 | 4956881 | 20240811075743_AVkDv | BR001H | 2024-09-03T12:20:41.845Z | 2024-09-06T12:30:52.563Z |
4956873 | 4956873 | 20240811075648_RIuNP | BR001H | 2024-09-03T12:20:41.609Z | 2024-09-06T12:30:52.197Z |
4956866 | 4956866 | 20240811075631_ELt6V | BR001H | 2024-09-03T12:20:41.467Z | 2024-09-06T12:30:51.680Z |
4956858 | 4956858 | 20240811075510_9d2TO | BR001H | 2024-09-03T12:20:41.208Z | 2024-09-06T12:30:50.153Z |
4956728 | 4956728 | 20240811074211_T9Azl | BR001H | 2024-09-03T12:20:37.258Z | 2024-09-06T12:30:45.639Z |
4956696 | 4956696 | 20240811074029_bV1Pj | BR001H | 2024-09-03T12:20:36.325Z | 2024-09-06T12:30:43.895Z |
4956689 | 4956689 | 20240811074005_btihK | BR001H | 2024-09-03T12:20:35.902Z | 2024-09-06T12:30:43.572Z |
4956575 | 4956575 | 20240811073331_dMqAt | BR001H | 2024-09-03T12:20:32.331Z | 2024-09-06T12:30:39.652Z |
4956339 | 4956339 | 20240811070847_OFHTl | BR001H | 2024-09-03T12:20:15.766Z | 2024-09-06T12:30:26.075Z |
4956273 | 4956273 | 20240811070157_wTn7Q | BR001H | 2024-09-03T12:20:09.345Z | 2024-09-06T12:30:23.479Z |
4956224 | 4956224 | 20240811065759_WwQqM | BR001H | 2024-09-03T12:20:05.368Z | 2024-09-06T12:30:21.705Z |
4956203 | 4956203 | 20240811065430_xGq2j | BR001H | 2024-09-03T12:20:03.692Z | 2024-09-06T12:30:20.900Z |
4956075 | 4956075 | 20240811064134_ydkYa | BR001H | 2024-09-03T12:19:49.159Z | 2024-09-06T12:30:12.617Z |
4956001 | 4956001 | 20240811063508_UMojs | BR001H | 2024-09-03T12:19:43.337Z | 2024-09-06T12:30:06.974Z |
4955998 | 4955998 | 20240811063450_OSsxO | BR001H | 2024-09-03T12:19:43.074Z | 2024-09-06T12:30:06.930Z |
4955989 | 4955989 | 20240811063302_7JbrH | BR001H | 2024-09-03T12:19:42.400Z | 2024-09-06T12:30:06.680Z |
4955885 | 4955885 | 20240811061750_4BoPv | BR001H | 2024-09-03T12:19:32.073Z | 2024-09-06T12:30:02.528Z |
4955866 | 4955866 | 20240811061605_NZHga | BR001H | 2024-09-03T12:19:30.930Z | 2024-09-06T12:30:01.854Z |
4955830 | 4955830 | 20240811060948_WC3CR | BR001H | 2024-09-03T12:19:28.819Z | 2024-09-06T12:30:00.704Z |
4955763 | 4955763 | 20240811060225_nau0A | BR001H | 2024-09-03T12:19:26.993Z | 2024-09-06T12:29:57.461Z |
4955716 | 4955716 | 20240811055247_TJkwA | BR001H | 2024-09-03T12:19:25.250Z | 2024-09-06T12:29:54.921Z |
4955711 | 4955711 | 20240811055228_BQSYL | BR001H | 2024-09-03T12:19:25.057Z | 2024-09-06T12:29:54.306Z |
4955707 | 4955707 | 20240811055158_pbOlq | BR001H | 2024-09-03T12:19:24.740Z | 2024-09-06T12:29:54.197Z |
4955636 | 4955636 | 20240811054223_dyve3 | BR001H | 2024-09-03T12:19:21.260Z | 2024-09-06T12:29:51.523Z |
4955615 | 4955615 | 20240811053716_ivkjY | BR001H | 2024-09-03T12:19:20.614Z | 2024-09-06T12:29:50.829Z |
4955421 | 4955421 | 20240811045411_hEf3z | BR001H | 2024-09-03T12:19:12.500Z | 2024-09-06T12:29:40.014Z |
4954797 | 4954797 | 20240811031146_cTEm7 | BR001H | 2024-09-03T12:18:20.765Z | 2024-09-06T12:29:08.593Z |
4954622 | 4954622 | 20240811030645_mCH10 | BR001H | 2024-09-03T12:18:17.973Z | 2024-09-06T12:29:05.149Z |
4942002 | 4942002 | 20240810234344_ls1SM | BR001H | 2024-09-02T12:10:59.392Z | 2024-09-06T12:24:02.475Z |
4905198 | 4905198 | 20240808084510_7Hw8Z | BR001H | 2024-08-28T12:21:09.930Z | 2024-08-28T12:21:09.930Z |
4905189 | 4905189 | 20240808084209_gOUhy | BR001H | 2024-08-28T12:21:09.678Z | 2024-08-28T12:21:09.678Z |
4905111 | 4905111 | 20240808083025_es99X | BR001H | 2024-08-28T12:21:05.156Z | 2024-08-28T12:21:05.156Z |
4905069 | 4905069 | 20240808082004_csr15 | BR001H | 2024-08-28T12:20:59.383Z | 2024-08-28T12:20:59.383Z |
4905039 | 4905039 | 20240808081522_tzExE | BR001H | 2024-08-28T12:20:55.474Z | 2024-08-28T12:20:55.474Z |
4869067 | 4869067 | 20240806073320_knK2M | BR001H | 2024-08-18T12:24:44.204Z | 2024-08-19T12:29:11.545Z |
4868999 | 4868999 | 20240806072752_IDcoA | BR001H | 2024-08-18T12:24:40.976Z | 2024-08-19T12:29:09.027Z |
4868902 | 4868902 | 20240806072158_A9hZ6 | BR001H | 2024-08-18T12:24:35.102Z | 2024-08-19T12:29:06.291Z |
4868893 | 4868893 | 20240806072003_vY2mo | BR001H | 2024-08-18T12:24:34.578Z | 2024-08-19T12:29:05.998Z |
4868863 | 4868863 | 20240806071742_rWk93 | BR001H | 2024-08-18T12:24:33.490Z | 2024-08-19T12:29:05.171Z |
4868843 | 4868843 | 20240806071508_ai9kr | BR001H | 2024-08-18T12:24:32.274Z | 2024-08-19T12:29:04.546Z |
4868797 | 4868797 | 20240806071314_ozMOH | BR001H | 2024-08-18T12:24:30.487Z | 2024-08-19T12:29:02.204Z |
4868777 | 4868777 | 20240806071102_DAI7c | BR001H | 2024-08-18T12:24:29.796Z | 2024-08-19T12:29:00.793Z |
4868704 | 4868704 | 20240806070250_aLLnl | BR001H | 2024-08-18T12:24:24.351Z | 2024-08-19T12:28:56.473Z |
4868647 | 4868647 | 20240806065626_EQjIZ | BR001H | 2024-08-18T12:24:20.917Z | 2024-08-19T12:28:53.184Z |
4868601 | 4868601 | 20240806065355_D2BNM | BR001H | 2024-08-18T12:24:18.894Z | 2024-08-19T12:28:50.353Z |
4868595 | 4868595 | 20240806065113_LvMny | BR001H | 2024-08-18T12:24:18.271Z | 2024-08-19T12:28:49.810Z |
4868409 | 4868409 | 20240806063254_GnArG | BR001H | 2024-08-18T12:24:09.700Z | 2024-08-19T12:28:45.431Z |
4868388 | 4868388 | 20240806063102_2KrYs | BR001H | 2024-08-18T12:24:09.380Z | 2024-08-19T12:28:45.196Z |
4868384 | 4868384 | 20240806063059_3anis | BR001H | 2024-08-18T12:24:09.189Z | 2024-08-19T12:28:45.066Z |
4868280 | 4868280 | 20240806061936_oUneZ | BR001H | 2024-08-18T12:24:04.486Z | 2024-08-19T12:28:43.237Z |
4868177 | 4868177 | 20240806055608_Hgqod | BR001H | 2024-08-18T12:24:01.437Z | 2024-08-19T12:28:38.626Z |
4868134 | 4868134 | 20240806054739_iu1WV | BR001H | 2024-08-18T12:24:00.088Z | 2024-08-19T12:28:35.879Z |
4867950 | 4867950 | 20240806045103_Uhg3t | BR001H | 2024-08-18T12:23:54.721Z | 2024-08-19T12:28:31.147Z |
4867912 | 4867912 | 20240806044047_WCbWV | BR001H | 2024-08-18T12:23:53.347Z | 2024-08-19T12:28:30.281Z |
4867900 | 4867900 | 20240806043748_MR4VJ | BR001H | 2024-08-18T12:23:52.849Z | 2024-08-19T12:28:30.010Z |
4867889 | 4867889 | 20240806043248_m9RrW | BR001H | 2024-08-18T12:23:52.320Z | 2024-08-19T12:28:29.664Z |
4867861 | 4867861 | 20240806042450_Z6Qbw | BR001H | 2024-08-18T12:23:51.304Z | 2024-08-19T12:28:28.635Z |
4867802 | 4867802 | 20240806040315_8dP1l | BR001H | 2024-08-18T12:23:47.548Z | 2024-08-19T12:28:27.029Z |
4858782 | 4858782 | 20240806085249_9qIDy | BR001H | 2024-08-18T12:01:15.105Z | 2024-08-27T12:01:21.675Z |
4858098 | 4858098 | 20240806075618_f6FW5 | BR001H | 2024-08-18T12:00:26.048Z | 2024-08-27T12:00:35.428Z |
4857871 | 4857871 | 20240806033334_UxAQO | BR001H | 2024-08-17T12:23:12.080Z | 2024-08-19T12:28:25.122Z |
4857633 | 4857633 | 20240806024308_ozcJ2 | BR001H | 2024-08-17T12:22:46.922Z | 2024-08-19T12:28:19.900Z |
4856548 | 4856548 | 20240806013842_sOowJ | BR001H | 2024-08-17T12:21:31.583Z | 2024-08-19T12:27:32.563Z |
4856205 | 4856205 | 20240806012255_FF6LR | BR001H | 2024-08-17T12:20:58.548Z | 2024-08-19T12:27:16.909Z |
4856098 | 4856098 | 20240806011729_hgr4e | BR001H | 2024-08-17T12:20:51.165Z | 2024-08-19T12:27:11.163Z |
4855832 | 4855832 | 20240806010119_WwHEU | BR001H | 2024-08-17T12:20:33.624Z | 2024-08-19T12:26:57.279Z |
4855411 | 4855411 | 20240806003913_34ckA | BR001H | 2024-08-17T12:20:01.234Z | 2024-08-19T12:26:39.395Z |
4847707 | 4847707 | 20240805052420_9r8L2 | BR001H | 2024-08-16T12:21:07.220Z | 2024-08-17T12:33:11.955Z |
4847702 | 4847702 | 20240805052230_VSkYL | BR001H | 2024-08-16T12:21:06.918Z | 2024-08-17T12:33:11.631Z |
4847551 | 4847551 | 20240805042634_l1MNF | BR001H | 2024-08-16T12:21:00.465Z | 2024-08-17T12:33:06.315Z |
4847408 | 4847408 | 20240805033420_aM63e | BR001H | 2024-08-16T12:20:47.579Z | 2024-08-17T12:32:59.700Z |
4847221 | 4847221 | 20240805025634_YG2l8 | BR001H | 2024-08-16T12:20:27.812Z | 2024-08-17T12:32:54.874Z |
4838403 | 4838403 | 20240805085210_ycFbd | BR001H | 2024-08-16T12:02:17.623Z | 2024-08-19T12:15:44.831Z |
4838359 | 4838359 | 20240805084724_25aDW | BR001H | 2024-08-16T12:02:12.245Z | 2024-08-19T12:15:43.259Z |
4838334 | 4838334 | 20240805084521_Q520G | BR001H | 2024-08-16T12:02:07.943Z | 2024-08-19T12:15:42.344Z |
4838113 | 4838113 | 20240805082757_pVsrq | BR001H | 2024-08-16T12:01:50.954Z | 2024-08-19T12:15:34.346Z |
4837939 | 4837939 | 20240805080957_jHwZ5 | BR001H | 2024-08-16T12:01:36.754Z | 2024-08-19T12:15:29.574Z |
4837922 | 4837922 | 20240805080842_GwTRn | BR001H | 2024-08-16T12:01:34.296Z | 2024-08-19T12:15:28.955Z |
4837892 | 4837892 | 20240805080427_nKy6Z | BR001H | 2024-08-16T12:01:30.628Z | 2024-08-19T12:15:27.878Z |
4837751 | 4837751 | 20240805074408_oCmC2 | BR001H | 2024-08-16T12:01:19.489Z | 2024-08-19T12:15:23.297Z |
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);