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

6,985 rows where station_code = "GR0004" 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
9598580 9598580 20260330012337_wZipK GR0004 2026-03-31T12:10:58.259Z 2026-04-06T12:36:47.077Z
9598494 9598494 20260330004541_Uavsy GR0004 2026-03-31T12:10:45.837Z 2026-04-06T12:36:35.467Z
9598435 9598435 20260330001257_0Z3AL GR0004 2026-03-31T12:10:36.294Z 2026-04-06T12:36:32.490Z
9598402 9598402 20260329234850_2Kkm6 GR0004 2026-03-31T12:10:32.682Z 2026-04-06T12:36:31.191Z
9595211 9595211 20260330030503_5GC9L GR0004 2026-03-31T12:00:48.263Z 2026-04-06T12:29:48.387Z
9595150 9595150 20260330024005_2ex7P GR0004 2026-03-31T12:00:37.354Z 2026-04-06T12:29:43.021Z
9595137 9595137 20260330023318_UI8yU GR0004 2026-03-31T12:00:34.930Z 2026-04-06T12:29:42.131Z
9581335 9581335 20260326025429_Cv1ij GR0004 2026-03-27T12:02:46.255Z 2026-04-04T12:38:53.094Z
9580810 9580810 20260326013743_LrB0o GR0004 2026-03-27T12:01:28.870Z 2026-04-04T12:38:30.268Z
9580493 9580493 20260326005548_1wD8P GR0004 2026-03-27T12:00:38.380Z 2026-04-04T12:38:12.244Z
9580412 9580412 20260326004630_Skv6V GR0004 2026-03-27T12:00:24.943Z 2026-04-04T12:38:09.256Z
9500694 9500694 20260315182801_amFwp GR0004 2026-03-17T12:23:39.018Z 2026-03-23T12:22:40.875Z
9500682 9500682 20260315182241_b2m1c GR0004 2026-03-17T12:23:37.818Z 2026-03-23T12:22:40.840Z
9492870 9492870 20260314220740_l4YR3 GR0004 2026-03-16T12:29:07.073Z 2026-03-22T12:42:55.499Z
9492324 9492324 20260314202129_1d7D5 GR0004 2026-03-16T12:28:23.060Z 2026-03-22T12:42:51.639Z
9492043 9492043 20260314184927_KNpys GR0004 2026-03-16T12:27:56.362Z 2026-03-22T12:42:49.622Z
9485633 9485633 20260315033227_4UoKn GR0004 2026-03-16T12:07:03.546Z 2026-03-23T12:21:53.182Z
9485489 9485489 20260315031332_u2o4N GR0004 2026-03-16T12:06:36.809Z 2026-03-23T12:21:52.457Z
9485149 9485149 20260315023431_YLXmn GR0004 2026-03-16T12:05:26.767Z 2026-03-23T12:21:50.175Z
9484880 9484880 20260315015316_Yee6A GR0004 2026-03-16T12:04:30.297Z 2026-03-23T12:21:48.819Z
9484788 9484788 20260315014151_VGGuM GR0004 2026-03-16T12:04:08.950Z 2026-03-23T12:21:48.413Z
9484665 9484665 20260315012401_NcyBJ GR0004 2026-03-16T12:03:41.702Z 2026-03-23T12:21:47.774Z
9484285 9484285 20260315001450_yhVhq GR0004 2026-03-16T12:02:18.667Z 2026-03-23T12:21:46.154Z
9484199 9484199 20260315000421_UZiaC GR0004 2026-03-16T12:01:56.613Z 2026-03-23T12:21:45.818Z
9483799 9483799 20260314231722_W5KWD GR0004 2026-03-16T12:00:44.604Z 2026-03-23T12:21:44.083Z
9483779 9483779 20260314231618_31MzI GR0004 2026-03-16T12:00:39.897Z 2026-03-23T12:21:43.982Z
9476737 9476737 20260314033744_ODEKs GR0004 2026-03-15T12:06:44.743Z 2026-03-22T12:41:58.939Z
9476570 9476570 20260314031606_PoVrg GR0004 2026-03-15T12:06:21.770Z 2026-03-22T12:41:57.863Z
9476475 9476475 20260314031106_53hVy GR0004 2026-03-15T12:06:06.535Z 2026-03-22T12:41:57.022Z
9476376 9476376 20260314030017_1mZJN GR0004 2026-03-15T12:05:47.338Z 2026-03-22T12:41:56.306Z
9475749 9475749 20260314020141_xjwhq GR0004 2026-03-15T12:04:00.033Z 2026-03-22T12:41:50.824Z
9475648 9475648 20260314015110_hhzoz GR0004 2026-03-15T12:03:43.158Z 2026-03-22T12:41:46.559Z
9475575 9475575 20260314014220_vjT5G GR0004 2026-03-15T12:03:30.378Z 2026-03-22T12:41:43.354Z
9475302 9475302 20260314011034_HSIjN GR0004 2026-03-15T12:02:48.800Z 2026-03-22T12:41:32.353Z
9474670 9474670 20260313233539_YqaqJ GR0004 2026-03-15T12:00:54.633Z 2026-03-22T12:41:23.145Z
9474338 9474338 20260312223853_tRzLR GR0004 2026-03-14T12:22:39.176Z 2026-03-20T12:37:18.438Z
9474316 9474316 20260312223136_eyD0P GR0004 2026-03-14T12:22:37.047Z 2026-03-20T12:37:17.834Z
9474309 9474309 20260312222839_2TP2j GR0004 2026-03-14T12:22:36.132Z 2026-03-20T12:37:17.768Z
9469608 9469608 20260313031734_rJBTC GR0004 2026-03-14T12:04:56.457Z 2026-03-21T12:48:48.345Z
9469447 9469447 20260313025030_SLwF0 GR0004 2026-03-14T12:04:18.112Z 2026-03-21T12:48:39.538Z
9469338 9469338 20260313023033_AYWSP GR0004 2026-03-14T12:03:54.930Z 2026-03-21T12:48:37.650Z
9467582 9467582 20260311221547_vuSAI GR0004 2026-03-13T12:19:32.604Z 2026-03-19T12:45:53.518Z
9467488 9467488 20260311215555_y3Fcg GR0004 2026-03-13T12:19:19.324Z 2026-03-19T12:45:52.701Z
9467251 9467251 20260311205907_h1GUx GR0004 2026-03-13T12:18:51.835Z 2026-03-19T12:45:50.929Z
9463699 9463699 20260312022904_85kht GR0004 2026-03-13T12:04:54.713Z 2026-03-20T12:36:24.142Z
9463466 9463466 20260312015346_Gx3G8 GR0004 2026-03-13T12:04:17.294Z 2026-03-20T12:36:22.754Z
9463432 9463432 20260312014758_2qRQM GR0004 2026-03-13T12:04:08.343Z 2026-03-20T12:36:22.525Z
9463406 9463406 20260312014552_JSYKL GR0004 2026-03-13T12:04:03.079Z 2026-03-20T12:36:22.374Z
9463231 9463231 20260312011900_extth GR0004 2026-03-13T12:03:33.944Z 2026-03-20T12:36:21.394Z
9462839 9462839 20260312002246_Fhv42 GR0004 2026-03-13T12:02:19.865Z 2026-03-20T12:36:18.375Z
9462465 9462465 20260311232239_7oWB4 GR0004 2026-03-13T12:01:05.643Z 2026-03-20T12:36:16.148Z
9456808 9456808 20260311010155_H8yPk GR0004 2026-03-12T12:01:51.123Z 2026-03-19T12:44:22.240Z
9456709 9456709 20260311003115_2e4wF GR0004 2026-03-12T12:01:31.989Z 2026-03-19T12:44:21.026Z
9456701 9456701 20260311003025_ylLwv GR0004 2026-03-12T12:01:30.557Z 2026-03-19T12:44:20.948Z
9456598 9456598 20260311000827_81VOF GR0004 2026-03-12T12:01:12.378Z 2026-03-19T12:44:18.938Z
9456394 9456394 20260310231241_WFPsA GR0004 2026-03-12T12:00:31.147Z 2026-03-19T12:44:16.573Z
9456228 9456228 20260309222402_Ennhx GR0004 2026-03-11T12:15:52.463Z 2026-03-17T12:42:59.423Z
9456188 9456188 20260309221121_BP2Lr GR0004 2026-03-11T12:15:48.401Z 2026-03-17T12:42:57.725Z
9455688 9455688 20260309194044_1iApW GR0004 2026-03-11T12:14:47.549Z 2026-03-17T12:42:37.650Z
9415694 9415694 20260302031406_V0s6C GR0004 2026-03-03T14:01:12.789Z 2026-03-10T12:35:48.042Z
9402558 9402558 20260227040537_F61wM GR0004 2026-02-28T14:05:15.620Z 2026-03-07T14:46:52.239Z
9402444 9402444 20260227035236_SRBSV GR0004 2026-02-28T14:04:54.631Z 2026-03-07T14:46:47.922Z
9402150 9402150 20260227030143_mYljL GR0004 2026-02-28T14:03:45.682Z 2026-03-07T14:46:27.863Z
9402029 9402029 20260227023233_Aphf5 GR0004 2026-02-28T14:03:15.713Z 2026-03-07T14:46:20.154Z
9401804 9401804 20260227014024_D6iJ9 GR0004 2026-02-28T14:02:18.655Z 2026-03-07T14:46:09.169Z
9401794 9401794 20260227013552_dTW57 GR0004 2026-02-28T14:02:15.069Z 2026-03-07T14:46:04.292Z
9401790 9401790 20260227013527_pgaOS GR0004 2026-02-28T14:02:13.823Z 2026-03-07T14:46:03.901Z
9401753 9401753 20260227012746_MYhhO GR0004 2026-02-28T14:02:06.246Z 2026-03-07T14:46:02.267Z
9401551 9401551 20260227003051_IPhFv GR0004 2026-02-28T14:01:15.270Z 2026-03-07T14:45:50.991Z
9401447 9401447 20260226235314_xbWbg GR0004 2026-02-28T14:00:44.774Z 2026-03-07T14:45:44.963Z
9401365 9401365 20260226231033_T34Xv GR0004 2026-02-28T14:00:15.505Z 2026-03-07T14:45:40.579Z
9401133 9401133 20260225222150_gafdU GR0004 2026-02-27T14:16:28.618Z 2026-03-05T14:39:07.487Z
9400847 9400847 20260225210001_TsUTK GR0004 2026-02-27T14:15:53.252Z 2026-03-05T14:38:52.621Z
9400579 9400579 20260225185321_zhZSS GR0004 2026-02-27T14:14:58.522Z 2026-03-05T14:38:36.207Z
9400553 9400553 20260225183831_lt6ka GR0004 2026-02-27T14:14:51.776Z 2026-03-05T14:38:30.139Z
9398750 9398750 20260226040704_Cai2X GR0004 2026-02-27T14:06:04.686Z 2026-03-06T14:43:56.739Z
9398626 9398626 20260226035653_7c2xA GR0004 2026-02-27T14:05:46.525Z 2026-03-06T14:43:54.173Z
9398608 9398608 20260226035457_k4Rn2 GR0004 2026-02-27T14:05:44.493Z 2026-03-06T14:43:53.787Z
9398374 9398374 20260226033220_xbxly GR0004 2026-02-27T14:05:10.006Z 2026-03-06T14:43:41.809Z
9397783 9397783 20260226022249_hvrCM GR0004 2026-02-27T14:03:26.298Z 2026-03-06T14:43:19.829Z
9397535 9397535 20260226015445_p3kGJ GR0004 2026-02-27T14:02:45.592Z 2026-03-06T14:43:12.977Z
9397499 9397499 20260226015128_szYM0 GR0004 2026-02-27T14:02:38.643Z 2026-03-06T14:43:11.854Z
9396971 9396971 20260225235944_V9vEy GR0004 2026-02-27T14:00:55.308Z 2026-03-06T14:42:51.275Z
9395235 9395235 20260224231511_nuUGU GR0004 2026-02-26T14:21:13.617Z 2026-03-04T14:19:31.818Z
9392183 9392183 20260225035051_45fZh GR0004 2026-02-26T14:06:42.176Z 2026-03-05T14:36:51.043Z
9391736 9391736 20260225031050_KIOds GR0004 2026-02-26T14:05:12.270Z 2026-03-05T14:36:29.277Z
9391584 9391584 20260225025703_9M1UJ GR0004 2026-02-26T14:04:46.939Z 2026-03-05T14:36:24.960Z
9386296 9386296 20260223205352_x7mDd GR0004 2026-02-25T14:17:50.124Z 2026-03-03T14:32:48.797Z
9383282 9383282 20260224024832_gO4bj GR0004 2026-02-25T14:00:50.514Z 2026-03-04T14:17:37.258Z
9383270 9383270 20260224023956_zfOxW GR0004 2026-02-25T14:00:48.271Z 2026-03-04T14:17:37.088Z
9383266 9383266 20260224023920_aziy3 GR0004 2026-02-25T14:00:47.097Z 2026-03-04T14:17:37.008Z
9381545 9381545 20260222230917_GpuKm GR0004 2026-02-24T14:24:53.104Z 2026-02-24T14:24:53.104Z
9381443 9381443 20260222223623_OX3Nd GR0004 2026-02-24T14:24:45.191Z 2026-02-24T14:24:45.191Z
9381440 9381440 20260222223531_UNnrI GR0004 2026-02-24T14:24:44.879Z 2026-02-24T14:24:44.879Z
9381355 9381355 20260222215934_2bbja GR0004 2026-02-24T14:24:34.301Z 2026-02-24T14:24:34.301Z
9381236 9381236 20260222212222_dhfbe GR0004 2026-02-24T14:24:26.343Z 2026-02-24T14:24:26.343Z
9381207 9381207 20260222211410_wVVaH GR0004 2026-02-24T14:24:24.346Z 2026-02-24T14:24:24.346Z
9380574 9380574 20260222200001_kF5gB GR0004 2026-02-24T14:23:27.943Z 2026-02-24T14:23:27.943Z
9379519 9379519 20260222172059_jU1Yr GR0004 2026-02-24T14:21:40.181Z 2026-02-24T14:21:40.181Z
9373730 9373730 20260223041230_BKsBp GR0004 2026-02-24T14:03:49.208Z 2026-03-03T14:31:08.850Z

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