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

3,597 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
8674233 8674233 20251202015234_z3ZVS GR0008 2025-12-03T14:21:16.508Z 2025-12-06T14:34:02.311Z
8674168 8674168 20251202014240_2JAE1 GR0008 2025-12-03T14:21:07.020Z 2025-12-06T14:34:00.468Z
8673974 8673974 20251202005439_31K5f GR0008 2025-12-03T14:20:30.811Z 2025-12-06T14:33:43.641Z
8673900 8673900 20251202002236_m5o81 GR0008 2025-12-03T14:20:16.592Z 2025-12-06T14:33:41.756Z
8673881 8673881 20251202001314_z6xEL GR0008 2025-12-03T14:20:13.991Z 2025-12-06T14:33:38.907Z
8673738 8673738 20251201213427_Ugw45 GR0008 2025-12-03T14:19:48.576Z 2025-12-06T14:33:30.510Z
8673669 8673669 20251201210449_T2IPw GR0008 2025-12-03T14:19:42.923Z 2025-12-06T14:33:28.539Z
8673667 8673667 20251201210240_VKmBT GR0008 2025-12-03T14:19:42.454Z 2025-12-06T14:33:28.201Z
8665954 8665954 20251201041325_Gt6Tr GR0008 2025-12-02T14:24:58.282Z 2025-12-06T14:42:07.562Z
8663785 8663785 20251130220323_McK8O GR0008 2025-12-02T14:19:08.746Z 2025-12-06T14:40:11.133Z
8663705 8663705 20251130212759_Ohnus GR0008 2025-12-02T14:18:55.263Z 2025-12-06T14:40:08.058Z
8662224 8662224 20251130181926_0ApDo GR0008 2025-12-02T14:14:44.123Z 2025-12-06T14:38:56.438Z
8651720 8651720 20251130001339_DpYhr GR0008 2025-12-01T14:19:45.249Z 2025-12-06T14:46:51.415Z
8604455 8604455 20251124033921_IJ0jG GR0008 2025-11-26T14:36:22.206Z 2025-12-02T15:12:56.753Z
8604410 8604410 20251124013558_as3ld GR0008 2025-11-26T14:35:17.177Z 2025-12-02T15:12:31.126Z
8604396 8604396 20251123232943_jRHG9 GR0008 2025-11-26T14:34:27.563Z 2025-12-02T15:11:33.323Z
8604388 8604388 20251123222618_PVKEq GR0008 2025-11-26T14:34:17.359Z 2025-12-02T15:11:18.751Z
8604376 8604376 20251123220117_3wpHF GR0008 2025-11-26T14:34:12.055Z 2025-12-02T15:11:12.559Z
8595575 8595575 20251124170241_EVO7J GR0008 2025-11-26T14:11:40.318Z 2025-12-02T15:06:01.820Z
8595536 8595536 20251124164459_uXZJL GR0008 2025-11-26T14:11:34.511Z 2025-12-02T15:06:00.982Z
8591436 8591436 20251124041417_sVrFj GR0008 2025-11-25T14:24:22.738Z 2025-12-02T15:12:58.723Z
8591295 8591295 20251124040144_9y2uW GR0008 2025-11-25T14:23:50.997Z 2025-12-02T15:12:57.777Z
8589947 8589947 20251124020934_4Iud4 GR0008 2025-11-25T14:20:58.969Z 2025-12-02T15:12:40.451Z
8589787 8589787 20251124015314_kpjxU GR0008 2025-11-25T14:20:42.858Z 2025-12-02T15:12:35.765Z
8589728 8589728 20251124015006_giIDg GR0008 2025-11-25T14:20:26.325Z 2025-12-02T15:12:34.334Z
8589671 8589671 20251124014551_mSINS GR0008 2025-11-25T14:20:19.695Z 2025-12-02T15:12:33.132Z
8589386 8589386 20251124012942_DTzsi GR0008 2025-11-25T14:19:46.577Z 2025-12-02T15:12:22.891Z
8589338 8589338 20251124012455_sDOcc GR0008 2025-11-25T14:19:41.999Z 2025-12-02T15:12:20.209Z
8589336 8589336 20251124012450_sXQuK GR0008 2025-11-25T14:19:41.670Z 2025-12-02T15:12:19.418Z
8589236 8589236 20251124011726_h1gtj GR0008 2025-11-25T14:19:30.887Z 2025-12-02T15:12:14.461Z
8589093 8589093 20251124010210_sredw GR0008 2025-11-25T14:19:01.025Z 2025-12-02T15:12:04.848Z
8589067 8589067 20251124005941_HtSmR GR0008 2025-11-25T14:18:57.868Z 2025-12-02T15:12:04.564Z
8588694 8588694 20251124002210_yjNKy GR0008 2025-11-25T14:18:08.744Z 2025-12-02T15:11:50.067Z
8588591 8588591 20251124001222_cTDG8 GR0008 2025-11-25T14:17:51.071Z 2025-12-02T15:11:49.403Z
8588432 8588432 20251123235626_aRkWt GR0008 2025-11-25T14:17:33.425Z 2025-12-02T15:11:41.758Z
8588376 8588376 20251123235117_HS8Y4 GR0008 2025-11-25T14:17:28.936Z 2025-12-02T15:11:41.117Z
8588116 8588116 20251123232239_poXDw GR0008 2025-11-25T14:16:55.090Z 2025-12-02T15:11:27.737Z
8588021 8588021 20251123231251_ZFOJs GR0008 2025-11-25T14:16:35.199Z 2025-12-02T15:11:23.878Z
8587863 8587863 20251123225505_H9EtB GR0008 2025-11-25T14:16:20.250Z 2025-12-02T15:11:21.829Z
8587799 8587799 20251123224753_2d9JA GR0008 2025-11-25T14:16:07.288Z 2025-12-02T15:11:20.157Z
8587735 8587735 20251123223647_48QlH GR0008 2025-11-25T14:15:58.199Z 2025-12-02T15:11:19.303Z
8587427 8587427 20251123220156_Hp3xU GR0008 2025-11-25T14:15:18.257Z 2025-12-02T15:11:12.759Z
8587191 8587191 20251123213446_2w3zx GR0008 2025-11-25T14:14:48.857Z 2025-12-02T15:11:09.109Z
8579836 8579836 20251123012613_uP6WW GR0008 2025-11-24T14:15:17.331Z 2025-12-01T15:21:11.290Z
8579163 8579163 20251122223328_16Jl1 GR0008 2025-11-24T14:13:43.666Z 2025-12-01T15:20:05.527Z
8567043 8567043 20251122034936_8bxeM GR0008 2025-11-23T14:18:35.702Z 2025-11-30T15:06:34.109Z
8567006 8567006 20251122033945_Dxvhk GR0008 2025-11-23T14:18:29.539Z 2025-11-30T15:06:31.998Z
8566990 8566990 20251122033149_T9Nv3 GR0008 2025-11-23T14:18:25.131Z 2025-11-30T15:06:30.734Z
8566942 8566942 20251122031116_8h2VT GR0008 2025-11-23T14:18:10.520Z 2025-11-30T15:06:23.359Z
8548113 8548113 20251120203754_ogON8 GR0008 2025-11-22T14:16:19.604Z 2025-11-29T14:54:21.991Z
8548104 8548104 20251120203731_f32Ux GR0008 2025-11-22T14:16:18.974Z 2025-11-29T14:54:21.956Z
8493986 8493986 20251117021950_0HFCY GR0008 2025-11-18T14:23:25.231Z 2025-11-25T15:09:25.994Z
8493424 8493424 20251117014218_kjU3O GR0008 2025-11-18T14:22:10.803Z 2025-11-25T15:09:12.980Z
8493412 8493412 20251117014156_Fwv2A GR0008 2025-11-18T14:22:09.570Z 2025-11-25T15:09:12.907Z
8493310 8493310 20251117013415_LhK5a GR0008 2025-11-18T14:21:54.209Z 2025-11-25T15:09:03.485Z
8492496 8492496 20251117003050_FQ33J GR0008 2025-11-18T14:19:53.801Z 2025-11-25T15:08:52.163Z
8492279 8492279 20251117001533_QWCSj GR0008 2025-11-18T14:19:29.801Z 2025-11-25T15:08:47.660Z
8492269 8492269 20251117001250_tvJDE GR0008 2025-11-18T14:19:28.092Z 2025-11-25T15:08:46.903Z
8491857 8491857 20251116232118_Hy4S9 GR0008 2025-11-18T14:18:25.885Z 2025-11-25T15:08:42.677Z
8491108 8491108 20251116213610_dq0jc GR0008 2025-11-18T14:16:22.446Z 2025-11-25T15:08:33.177Z
8490870 8490870 20251116204618_5GHwf GR0008 2025-11-18T14:15:38.248Z 2025-11-25T15:08:28.815Z
8490781 8490781 20251116202428_Zsn3m GR0008 2025-11-18T14:15:17.398Z 2025-11-25T15:08:25.904Z
8490717 8490717 20251116201510_uS2Ti GR0008 2025-11-18T14:15:05.462Z 2025-11-25T15:08:25.198Z
8490557 8490557 20251116195020_3ZLHR GR0008 2025-11-18T14:14:29.353Z 2025-11-25T15:08:21.406Z
8490387 8490387 20251116192125_CJF8B GR0008 2025-11-18T14:13:50.767Z 2025-11-25T15:08:14.930Z
8490288 8490288 20251116190701_Dw6St GR0008 2025-11-18T14:13:33.697Z 2025-11-25T15:08:10.824Z
8490256 8490256 20251116185958_mDSGQ GR0008 2025-11-18T14:13:16.727Z 2025-11-25T15:08:06.466Z
8490077 8490077 20251116182732_lW3tB GR0008 2025-11-18T14:12:38.616Z 2025-11-25T15:07:57.541Z
8489435 8489435 20251116163402_36QHE GR0008 2025-11-18T14:10:06.637Z 2025-11-25T15:07:29.862Z
8481794 8481794 20251116041120_3D3sn GR0008 2025-11-17T14:21:59.447Z 2025-11-24T15:05:08.719Z
8481720 8481720 20251116035620_H2ECa GR0008 2025-11-17T14:21:36.838Z 2025-11-24T15:05:05.890Z
8481716 8481716 20251116035608_Stnk9 GR0008 2025-11-17T14:21:35.625Z 2025-11-24T15:05:05.863Z
8481583 8481583 20251116033449_sP3w8 GR0008 2025-11-17T14:21:22.579Z 2025-11-24T15:05:04.572Z
8481527 8481527 20251116032337_rX3KI GR0008 2025-11-17T14:21:16.434Z 2025-11-24T15:05:04.157Z
8481469 8481469 20251116031541_EExV3 GR0008 2025-11-17T14:20:59.828Z 2025-11-24T15:05:03.748Z
8481417 8481417 20251116030306_HzlgH GR0008 2025-11-17T14:20:51.969Z 2025-11-24T15:05:03.336Z
8481213 8481213 20251116020941_IjUsI GR0008 2025-11-17T14:20:13.564Z 2025-11-24T15:05:01.050Z
8481008 8481008 20251116011602_KTyWn GR0008 2025-11-17T14:19:48.861Z 2025-11-24T15:04:58.057Z
8480888 8480888 20251116004002_nnab3 GR0008 2025-11-17T14:19:21.861Z 2025-11-24T15:04:56.953Z
8480767 8480767 20251115233516_6pODL GR0008 2025-11-17T14:19:07.840Z 2025-11-24T15:04:55.926Z
8480765 8480765 20251115233511_t3nK0 GR0008 2025-11-17T14:19:07.753Z 2025-11-24T15:04:55.920Z
8480750 8480750 20251115232848_QBp70 GR0008 2025-11-17T14:19:06.390Z 2025-11-24T15:04:55.778Z
8480697 8480697 20251115230433_0Q2Es GR0008 2025-11-17T14:18:49.717Z 2025-11-24T15:04:55.373Z
8480663 8480663 20251115225321_j9tko GR0008 2025-11-17T14:18:44.873Z 2025-11-24T15:04:55.103Z
8480657 8480657 20251115225042_ztitl GR0008 2025-11-17T14:18:44.326Z 2025-11-24T15:04:54.999Z
8480495 8480495 20251115214834_PqkaR GR0008 2025-11-17T14:18:24.758Z 2025-11-24T15:04:53.448Z
8480437 8480437 20251115212707_nXz26 GR0008 2025-11-17T14:18:18.233Z 2025-11-24T15:04:52.877Z
8480415 8480415 20251115211433_oQce6 GR0008 2025-11-17T14:18:04.735Z 2025-11-17T14:34:35.092Z
8480398 8480398 20251115211112_RY1Ri GR0008 2025-11-17T14:18:02.212Z 2025-11-24T15:04:52.406Z
8480292 8480292 20251115205622_BRDK9 GR0008 2025-11-17T14:17:48.687Z 2025-11-24T15:04:51.497Z
8480253 8480253 20251115204726_EILeY GR0008 2025-11-17T14:17:45.499Z 2025-11-24T15:04:51.162Z
8480191 8480191 20251115204208_17SQp GR0008 2025-11-17T14:17:41.676Z 2025-11-17T14:34:35.001Z
8480182 8480182 20251115204142_p2Gbd GR0008 2025-11-17T14:17:40.840Z 2025-11-17T14:34:34.997Z
8479881 8479881 20251115200752_hmUnM GR0008 2025-11-17T14:17:03.889Z 2025-11-24T15:04:48.778Z
8479199 8479199 20251115184859_ffmmi GR0008 2025-11-17T14:15:11.193Z 2025-11-24T15:04:35.232Z
8478380 8478380 20251115170940_qO2gO GR0008 2025-11-17T14:13:22.313Z 2025-11-24T15:04:10.693Z
8469980 8469980 20251115035649_ctQ5s GR0008 2025-11-16T14:21:35.616Z 2025-11-23T15:17:59.301Z
8469947 8469947 20251115035310_RbfWL GR0008 2025-11-16T14:21:32.679Z 2025-11-23T15:17:58.984Z
8469932 8469932 20251115035235_pFn4H GR0008 2025-11-16T14:21:31.550Z 2025-11-23T15:17:58.886Z
8469921 8469921 20251115035037_WEqiA GR0008 2025-11-16T14:21:30.213Z 2025-11-23T15:17:58.831Z

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