home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

959 rows where station_code = "BR000S" sorted by created_at descending

✎ View and edit SQL

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
9813824 9813824 20260428053643_TKAIJ BR000S 2026-04-29T12:16:17.019Z 2026-04-29T12:24:07.794Z
9813807 9813807 20260428052045_j266b BR000S 2026-04-29T12:16:13.257Z 2026-04-29T12:24:07.782Z
9813776 9813776 20260428045206_YDCBS BR000S 2026-04-29T12:16:07.412Z 2026-04-29T12:24:07.761Z
9813771 9813771 20260428044456_XWrZ8 BR000S 2026-04-29T12:16:06.510Z 2026-04-29T12:24:07.758Z
9813765 9813765 20260428043605_C6cJy BR000S 2026-04-29T12:16:05.365Z 2026-04-29T12:24:07.753Z
9813761 9813761 20260428043437_Lfvkz BR000S 2026-04-29T12:16:04.507Z 2026-04-29T12:24:07.750Z
9813748 9813748 20260428041248_C8o8P BR000S 2026-04-29T12:15:56.088Z 2026-04-29T12:24:07.740Z
9813727 9813727 20260428035556_ZJUo3 BR000S 2026-04-29T12:15:49.649Z 2026-04-29T12:24:07.725Z
9813725 9813725 20260428035533_aj4os BR000S 2026-04-29T12:15:49.272Z 2026-04-29T12:24:07.723Z
9813721 9813721 20260428035158_6flem BR000S 2026-04-29T12:15:48.365Z 2026-04-29T12:24:07.718Z
9813707 9813707 20260428033846_8lTDE BR000S 2026-04-29T12:15:45.536Z 2026-04-29T12:24:07.709Z
9813664 9813664 20260428031353_SLCJ9 BR000S 2026-04-29T12:15:35.846Z 2026-04-29T12:24:07.678Z
9813662 9813662 20260428031329_jJ6nE BR000S 2026-04-29T12:15:35.325Z 2026-04-29T12:24:07.676Z
9813654 9813654 20260428030731_4U3We BR000S 2026-04-29T12:15:28.662Z 2026-04-29T12:24:07.671Z
9813604 9813604 20260428025118_mtqxv BR000S 2026-04-29T12:15:14.355Z 2026-04-29T12:24:07.640Z
9813533 9813533 20260428023313_peITy BR000S 2026-04-29T12:14:54.774Z 2026-04-29T12:24:07.601Z
9813495 9813495 20260428021815_cOOUn BR000S 2026-04-29T12:14:44.090Z 2026-04-29T12:24:07.575Z
9813148 9813148 20260428010511_03Duq BR000S 2026-04-29T12:13:16.472Z 2026-04-29T12:24:07.375Z
9788188 9788188 20260425070616_DW82o BR000S 2026-04-26T12:24:01.596Z 2026-04-29T12:50:42.825Z
9788153 9788153 20260425063855_8FZCD BR000S 2026-04-26T12:23:58.701Z 2026-04-29T12:50:28.256Z
9788046 9788046 20260425051629_v4L12 BR000S 2026-04-26T12:23:32.374Z 2026-04-29T12:50:22.932Z
9788022 9788022 20260425045522_tH0br BR000S 2026-04-26T12:23:25.414Z 2026-04-29T12:50:21.942Z
9788020 9788020 20260425044956_jGvff BR000S 2026-04-26T12:23:25.291Z 2026-04-29T12:50:21.879Z
9788016 9788016 20260425044155_IRzoU BR000S 2026-04-26T12:23:24.986Z 2026-04-29T12:50:21.781Z
9784668 9784668 20260424232502_twvhD BR000S 2026-04-26T12:17:35.290Z 2026-04-29T12:48:18.724Z
9774462 9774462 20260423085032_AElnr BR000S 2026-04-25T12:54:44.237Z 2026-04-29T13:09:22.039Z
9774307 9774307 20260423083907_60JEL BR000S 2026-04-25T12:54:16.890Z 2026-04-29T13:09:12.467Z
9773804 9773804 20260423074905_cdWGu BR000S 2026-04-25T12:53:10.178Z 2026-04-29T13:08:27.838Z
9773781 9773781 20260423074640_xtHMo BR000S 2026-04-25T12:53:05.381Z 2026-04-29T13:08:27.344Z
9773738 9773738 20260423073947_HdX4Q BR000S 2026-04-25T12:53:02.334Z 2026-04-29T13:08:26.437Z
9773728 9773728 20260423073719_C6A4w BR000S 2026-04-25T12:53:01.800Z 2026-04-29T13:08:26.332Z
9773621 9773621 20260423072302_q7axU BR000S 2026-04-25T12:52:53.715Z 2026-04-29T13:08:24.747Z
9773493 9773493 20260423070223_d9uDo BR000S 2026-04-25T12:52:26.933Z 2026-04-29T13:08:20.956Z
9773186 9773186 20260423061713_j3iKh BR000S 2026-04-25T12:51:36.977Z 2026-04-29T13:08:16.143Z
9773145 9773145 20260423061000_qjYcY BR000S 2026-04-25T12:51:31.185Z 2026-04-29T13:08:15.493Z
9773143 9773143 20260423060949_K3qTD BR000S 2026-04-25T12:51:31.152Z 2026-04-29T13:08:15.473Z
9773041 9773041 20260423055013_e2OEI BR000S 2026-04-25T12:51:23.314Z 2026-04-29T13:08:14.067Z
9773015 9773015 20260423054503_O2ro2 BR000S 2026-04-25T12:51:20.747Z 2026-04-29T13:08:13.667Z
9772990 9772990 20260423054139_w5LMN BR000S 2026-04-25T12:51:19.402Z 2026-04-29T13:08:13.419Z
9772988 9772988 20260423053928_hJ9Pd BR000S 2026-04-25T12:51:18.941Z 2026-04-29T13:08:13.385Z
9772899 9772899 20260423050810_9Dsfl BR000S 2026-04-25T12:50:49.924Z 2026-04-29T13:08:12.165Z
9772879 9772879 20260423050205_LXOC0 BR000S 2026-04-25T12:50:44.996Z 2026-04-29T13:08:11.945Z
9772797 9772797 20260423043903_DMl24 BR000S 2026-04-25T12:50:38.025Z 2026-04-29T13:08:10.828Z
9772739 9772739 20260423040503_Nh05r BR000S 2026-04-25T12:50:33.022Z 2026-04-29T13:08:10.030Z
9772683 9772683 20260423034038_gmo7m BR000S 2026-04-25T12:50:09.863Z 2026-04-29T13:08:08.412Z
9772671 9772671 20260423033552_opgYu BR000S 2026-04-25T12:50:08.731Z 2026-04-29T13:08:08.064Z
9772657 9772657 20260423032558_rFPoa BR000S 2026-04-25T12:50:01.891Z 2026-04-29T13:08:06.735Z
9772622 9772622 20260423025213_PTbE3 BR000S 2026-04-25T12:49:50.143Z 2026-04-29T13:07:35.275Z
9772553 9772553 20260423022238_WL286 BR000S 2026-04-25T12:48:54.101Z 2026-04-29T13:07:06.432Z
9772417 9772417 20260423005457_RjLep BR000S 2026-04-25T12:46:47.566Z 2026-04-29T13:05:51.671Z
9772407 9772407 20260423004831_3gNMs BR000S 2026-04-25T12:46:28.553Z 2026-04-29T13:05:49.602Z
9772205 9772205 20260422215127_3Bosq BR000S 2026-04-25T12:43:02.373Z 2026-04-29T13:03:43.546Z
9770880 9770880 20260424060425_A1D6k BR000S 2026-04-25T12:33:31.316Z 2026-04-25T12:59:22.699Z
9770874 9770874 20260424060045_zMKVo BR000S 2026-04-25T12:33:22.494Z 2026-04-29T12:58:24.587Z
9770676 9770676 20260424041925_eKacG BR000S 2026-04-25T12:32:40.033Z 2026-04-29T12:58:20.279Z
9770642 9770642 20260424040626_N4PuT BR000S 2026-04-25T12:32:35.582Z 2026-04-25T12:59:22.508Z
9770244 9770244 20260424030426_7w3l9 BR000S 2026-04-25T12:31:38.459Z 2026-04-29T12:58:13.008Z
9769344 9769344 20260424021219_VxIBU BR000S 2026-04-25T12:29:40.619Z 2026-04-29T12:57:39.259Z
9766346 9766346 20260423233901_btBcm BR000S 2026-04-25T12:21:43.079Z 2026-04-29T12:55:50.414Z
9739126 9739126 20260422025149_ST2M2 BR000S 2026-04-23T12:23:32.308Z 2026-04-29T13:15:16.517Z
9738892 9738892 20260422024131_mmqtJ BR000S 2026-04-23T12:23:00.162Z 2026-04-29T13:15:14.877Z
9738878 9738878 20260422024047_oicqI BR000S 2026-04-23T12:22:58.766Z 2026-04-29T13:15:14.640Z
9737051 9737051 20260422013047_WIP1e BR000S 2026-04-23T12:19:47.480Z 2026-04-29T13:14:28.663Z
9735989 9735989 20260422004427_0diOG BR000S 2026-04-23T12:17:47.496Z 2026-04-29T13:13:47.285Z
9726145 9726145 20260421001738_Kv620 BR000S 2026-04-22T12:18:57.597Z 2026-04-29T13:20:21.064Z
9725010 9725010 20260420224703_k141W BR000S 2026-04-22T12:15:49.999Z 2026-04-29T13:19:25.932Z
9721165 9721165 20260420044315_oxstZ BR000S 2026-04-21T12:29:40.944Z 2026-04-28T13:39:28.616Z
9721161 9721161 20260420044010_q8OqP BR000S 2026-04-21T12:29:40.081Z 2026-04-28T13:39:28.554Z
9721124 9721124 20260420041617_lboSQ BR000S 2026-04-21T12:29:19.639Z 2026-04-28T13:39:28.002Z
9720126 9720126 20260420022101_uLTEI BR000S 2026-04-21T12:26:56.905Z 2026-04-28T13:39:13.789Z
9720030 9720030 20260420020739_5w6jc BR000S 2026-04-21T12:26:46.292Z 2026-04-28T13:38:57.738Z
9719922 9719922 20260420020107_jorNu BR000S 2026-04-21T12:26:25.378Z 2026-04-28T13:38:47.451Z
9719870 9719870 20260420015650_UUdBh BR000S 2026-04-21T12:26:17.315Z 2026-04-28T13:38:37.991Z
9719279 9719279 20260420010708_MyjA9 BR000S 2026-04-21T12:24:46.745Z 2026-04-28T13:38:19.810Z
9719186 9719186 20260420005521_G1gNb BR000S 2026-04-21T12:24:32.881Z 2026-04-28T13:38:18.871Z
9719159 9719159 20260420005222_rUos6 BR000S 2026-04-21T12:24:29.826Z 2026-04-28T13:38:18.272Z
9719043 9719043 20260420003910_E22Px BR000S 2026-04-21T12:24:05.656Z 2026-04-28T13:38:16.571Z
9717627 9717627 20260419220514_28PtD BR000S 2026-04-21T12:20:23.032Z 2026-04-28T13:37:12.796Z
9717491 9717491 20260419215120_hwv1K BR000S 2026-04-21T12:19:58.739Z 2026-04-28T13:37:11.200Z
9712560 9712560 20260419075753_3mmQS BR000S 2026-04-20T12:28:12.560Z 2026-04-27T13:50:48.079Z
9712544 9712544 20260419075301_M1PiM BR000S 2026-04-20T12:28:10.835Z 2026-04-27T13:50:45.811Z
9712504 9712504 20260419074058_a7qkO BR000S 2026-04-20T12:27:59.954Z 2026-04-27T13:50:44.158Z
9712493 9712493 20260419073806_cnIJx BR000S 2026-04-20T12:27:52.941Z 2026-04-27T13:50:43.493Z
9712480 9712480 20260419073508_oyuhq BR000S 2026-04-20T12:27:45.715Z 2026-04-27T13:50:43.011Z
9712468 9712468 20260419073108_64l3u BR000S 2026-04-20T12:27:44.093Z 2026-04-27T13:50:42.480Z
9712426 9712426 20260419071544_NRK3Y BR000S 2026-04-20T12:27:36.680Z 2026-04-27T13:50:41.330Z
9712401 9712401 20260419070828_FiZsT BR000S 2026-04-20T12:27:34.726Z 2026-04-27T13:50:40.749Z
9712392 9712392 20260419070022_Sbcjh BR000S 2026-04-20T12:27:33.472Z 2026-04-27T13:50:40.403Z
9712355 9712355 20260419064646_Ma9jF BR000S 2026-04-20T12:27:28.677Z 2026-04-27T13:50:38.666Z
9712350 9712350 20260419064359_PsbPn BR000S 2026-04-20T12:27:28.154Z 2026-04-27T13:50:38.508Z
9712320 9712320 20260419063521_hdHCY BR000S 2026-04-20T12:27:25.315Z 2026-04-27T13:50:37.711Z
9712318 9712318 20260419063112_SWBqk BR000S 2026-04-20T12:27:25.009Z 2026-04-27T13:50:37.640Z
9712271 9712271 20260419061445_btKWA BR000S 2026-04-20T12:27:19.889Z 2026-04-27T13:50:35.888Z
9712032 9712032 20260419044344_EBVkA BR000S 2026-04-20T12:26:35.763Z 2026-04-27T13:50:10.136Z
9712021 9712021 20260419044118_Ih3r2 BR000S 2026-04-20T12:26:34.690Z 2026-04-27T13:50:09.845Z
9712019 9712019 20260419044049_gXLqX BR000S 2026-04-20T12:26:34.436Z 2026-04-27T13:50:09.817Z
9712012 9712012 20260419043928_O2Cgz BR000S 2026-04-20T12:26:33.835Z 2026-04-27T13:50:09.554Z
9711989 9711989 20260419043336_XBRbB BR000S 2026-04-20T12:26:30.274Z 2026-04-27T13:50:08.454Z
9711974 9711974 20260419042825_YsmP6 BR000S 2026-04-20T12:26:29.417Z 2026-04-27T13:50:08.249Z
9711853 9711853 20260419033936_B6AH2 BR000S 2026-04-20T12:26:00.022Z 2026-04-27T13:50:03.866Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network