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

8,961 rows where station_code = "GR0002" 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
8674999 8674999 20251202035114_22jIu GR0002 2025-12-03T14:22:49.318Z 2025-12-05T14:28:08.768Z
8674159 8674159 20251202013735_4OMUU GR0002 2025-12-03T14:21:06.096Z 2025-12-05T14:27:31.016Z
8674084 8674084 20251202012437_fKB13 GR0002 2025-12-03T14:20:55.266Z 2025-12-05T14:27:28.496Z
8674032 8674032 20251202011426_yqL3s GR0002 2025-12-03T14:20:47.005Z 2025-12-05T14:27:27.054Z
8674015 8674015 20251202010846_y0ou8 GR0002 2025-12-03T14:20:44.641Z 2025-12-05T14:27:26.145Z
8673823 8673823 20251201235000_3XZr1 GR0002 2025-12-03T14:20:08.002Z 2025-12-05T14:27:18.628Z
8673583 8673583 20251201201449_nlkqx GR0002 2025-12-03T14:19:22.675Z 2025-12-05T14:26:54.230Z
8665664 8665664 20251201034822_k3pME GR0002 2025-12-02T14:24:17.370Z 2025-12-05T14:36:15.391Z
8665145 8665145 20251201023558_qnA3P GR0002 2025-12-02T14:23:00.549Z 2025-12-05T14:35:43.768Z
8665116 8665116 20251201023229_WhZ2E GR0002 2025-12-02T14:22:57.596Z 2025-12-05T14:35:42.953Z
8664884 8664884 20251201015606_utT17 GR0002 2025-12-02T14:22:16.356Z 2025-12-05T14:35:34.665Z
8664842 8664842 20251201014821_UvnwJ GR0002 2025-12-02T14:22:11.162Z 2025-12-05T14:35:32.473Z
8664840 8664840 20251201014810_0f3mx GR0002 2025-12-02T14:22:10.856Z 2025-12-05T14:35:31.922Z
8664257 8664257 20251130235311_ady0q GR0002 2025-12-02T14:20:35.494Z 2025-12-05T14:34:58.723Z
8664206 8664206 20251130233855_ezlxk GR0002 2025-12-02T14:20:25.186Z 2025-12-05T14:34:56.526Z
8664179 8664179 20251130233248_hcEnK GR0002 2025-12-02T14:20:15.541Z 2025-12-05T14:34:55.775Z
8664054 8664054 20251130231216_acIBh GR0002 2025-12-02T14:20:01.259Z 2025-12-05T14:34:43.299Z
8663781 8663781 20251130220217_AoJO1 GR0002 2025-12-02T14:19:06.926Z 2025-12-05T14:34:31.919Z
8663643 8663643 20251130211341_VN5pQ GR0002 2025-12-02T14:18:38.958Z 2025-12-05T14:34:26.657Z
8663549 8663549 20251130210222_JA3w2 GR0002 2025-12-02T14:18:27.142Z 2025-12-05T14:34:23.987Z
8663146 8663146 20251130201534_zOfuF GR0002 2025-12-02T14:17:31.671Z 2025-12-05T14:33:58.352Z
8662321 8662321 20251130183150_GvkQ9 GR0002 2025-12-02T14:15:07.933Z 2025-12-05T14:33:16.990Z
8662198 8662198 20251130181639_2mB21 GR0002 2025-12-02T14:14:40.530Z 2025-12-05T14:33:11.844Z
8651798 8651798 20251130001956_54OvV GR0002 2025-12-01T14:19:56.910Z 2025-12-05T14:42:06.496Z
8650890 8650890 20251129215612_cEKDM GR0002 2025-12-01T14:17:27.975Z 2025-12-05T14:41:21.904Z
8649954 8649954 20251129185705_dUUMr GR0002 2025-12-01T14:14:33.837Z 2025-12-05T14:40:39.091Z
8604451 8604451 20251124033231_SEMqg GR0002 2025-11-26T14:36:21.038Z 2025-12-02T15:12:56.476Z
8604402 8604402 20251124002143_0DOmY GR0002 2025-11-26T14:34:49.549Z 2025-12-02T15:11:50.026Z
8604350 8604350 20251123200103_O2a46 GR0002 2025-11-26T14:33:16.651Z 2025-12-02T15:10:52.484Z
8604321 8604321 20251123172802_mMELM GR0002 2025-11-26T14:32:15.320Z 2025-12-02T15:10:08.369Z
8591585 8591585 20251124042647_jLSzN GR0002 2025-11-25T14:24:34.430Z 2025-12-02T15:12:59.476Z
8591515 8591515 20251124042153_odONr GR0002 2025-11-25T14:24:28.282Z 2025-12-02T15:12:59.078Z
8591429 8591429 20251124041353_7kmux GR0002 2025-11-25T14:24:21.375Z 2025-12-02T15:12:58.691Z
8591333 8591333 20251124040502_GZjq0 GR0002 2025-11-25T14:23:56.373Z 2025-12-02T15:12:58.032Z
8591044 8591044 20251124034003_ELd2s GR0002 2025-11-25T14:23:23.041Z 2025-12-02T15:12:56.798Z
8590908 8590908 20251124032651_l2oig GR0002 2025-11-25T14:23:02.347Z 2025-12-02T15:12:56.153Z
8590820 8590820 20251124031559_R3Y0y GR0002 2025-11-25T14:22:52.194Z 2025-12-02T15:12:55.615Z
8590706 8590706 20251124030525_QByYl GR0002 2025-11-25T14:22:26.276Z 2025-12-02T15:12:54.868Z
8590330 8590330 20251124023518_qpvWY GR0002 2025-11-25T14:21:43.557Z 2025-12-02T15:12:46.928Z
8590311 8590311 20251124023345_qXZXR GR0002 2025-11-25T14:21:39.271Z 2025-12-02T15:12:46.261Z
8589987 8589987 20251124021444_ZgwKZ GR0002 2025-11-25T14:21:05.381Z 2025-12-02T15:12:41.000Z
8589920 8589920 20251124020613_mjK0i GR0002 2025-11-25T14:20:56.490Z 2025-12-02T15:12:40.139Z
8589352 8589352 20251124012640_23hZ0 GR0002 2025-11-25T14:19:43.920Z 2025-12-02T15:12:21.765Z
8588866 8588866 20251124003816_KqJqB GR0002 2025-11-25T14:18:27.481Z 2025-12-02T15:11:57.092Z
8588819 8588819 20251124003347_ne3Hd GR0002 2025-11-25T14:18:21.073Z 2025-12-02T15:11:56.537Z
8588736 8588736 20251124002812_P0oB2 GR0002 2025-11-25T14:18:13.078Z 2025-12-02T15:11:51.111Z
8588409 8588409 20251123235429_DZ2rX GR0002 2025-11-25T14:17:31.807Z 2025-12-02T15:11:41.487Z
8587906 8587906 20251123225931_76mRz GR0002 2025-11-25T14:16:24.648Z 2025-12-02T15:11:22.621Z
8587898 8587898 20251123225758_LNMQa GR0002 2025-11-25T14:16:23.473Z 2025-12-02T15:11:22.494Z
8587882 8587882 20251123225624_wgj9u GR0002 2025-11-25T14:16:21.427Z 2025-12-02T15:11:21.980Z
8587820 8587820 20251123224926_hYP8x GR0002 2025-11-25T14:16:08.713Z 2025-11-25T14:28:10.712Z
8587410 8587410 20251123220050_3LI2d GR0002 2025-11-25T14:15:16.735Z 2025-12-02T15:11:12.367Z
8587368 8587368 20251123215740_ICcES GR0002 2025-11-25T14:15:05.760Z 2025-12-02T15:11:12.214Z
8587197 8587197 20251123213526_OIjSx GR0002 2025-11-25T14:14:49.751Z 2025-12-02T15:11:09.246Z
8586511 8586511 20251123195756_g5v1C GR0002 2025-11-25T14:13:03.999Z 2025-12-02T15:10:51.001Z
8586288 8586288 20251123191615_YHeuL GR0002 2025-11-25T14:12:28.022Z 2025-12-02T15:10:45.503Z
8578433 8578433 20251122203629_1OCjd GR0002 2025-11-24T14:11:44.143Z 2025-12-01T15:19:37.305Z
8566914 8566914 20251122025839_33eJV GR0002 2025-11-23T14:18:04.443Z 2025-11-30T15:06:16.395Z
8566100 8566100 20251121224845_XD7Sy GR0002 2025-11-23T14:15:03.810Z 2025-11-30T15:05:25.663Z
8507775 8507775 20251117235656_q307j GR0002 2025-11-19T14:16:03.681Z 2025-11-26T15:07:47.811Z
8507736 8507736 20251117235311_cU8UT GR0002 2025-11-19T14:15:59.488Z 2025-11-26T15:07:47.695Z
8493848 8493848 20251117021156_pRC0a GR0002 2025-11-18T14:23:16.971Z 2025-11-25T15:09:22.487Z
8493817 8493817 20251117021026_GpoJF GR0002 2025-11-18T14:23:07.850Z 2025-11-25T15:09:22.385Z
8493656 8493656 20251117015711_LyVR6 GR0002 2025-11-18T14:22:41.114Z 2025-11-25T15:09:20.616Z
8492982 8492982 20251117011155_4E5Xl GR0002 2025-11-18T14:21:02.291Z 2025-11-25T15:09:00.550Z
8492831 8492831 20251117005409_QCw6G GR0002 2025-11-18T14:20:36.390Z 2025-11-25T15:08:57.040Z
8492121 8492121 20251116235624_5rwj6 GR0002 2025-11-18T14:19:01.226Z 2025-11-25T15:08:45.737Z
8491869 8491869 20251116232257_UsZPt GR0002 2025-11-18T14:18:27.622Z 2025-11-25T15:08:42.956Z
8491318 8491318 20251116221631_QMELo GR0002 2025-11-18T14:17:04.438Z 2025-11-25T15:08:36.648Z
8491025 8491025 20251116211822_Xvxas GR0002 2025-11-18T14:16:09.418Z 2025-11-25T15:08:31.788Z
8490573 8490573 20251116195346_SIK92 GR0002 2025-11-18T14:14:33.093Z 2025-11-25T15:08:21.778Z
8490065 8490065 20251116182718_VjtAL GR0002 2025-11-18T14:12:30.093Z 2025-11-25T15:07:57.332Z
8489996 8489996 20251116181641_P2bvi GR0002 2025-11-18T14:12:16.908Z 2025-11-25T15:07:56.331Z
8481786 8481786 20251116040701_XdMsM GR0002 2025-11-17T14:21:58.642Z 2025-11-24T15:05:08.199Z
8481766 8481766 20251116040423_Vc9P8 GR0002 2025-11-17T14:21:41.000Z 2025-11-24T15:05:07.363Z
8481693 8481693 20251116035303_dTk1k GR0002 2025-11-17T14:21:33.406Z 2025-11-24T15:05:05.647Z
8481557 8481557 20251116033051_WxY3k GR0002 2025-11-17T14:21:19.451Z 2025-11-24T15:05:04.444Z
8481555 8481555 20251116033046_uiZkq GR0002 2025-11-17T14:21:19.175Z 2025-11-24T15:05:04.420Z
8481541 8481541 20251116032616_E2w6Q GR0002 2025-11-17T14:21:18.252Z 2025-11-24T15:05:04.253Z
8481392 8481392 20251116025520_FiXCa GR0002 2025-11-17T14:20:48.820Z 2025-11-24T15:05:03.025Z
8481304 8481304 20251116022657_3Dkkm GR0002 2025-11-17T14:20:38.699Z 2025-11-24T15:05:01.987Z
8481291 8481291 20251116022522_e0HRS GR0002 2025-11-17T14:20:36.854Z 2025-11-24T15:05:01.886Z
8481270 8481270 20251116022341_No34e GR0002 2025-11-17T14:20:34.626Z 2025-11-24T15:05:01.684Z
8481265 8481265 20251116022223_TSsow GR0002 2025-11-17T14:20:34.128Z 2025-11-24T15:05:01.658Z
8481244 8481244 20251116021710_phWMV GR0002 2025-11-17T14:20:29.621Z 2025-11-24T15:05:01.421Z
8481148 8481148 20251116015127_KYgsJ GR0002 2025-11-17T14:20:03.824Z 2025-11-24T15:04:59.224Z
8481037 8481037 20251116012322_sSM9T GR0002 2025-11-17T14:19:51.460Z 2025-11-24T15:04:58.366Z
8481030 8481030 20251116012059_KIxib GR0002 2025-11-17T14:19:50.906Z 2025-11-24T15:04:58.296Z
8480943 8480943 20251116005631_2D4mE GR0002 2025-11-17T14:19:28.912Z 2025-11-24T15:04:57.386Z
8480933 8480933 20251116005453_Aq3nk GR0002 2025-11-17T14:19:28.314Z 2025-11-24T15:04:57.325Z
8480930 8480930 20251116005146_hQ4MZ GR0002 2025-11-17T14:19:28.034Z 2025-11-24T15:04:57.309Z
8480903 8480903 20251116004531_jLfOI GR0002 2025-11-17T14:19:24.011Z 2025-11-24T15:04:57.101Z
8480826 8480826 20251116001400_NXMcM GR0002 2025-11-17T14:19:14.050Z 2025-11-24T15:04:56.385Z
8480789 8480789 20251115235553_jLmrR GR0002 2025-11-17T14:19:10.756Z 2025-11-24T15:04:56.078Z
8480761 8480761 20251115233314_qT8S2 GR0002 2025-11-17T14:19:07.416Z 2025-11-24T15:04:55.887Z
8480748 8480748 20251115232848_QBp70 GR0002 2025-11-17T14:19:06.390Z 2025-11-24T15:04:55.778Z
8480747 8480747 20251115232732_4SS3F GR0002 2025-11-17T14:19:06.054Z 2025-11-24T15:04:55.774Z
8480738 8480738 20251115232400_3FkvT GR0002 2025-11-17T14:19:04.941Z 2025-11-17T14:34:35.317Z
8480614 8480614 20251115223348_kIRjz GR0002 2025-11-17T14:18:36.462Z 2025-11-24T15:04:54.615Z
8480561 8480561 20251115221230_xHWCs GR0002 2025-11-17T14:18:31.155Z 2025-11-17T14:34:35.193Z

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