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

4,588 rows where station_code = "GR0008" 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
9608366 9608366 20260403223508_EpewZ GR0008 2026-04-05T12:10:15.301Z 2026-04-06T12:20:08.539Z
9598582 9598582 20260330012337_wZipK GR0008 2026-03-31T12:10:58.259Z 2026-04-06T12:36:47.077Z
9598449 9598449 20260330002118_75hJd GR0008 2026-03-31T12:10:37.884Z 2026-04-06T12:36:32.965Z
9598437 9598437 20260330001257_0Z3AL GR0008 2026-03-31T12:10:36.294Z 2026-04-06T12:36:32.490Z
9598252 9598252 20260329213358_KcH34 GR0008 2026-03-31T12:10:06.440Z 2026-04-06T12:36:20.480Z
9595083 9595083 20260330021542_W663I GR0008 2026-03-31T12:00:25.151Z 2026-04-06T12:29:39.627Z
9595023 9595023 20260330014040_sUDnz GR0008 2026-03-31T12:00:13.183Z 2026-04-06T12:29:35.468Z
9584930 9584930 20260325224804_sbhme GR0008 2026-03-27T12:16:23.917Z 2026-04-03T12:39:44.636Z
9584770 9584770 20260325220224_trhmA GR0008 2026-03-27T12:16:05.377Z 2026-04-03T12:39:40.485Z
9581134 9581134 20260326022756_UvOZb GR0008 2026-03-27T12:02:13.158Z 2026-04-04T12:38:43.689Z
9581102 9581102 20260326022348_pMUxb GR0008 2026-03-27T12:02:08.781Z 2026-04-04T12:38:42.834Z
9581001 9581001 20260326020805_2Mooa GR0008 2026-03-27T12:01:52.996Z 2026-04-04T12:38:39.202Z
9580550 9580550 20260326010029_MssLQ GR0008 2026-03-27T12:00:46.268Z 2026-04-04T12:38:13.835Z
9580414 9580414 20260326004630_Skv6V GR0008 2026-03-27T12:00:24.961Z 2026-04-04T12:38:09.256Z
9576033 9576033 20260325010159_2awtF GR0008 2026-03-26T12:01:02.593Z 2026-04-03T12:35:41.572Z
9571280 9571280 20260324005051_gCYnc GR0008 2026-03-25T12:00:46.898Z 2026-04-02T12:34:17.571Z
9501567 9501567 20260315224223_pWgtV GR0008 2026-03-17T12:25:14.621Z 2026-03-23T12:22:44.898Z
9501351 9501351 20260315220321_WvBzM GR0008 2026-03-17T12:24:51.862Z 2026-03-23T12:22:44.060Z
9501291 9501291 20260315214708_L8qpT GR0008 2026-03-17T12:24:47.536Z 2026-03-23T12:22:43.863Z
9500852 9500852 20260315194638_wzfqz GR0008 2026-03-17T12:24:00.131Z 2026-03-23T12:22:41.959Z
9493713 9493713 20260316002450_32x2U GR0008 2026-03-17T12:01:47.430Z 2026-03-24T12:40:41.396Z
9493368 9493368 20260315231602_sR0Wu GR0008 2026-03-17T12:00:35.162Z 2026-03-24T12:40:39.026Z
9493280 9493280 20260315230036_hu3pZ GR0008 2026-03-17T12:00:12.153Z 2026-03-24T12:40:38.282Z
9493020 9493020 20260314223202_JUgLt GR0008 2026-03-16T12:29:17.198Z 2026-03-22T12:42:56.371Z
9492234 9492234 20260314194741_w3qky GR0008 2026-03-16T12:28:10.563Z 2026-03-22T12:42:51.059Z
9485491 9485491 20260315031332_u2o4N GR0008 2026-03-16T12:06:36.809Z 2026-03-23T12:21:52.457Z
9485350 9485350 20260315025453_6Nvwf GR0008 2026-03-16T12:06:07.322Z 2026-03-23T12:21:51.126Z
9485151 9485151 20260315023431_YLXmn GR0008 2026-03-16T12:05:26.767Z 2026-03-23T12:21:50.175Z
9485055 9485055 20260315021931_YBqnD GR0008 2026-03-16T12:05:06.430Z 2026-03-23T12:21:49.775Z
9484790 9484790 20260315014151_VGGuM GR0008 2026-03-16T12:04:08.950Z 2026-03-23T12:21:48.413Z
9484578 9484578 20260315010503_tFG6O GR0008 2026-03-16T12:03:21.729Z 2026-03-23T12:21:47.354Z
9484572 9484572 20260315010310_KILGw GR0008 2026-03-16T12:03:20.078Z 2026-03-23T12:21:47.298Z
9484526 9484526 20260315005532_sHL3R GR0008 2026-03-16T12:03:12.498Z 2026-03-23T12:21:47.201Z
9484119 9484119 20260314235134_S8M49 GR0008 2026-03-16T12:01:35.908Z 2026-03-23T12:21:45.454Z
9483617 9483617 20260314225642_pEor2 GR0008 2026-03-16T12:00:13.234Z 2026-03-23T12:21:43.283Z
9475882 9475882 20260314021623_cM8l4 GR0008 2026-03-15T12:04:23.773Z 2026-03-22T12:41:52.532Z
9475650 9475650 20260314015110_hhzoz GR0008 2026-03-15T12:03:43.158Z 2026-03-22T12:41:46.559Z
9474191 9474191 20260312213005_B8AQ9 GR0008 2026-03-14T12:22:17.086Z 2026-03-20T12:37:16.680Z
9469021 9469021 20260313013156_AKcg9 GR0008 2026-03-14T12:02:40.971Z 2026-03-21T12:48:32.583Z
9467591 9467591 20260311221917_nq6MQ GR0008 2026-03-13T12:19:33.719Z 2026-03-19T12:45:53.644Z
9467490 9467490 20260311215555_y3Fcg GR0008 2026-03-13T12:19:19.324Z 2026-03-19T12:45:52.701Z
9467428 9467428 20260311214256_gwioi GR0008 2026-03-13T12:19:13.397Z 2026-03-19T12:45:52.277Z
9467125 9467125 20260311201435_fTY0E GR0008 2026-03-13T12:18:27.153Z 2026-03-19T12:45:48.595Z
9463961 9463961 20260312031032_0GIKG GR0008 2026-03-13T12:05:44.001Z 2026-03-20T12:36:25.947Z
9463901 9463901 20260312030227_WPA43 GR0008 2026-03-13T12:05:34.537Z 2026-03-20T12:36:25.536Z
9463835 9463835 20260312025213_3ZxT1 GR0008 2026-03-13T12:05:23.501Z 2026-03-20T12:36:25.196Z
9463434 9463434 20260312014758_2qRQM GR0008 2026-03-13T12:04:08.343Z 2026-03-20T12:36:22.525Z
9460590 9460590 20260310205703_OzO6j GR0008 2026-03-12T12:14:37.771Z 2026-03-18T12:40:15.839Z
9460508 9460508 20260310200825_Rzd5h GR0008 2026-03-12T12:14:24.310Z 2026-03-18T12:40:03.273Z
9460355 9460355 20260310182553_ZElEB GR0008 2026-03-12T12:13:46.668Z 2026-03-18T12:39:52.954Z
9460320 9460320 20260310172501_s260R GR0008 2026-03-12T12:13:35.471Z 2026-03-18T12:39:50.248Z
9457198 9457198 20260311025934_NTjoF GR0008 2026-03-12T12:03:08.593Z 2026-03-19T12:44:31.577Z
9457169 9457169 20260311025534_U41dh GR0008 2026-03-12T12:03:04.242Z 2026-03-19T12:44:30.734Z
9456950 9456950 20260311015155_S4SO1 GR0008 2026-03-12T12:02:20.154Z 2026-03-19T12:44:24.044Z
9456928 9456928 20260311014521_DxEeg GR0008 2026-03-12T12:02:13.683Z 2026-03-19T12:44:23.723Z
9456693 9456693 20260311002756_po9AY GR0008 2026-03-12T12:01:27.235Z 2026-03-19T12:44:20.866Z
9456625 9456625 20260311001625_MsxOo GR0008 2026-03-12T12:01:17.474Z 2026-03-19T12:44:19.258Z
9456615 9456615 20260311001234_FTayC GR0008 2026-03-12T12:01:15.743Z 2026-03-19T12:44:19.177Z
9456396 9456396 20260310231241_WFPsA GR0008 2026-03-12T12:00:31.155Z 2026-03-19T12:44:16.573Z
9456230 9456230 20260309222402_Ennhx GR0008 2026-03-11T12:15:52.463Z 2026-03-17T12:42:59.423Z
9456167 9456167 20260309220259_qooMh GR0008 2026-03-11T12:15:46.302Z 2026-03-17T12:42:56.991Z
9455980 9455980 20260309211544_2qhEf GR0008 2026-03-11T12:15:22.543Z 2026-03-17T12:42:44.737Z
9455956 9455956 20260309210758_qJGgn GR0008 2026-03-11T12:15:19.345Z 2026-03-17T12:42:42.693Z
9455920 9455920 20260309210256_kbqWq GR0008 2026-03-11T12:15:15.071Z 2026-03-17T12:42:40.622Z
9455749 9455749 20260309200301_J4EjA GR0008 2026-03-11T12:14:54.015Z 2026-03-17T12:42:38.528Z
9455548 9455548 20260309183826_gir0y GR0008 2026-03-11T12:14:32.735Z 2026-03-17T12:42:34.449Z
9451794 9451794 20260310035502_g3urr GR0008 2026-03-11T12:03:51.169Z 2026-03-18T12:39:04.654Z
9451764 9451764 20260310034214_UELSv GR0008 2026-03-11T12:03:46.591Z 2026-03-18T12:39:04.126Z
9451415 9451415 20260310020646_QcPFC GR0008 2026-03-11T12:02:44.161Z 2026-03-18T12:38:46.094Z
9451271 9451271 20260310013329_PWDTi GR0008 2026-03-11T12:02:19.192Z 2026-03-18T12:38:44.040Z
9451250 9451250 20260310012832_Xxc7L GR0008 2026-03-11T12:02:15.001Z 2026-03-18T12:38:43.790Z
9451126 9451126 20260310004641_VzvPE GR0008 2026-03-11T12:01:48.745Z 2026-03-18T12:38:40.857Z
9451082 9451082 20260310003812_1efdJ GR0008 2026-03-11T12:01:41.460Z 2026-03-18T12:38:40.293Z
9450908 9450908 20260309234841_9K7ip GR0008 2026-03-11T12:01:08.249Z 2026-03-18T12:38:37.785Z
9432167 9432167 20260306034944_FP50u GR0008 2026-03-07T14:03:42.790Z 2026-03-14T12:39:25.981Z
9431596 9431596 20260306004129_uS54H GR0008 2026-03-07T14:01:16.870Z 2026-03-14T12:39:15.007Z
9418781 9418781 20260301215656_PvPMs GR0008 2026-03-03T14:12:21.922Z 2026-03-09T12:41:15.293Z
9415650 9415650 20260302024947_Mlzn2 GR0008 2026-03-03T14:01:03.222Z 2026-03-10T12:35:46.795Z
9415601 9415601 20260302020748_hUbnX GR0008 2026-03-03T14:00:50.818Z 2026-03-10T12:35:45.167Z
9415597 9415597 20260302020712_avJ2a GR0008 2026-03-03T14:00:49.882Z 2026-03-10T12:35:45.084Z
9415579 9415579 20260302013942_dQyYE GR0008 2026-03-03T14:00:45.170Z 2026-03-10T12:35:44.633Z
9415571 9415571 20260302013438_C4Kc4 GR0008 2026-03-03T14:00:43.295Z 2026-03-10T12:35:44.397Z
9415515 9415515 20260302002345_Epp3K GR0008 2026-03-03T14:00:29.387Z 2026-03-10T12:35:43.102Z
9407979 9407979 20260226230109_aA74n GR0008 2026-02-28T14:22:58.337Z 2026-03-06T14:45:25.256Z
9407882 9407882 20260226220014_vbXJu GR0008 2026-02-28T14:22:42.845Z 2026-03-06T14:45:22.442Z
9402589 9402589 20260227040810_ZnMRI GR0008 2026-02-28T14:05:19.966Z 2026-03-07T14:46:53.530Z
9402152 9402152 20260227030143_mYljL GR0008 2026-02-28T14:03:45.682Z 2026-03-07T14:46:27.863Z
9402066 9402066 20260227023835_EB2WX GR0008 2026-02-28T14:03:23.971Z 2026-03-07T14:46:22.122Z
9401664 9401664 20260227010920_mBw62 GR0008 2026-02-28T14:01:43.172Z 2026-03-07T14:45:56.506Z
9401548 9401548 20260227002943_yEscf GR0008 2026-02-28T14:01:13.678Z 2026-03-07T14:45:50.714Z
9401518 9401518 20260227001902_4YV23 GR0008 2026-02-28T14:01:04.237Z 2026-03-07T14:45:48.671Z
9401511 9401511 20260227001501_23dQ3 GR0008 2026-02-28T14:01:02.604Z 2026-03-07T14:45:48.227Z
9400913 9400913 20260225212014_xDv33 GR0008 2026-02-27T14:16:00.518Z 2026-03-05T14:38:54.706Z
9400849 9400849 20260225210001_TsUTK GR0008 2026-02-27T14:15:53.252Z 2026-03-05T14:38:52.621Z
9400729 9400729 20260225200524_WdZkk GR0008 2026-02-27T14:15:29.766Z 2026-03-05T14:38:44.555Z
9400581 9400581 20260225185321_zhZSS GR0008 2026-02-27T14:14:58.523Z 2026-03-05T14:38:36.207Z
9400555 9400555 20260225183831_lt6ka GR0008 2026-02-27T14:14:51.776Z 2026-03-05T14:38:30.139Z
9400482 9400482 20260225175620_4oN6Z GR0008 2026-02-27T14:14:33.847Z 2026-03-05T14:38:24.344Z
9400476 9400476 20260225173911_g8Ge1 GR0008 2026-02-27T14:14:30.116Z 2026-03-05T14:38:22.563Z
9400474 9400474 20260225173440_0MtjS GR0008 2026-02-27T14:14:29.215Z 2026-03-05T14:38:22.117Z

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