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

>10,000 rows count all where station_code = "BG0003" 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
9611112 9611112 20260405001330_Y4GPr BG0003 2026-04-06T12:13:01.884Z 2026-04-06T12:16:14.734Z
9585104 9585104 20260325232949_l8Aij BG0003 2026-03-27T12:16:44.851Z 2026-04-03T12:39:49.610Z
9584769 9584769 20260325220224_trhmA BG0003 2026-03-27T12:16:05.377Z 2026-04-03T12:39:40.484Z
9584257 9584257 20260325181126_u2I0T BG0003 2026-03-27T12:14:43.452Z 2026-04-03T12:39:05.502Z
9581269 9581269 20260326024519_uorXQ BG0003 2026-03-27T12:02:35.553Z 2026-04-04T12:38:51.119Z
9580847 9580847 20260326014450_e3FOv BG0003 2026-03-27T12:01:33.030Z 2026-04-04T12:38:31.302Z
9580667 9580667 20260326011453_j9QRU BG0003 2026-03-27T12:01:06.973Z 2026-04-04T12:38:20.200Z
9580542 9580542 20260326005833_izM38 BG0003 2026-03-27T12:00:43.923Z 2026-04-04T12:38:13.347Z
9507404 9507404 20260316220205_8qrfV BG0003 2026-03-18T12:20:24.593Z 2026-03-24T12:41:47.113Z
9507350 9507350 20260316212016_kuYno BG0003 2026-03-18T12:20:19.593Z 2026-03-24T12:41:45.961Z
9501587 9501587 20260315224610_Cnfuf BG0003 2026-03-17T12:25:15.947Z 2026-03-23T12:22:44.967Z
9501501 9501501 20260315222903_rZbYr BG0003 2026-03-17T12:25:05.613Z 2026-03-23T12:22:44.717Z
9501401 9501401 20260315221027_GwV45 BG0003 2026-03-17T12:24:57.161Z 2026-03-23T12:22:44.304Z
9500613 9500613 20260315173911_pvJW2 BG0003 2026-03-17T12:23:22.135Z 2026-03-23T12:22:40.145Z
9494915 9494915 20260316032844_2wQTH BG0003 2026-03-17T12:05:27.772Z 2026-03-24T12:40:51.150Z
9494804 9494804 20260316030602_WFGyr BG0003 2026-03-17T12:05:02.733Z 2026-03-24T12:40:50.276Z
9494605 9494605 20260316023604_X0qRN BG0003 2026-03-17T12:04:21.230Z 2026-03-24T12:40:48.685Z
9494029 9494029 20260316011419_cNN8q BG0003 2026-03-17T12:02:48.322Z 2026-03-24T12:40:44.062Z
9493849 9493849 20260316004742_dB6PJ BG0003 2026-03-17T12:02:14.759Z 2026-03-24T12:40:42.502Z
9493734 9493734 20260316002743_UnXDl BG0003 2026-03-17T12:01:53.722Z 2026-03-24T12:40:41.664Z
9493726 9493726 20260316002644_4aiQy BG0003 2026-03-17T12:01:51.830Z 2026-03-24T12:40:41.607Z
9493710 9493710 20260316002450_32x2U BG0003 2026-03-17T12:01:47.429Z 2026-03-24T12:40:41.396Z
9493650 9493650 20260316001329_LS4F1 BG0003 2026-03-17T12:01:39.600Z 2026-03-24T12:40:41.277Z
9493519 9493519 20260315234031_jcvLq BG0003 2026-03-17T12:01:07.747Z 2026-03-24T12:40:40.365Z
9492036 9492036 20260314183417_NbB3x BG0003 2026-03-16T12:27:54.525Z 2026-03-22T12:42:49.386Z
9485613 9485613 20260315032406_H6Bbl BG0003 2026-03-16T12:06:57.792Z 2026-03-23T12:21:53.103Z
9485504 9485504 20260315031537_TeGQ3 BG0003 2026-03-16T12:06:41.849Z 2026-03-23T12:21:52.540Z
9485348 9485348 20260315025453_6Nvwf BG0003 2026-03-16T12:06:07.322Z 2026-03-23T12:21:51.126Z
9485048 9485048 20260315021901_DSL5u BG0003 2026-03-16T12:05:04.434Z 2026-03-23T12:21:49.691Z
9484946 9484946 20260315020311_GZOoQ BG0003 2026-03-16T12:04:42.771Z 2026-03-23T12:21:49.116Z
9484840 9484840 20260315014657_M0Run BG0003 2026-03-16T12:04:18.774Z 2026-03-23T12:21:48.652Z
9484827 9484827 20260315014417_qXzqN BG0003 2026-03-16T12:04:15.009Z 2026-03-23T12:21:48.531Z
9484708 9484708 20260315013149_WcgBP BG0003 2026-03-16T12:03:51.644Z 2026-03-23T12:21:48.074Z
9484431 9484431 20260315003909_Be3yn BG0003 2026-03-16T12:02:52.143Z 2026-03-23T12:21:46.767Z
9484149 9484149 20260314235628_3pKw4 BG0003 2026-03-16T12:01:43.014Z 2026-03-23T12:21:45.593Z
9484117 9484117 20260314235134_S8M49 BG0003 2026-03-16T12:01:35.908Z 2026-03-23T12:21:45.454Z
9483851 9483851 20260314232111_Z6khp BG0003 2026-03-16T12:00:52.495Z 2026-03-23T12:21:44.288Z
9483504 9483504 20260313222638_PjPT0 BG0003 2026-03-15T12:26:36.642Z 2026-03-21T12:50:28.161Z
9483346 9483346 20260313214707_xftCX BG0003 2026-03-15T12:26:17.521Z 2026-03-21T12:50:26.986Z
9482956 9482956 20260313200121_HpElC BG0003 2026-03-15T12:25:38.396Z 2026-03-21T12:50:12.270Z
9482930 9482930 20260313195117_v25Ua BG0003 2026-03-15T12:25:35.009Z 2026-03-21T12:50:10.571Z
9482854 9482854 20260313192146_eX5lE BG0003 2026-03-15T12:25:21.279Z 2026-03-21T12:50:02.811Z
9476321 9476321 20260314025424_NNVI2 BG0003 2026-03-15T12:05:36.662Z 2026-03-22T12:41:55.799Z
9476290 9476290 20260314025223_I3R9Z BG0003 2026-03-15T12:05:30.999Z 2026-03-22T12:41:55.620Z
9475684 9475684 20260314015418_wuPKp BG0003 2026-03-15T12:03:51.044Z 2026-03-22T12:41:49.018Z
9475550 9475550 20260314014002_8B6x6 BG0003 2026-03-15T12:03:25.781Z 2026-03-22T12:41:42.146Z
9475461 9475461 20260314012958_owmyI BG0003 2026-03-15T12:03:13.232Z 2026-03-22T12:41:39.273Z
9475126 9475126 20260314004518_6rJzf BG0003 2026-03-15T12:02:19.605Z 2026-03-22T12:41:27.173Z
9474764 9474764 20260313235127_QNVZj BG0003 2026-03-15T12:01:17.581Z 2026-03-22T12:41:24.004Z
9474337 9474337 20260312223846_0gbn1 BG0003 2026-03-14T12:22:39.036Z 2026-03-20T12:37:18.417Z
9474301 9474301 20260312222737_gruDI BG0003 2026-03-14T12:22:31.406Z 2026-03-20T12:37:17.447Z
9469538 9469538 20260313030606_JWo92 BG0003 2026-03-14T12:04:38.879Z 2026-03-21T12:48:41.377Z
9469479 9469479 20260313025600_qYh1c BG0003 2026-03-14T12:04:25.095Z 2026-03-21T12:48:40.246Z
9469077 9469077 20260313014219_o22Um BG0003 2026-03-14T12:02:52.942Z 2026-03-21T12:48:33.243Z
9468815 9468815 20260313004714_lAU6q BG0003 2026-03-14T12:01:53.415Z 2026-03-21T12:48:29.446Z
9468752 9468752 20260313003220_koBjO BG0003 2026-03-14T12:01:38.334Z 2026-03-21T12:48:28.697Z
9468712 9468712 20260313002357_ULspy BG0003 2026-03-14T12:01:29.183Z 2026-03-21T12:48:28.260Z
9468644 9468644 20260313000413_ghIcV BG0003 2026-03-14T12:01:08.307Z 2026-03-21T12:48:27.344Z
9468599 9468599 20260312235134_3LmXs BG0003 2026-03-14T12:00:55.985Z 2026-03-21T12:48:26.849Z
9466946 9466946 20260311190525_wgD3H BG0003 2026-03-13T12:17:46.247Z 2026-03-19T12:45:45.053Z
9463829 9463829 20260312025125_1u9mO BG0003 2026-03-13T12:05:22.370Z 2026-03-20T12:36:25.101Z
9463481 9463481 20260312015755_01ckJ BG0003 2026-03-13T12:04:20.268Z 2026-03-20T12:36:22.896Z
9463469 9463469 20260312015359_WFoDx BG0003 2026-03-13T12:04:17.610Z 2026-03-20T12:36:22.779Z
9463161 9463161 20260312010838_HEPsp BG0003 2026-03-13T12:03:17.607Z 2026-03-20T12:36:20.106Z
9463058 9463058 20260312005906_D82x2 BG0003 2026-03-13T12:03:00.837Z 2026-03-20T12:36:19.564Z
9460817 9460817 20260310223803_LxSds BG0003 2026-03-12T12:15:10.935Z 2026-03-18T12:40:19.954Z
9460759 9460759 20260310221318_S7IHh BG0003 2026-03-12T12:15:03.850Z 2026-03-18T12:40:19.060Z
9460748 9460748 20260310221034_dKwSx BG0003 2026-03-12T12:15:02.377Z 2026-03-18T12:40:18.905Z
9460735 9460735 20260310220952_rEJfQ BG0003 2026-03-12T12:15:01.026Z 2026-03-18T12:40:18.679Z
9460683 9460683 20260310213854_Q7iiu BG0003 2026-03-12T12:14:54.223Z 2026-03-18T12:40:17.879Z
9460505 9460505 20260310200825_Rzd5h BG0003 2026-03-12T12:14:24.310Z 2026-03-18T12:40:03.273Z
9460368 9460368 20260310183846_PbXEQ BG0003 2026-03-12T12:13:51.063Z 2026-03-18T12:39:54.728Z
9457315 9457315 20260311032718_o2F6G BG0003 2026-03-12T12:03:32.445Z 2026-03-19T12:44:37.538Z
9457293 9457293 20260311032227_c032w BG0003 2026-03-12T12:03:29.319Z 2026-03-19T12:44:36.919Z
9457146 9457146 20260311024612_Sn498 BG0003 2026-03-12T12:03:00.046Z 2026-03-19T12:44:29.396Z
9457105 9457105 20260311023725_wiLXx BG0003 2026-03-12T12:02:52.978Z 2026-03-19T12:44:26.718Z
9456945 9456945 20260311015055_UdzC3 BG0003 2026-03-12T12:02:19.281Z 2026-03-19T12:44:23.990Z
9456776 9456776 20260311005716_vGEv2 BG0003 2026-03-12T12:01:45.566Z 2026-03-19T12:44:21.794Z
9456748 9456748 20260311004456_xQjyz BG0003 2026-03-12T12:01:40.174Z 2026-03-19T12:44:21.544Z
9456735 9456735 20260311004252_TXZAr BG0003 2026-03-12T12:01:38.005Z 2026-03-19T12:44:21.368Z
9456686 9456686 20260311002621_M9W1g BG0003 2026-03-12T12:01:25.774Z 2026-03-19T12:44:20.815Z
9456604 9456604 20260311001009_SRQFK BG0003 2026-03-12T12:01:14.115Z 2026-03-19T12:44:19.070Z
9456029 9456029 20260309212906_Ao0dx BG0003 2026-03-11T12:15:31.485Z 2026-03-17T12:42:47.412Z
9455989 9455989 20260309211916_8frTN BG0003 2026-03-11T12:15:23.442Z 2026-03-17T12:42:45.204Z
9455756 9455756 20260309200553_9Ww3s BG0003 2026-03-11T12:14:54.774Z 2026-03-17T12:42:38.688Z
9455521 9455521 20260309181732_ITmlY BG0003 2026-03-11T12:14:30.398Z 2026-03-17T12:42:33.982Z
9455507 9455507 20260309180205_CnpgC BG0003 2026-03-11T12:14:25.904Z 2026-03-17T12:42:33.579Z
9455499 9455499 20260309174252_hH3pX BG0003 2026-03-11T12:14:25.019Z 2026-03-17T12:42:33.508Z
9451598 9451598 20260310030027_B3qvA BG0003 2026-03-11T12:03:17.369Z 2026-03-18T12:38:58.634Z
9451548 9451548 20260310024747_wfb3K BG0003 2026-03-11T12:03:08.597Z 2026-03-18T12:38:49.236Z
9451387 9451387 20260310020234_2luCv BG0003 2026-03-11T12:02:39.390Z 2026-03-18T12:38:45.713Z
9451057 9451057 20260310003418_BnkT9 BG0003 2026-03-11T12:01:35.255Z 2026-03-18T12:38:39.908Z
9450845 9450845 20260309233252_QDtaA BG0003 2026-03-11T12:00:53.754Z 2026-03-18T12:38:36.752Z
9450757 9450757 20260309230158_qY8U4 BG0003 2026-03-11T12:00:33.472Z 2026-03-18T12:38:35.271Z
9450695 9450695 20260309224401_x2Of1 BG0003 2026-03-11T12:00:16.780Z 2026-03-18T12:38:34.007Z
9450480 9450480 20260308220031_1FEoP BG0003 2026-03-10T12:19:46.232Z 2026-03-16T12:44:43.300Z
9450434 9450434 20260308213103_L3YUE BG0003 2026-03-10T12:19:39.034Z 2026-03-16T12:44:42.494Z
9446899 9446899 20260309033159_1wqGj BG0003 2026-03-10T12:04:24.528Z 2026-03-17T12:41:44.477Z
9446820 9446820 20260309030807_iEC3A BG0003 2026-03-10T12:04:03.827Z 2026-03-17T12:41:43.339Z
9446505 9446505 20260309015350_SSh1p BG0003 2026-03-10T12:02:42.950Z 2026-03-17T12:41:39.134Z

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