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

2,142 rows where station_code = "DE000R" 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
8666448 8666448 20251201054241_23cdK DE000R 2025-12-02T14:26:14.518Z 2025-12-06T14:42:22.537Z
8666440 8666440 20251201054037_RmJF7 DE000R 2025-12-02T14:26:12.527Z 2025-12-06T14:42:22.340Z
8666396 8666396 20251201053317_5IxxD DE000R 2025-12-02T14:25:56.561Z 2025-12-06T14:42:20.944Z
8666367 8666367 20251201052250_BUGIL DE000R 2025-12-02T14:25:53.452Z 2025-12-06T14:42:18.216Z
8666359 8666359 20251201052148_liFHQ DE000R 2025-12-02T14:25:52.561Z 2025-12-06T14:42:17.886Z
8666334 8666334 20251201051611_tMZ7z DE000R 2025-12-02T14:25:48.025Z 2025-12-06T14:42:17.271Z
8666237 8666237 20251201045518_fy047 DE000R 2025-12-02T14:25:38.701Z 2025-12-06T14:42:15.180Z
8665955 8665955 20251201041333_f9qkJ DE000R 2025-12-02T14:24:58.686Z 2025-12-06T14:42:07.689Z
8665927 8665927 20251201041135_7sMrJ DE000R 2025-12-02T14:24:56.038Z 2025-12-06T14:42:07.154Z
8665919 8665919 20251201041111_nAqt9 DE000R 2025-12-02T14:24:55.422Z 2025-12-06T14:42:07.050Z
8665744 8665744 20251201035358_wPTuF DE000R 2025-12-02T14:24:24.067Z 2025-12-06T14:41:47.847Z
8665731 8665731 20251201035154_PaoJ2 DE000R 2025-12-02T14:24:22.490Z 2025-12-06T14:41:47.431Z
8665692 8665692 20251201035042_2FHf4 DE000R 2025-12-02T14:24:20.125Z 2025-12-06T14:41:46.250Z
8665540 8665540 20251201033403_UQHCG DE000R 2025-12-02T14:23:51.362Z 2025-12-06T14:41:40.153Z
8665520 8665520 20251201033056_li156 DE000R 2025-12-02T14:23:49.035Z 2025-12-06T14:41:39.641Z
8665481 8665481 20251201032346_2Ffst DE000R 2025-12-02T14:23:45.332Z 2025-12-06T14:41:38.375Z
8665279 8665279 20251201025929_3xewr DE000R 2025-12-02T14:23:16.728Z 2025-12-06T14:41:31.838Z
8665103 8665103 20251201022848_xmNy6 DE000R 2025-12-02T14:22:55.840Z 2025-12-06T14:41:26.645Z
8664929 8664929 20251201020529_pH2B4 DE000R 2025-12-02T14:22:28.566Z 2025-12-06T14:41:03.347Z
8664885 8664885 20251201015708_Q2q0x DE000R 2025-12-02T14:22:16.762Z 2025-12-06T14:41:01.879Z
8664721 8664721 20251201013054_VOGBv DE000R 2025-12-02T14:21:58.448Z 2025-12-06T14:40:55.726Z
8664241 8664241 20251130235028_Qm2Lv DE000R 2025-12-02T14:20:33.625Z 2025-12-06T14:40:42.153Z
8574039 8574039 20251122050113_Ndba3 DE000R 2025-11-23T14:42:12.937Z 2025-11-30T15:06:56.038Z
8574034 8574034 20251122050101_02RIc DE000R 2025-11-23T14:42:12.580Z 2025-11-30T15:06:55.869Z
8573780 8573780 20251122040905_8c6YU DE000R 2025-11-23T14:41:59.250Z 2025-11-30T15:06:37.555Z
8573408 8573408 20251122030819_u5zI3 DE000R 2025-11-23T14:41:10.467Z 2025-11-30T15:06:22.507Z
8573388 8573388 20251122030349_lYoIA DE000R 2025-11-23T14:41:09.254Z 2025-11-30T15:06:19.903Z
8573139 8573139 20251122023315_4ciJb DE000R 2025-11-23T14:40:45.861Z 2025-11-30T15:06:10.620Z
8572495 8572495 20251122010049_eIBjI DE000R 2025-11-23T14:39:28.882Z 2025-11-30T15:05:51.273Z
8572493 8572493 20251122010010_xoJSs DE000R 2025-11-23T14:39:28.714Z 2025-11-30T15:05:51.237Z
8572424 8572424 20251122004209_JtX07 DE000R 2025-11-23T14:39:12.922Z 2025-11-30T15:05:49.500Z
8572288 8572288 20251122001813_d7fo4 DE000R 2025-11-23T14:38:36.473Z 2025-11-30T15:05:43.068Z
8572068 8572068 20251121233049_ugzN2 DE000R 2025-11-23T14:37:57.536Z 2025-11-30T15:05:36.500Z
8571702 8571702 20251121215111_fO3KU DE000R 2025-11-23T14:37:40.457Z 2025-11-30T15:05:14.552Z
8571315 8571315 20251121201314_dl3ef DE000R 2025-11-23T14:36:09.733Z 2025-11-30T15:04:53.737Z
8526546 8526546 20251118231938_tDMZ3 DE000R 2025-11-20T14:39:58.685Z 2025-11-27T15:11:54.400Z
8522831 8522831 20251119010149_cGwuM DE000R 2025-11-20T14:16:47.500Z 2025-11-27T15:12:07.256Z
8521985 8521985 20251118230055_ICzjL DE000R 2025-11-20T14:14:05.651Z 2025-11-27T15:11:52.186Z
8520460 8520460 20251118192756_Iivb0 DE000R 2025-11-20T14:09:59.494Z 2025-11-27T15:11:33.418Z
8514043 8514043 20251118013346_do4rq DE000R 2025-11-19T14:36:53.027Z 2025-11-26T15:07:52.172Z
8513360 8513360 20251118002030_oPOgH DE000R 2025-11-19T14:36:15.662Z 2025-11-26T15:07:48.938Z
8513221 8513221 20251118000548_3LbuE DE000R 2025-11-19T14:36:03.181Z 2025-11-26T15:07:48.164Z
8481633 8481633 20251116034151_to9iA DE000R 2025-11-17T14:21:27.516Z 2025-11-24T15:05:05.084Z
8481009 8481009 20251116011611_DQigf DE000R 2025-11-17T14:19:49.092Z 2025-11-24T15:04:58.085Z
8440014 8440014 20251112050921_dbPxS DE000R 2025-11-13T14:28:00.670Z 2025-11-20T15:25:39.982Z
8439356 8439356 20251112034301_S9u9u DE000R 2025-11-13T14:26:11.669Z 2025-11-20T15:25:17.664Z
8439128 8439128 20251112031722_GRC62 DE000R 2025-11-13T14:25:47.863Z 2025-11-20T15:25:08.611Z
8439084 8439084 20251112031132_sNR2f DE000R 2025-11-13T14:25:30.360Z 2025-11-20T15:25:04.080Z
8439065 8439065 20251112030846_mw0ho DE000R 2025-11-13T14:25:27.891Z 2025-11-20T15:25:01.052Z
8438769 8438769 20251112023802_tOIF9 DE000R 2025-11-13T14:24:40.982Z 2025-11-20T15:24:47.222Z
8438533 8438533 20251112020956_pmiP1 DE000R 2025-11-13T14:23:59.899Z 2025-11-20T15:24:39.696Z
8437984 8437984 20251112010652_8Dvgd DE000R 2025-11-13T14:22:25.369Z 2025-11-20T15:24:05.173Z
8437744 8437744 20251112004050_2Jyad DE000R 2025-11-13T14:21:51.940Z 2025-11-20T15:23:52.340Z
8437390 8437390 20251111235720_JWWgQ DE000R 2025-11-13T14:21:00.928Z 2025-11-20T15:23:29.684Z
8437352 8437352 20251111235309_zYt7V DE000R 2025-11-13T14:20:54.669Z 2025-11-20T15:23:28.645Z
8436453 8436453 20251111214200_rDGrD DE000R 2025-11-13T14:18:14.467Z 2025-11-20T15:22:51.313Z
8435504 8435504 20251111194217_Vx7zv DE000R 2025-11-13T14:15:39.233Z 2025-11-20T15:22:21.634Z
8435137 8435137 20251111191352_jwCfI DE000R 2025-11-13T14:14:35.487Z 2025-11-20T15:22:04.714Z
8386073 8386073 20251106022647_nBx8N DE000R 2025-11-07T14:09:27.740Z 2025-11-14T15:08:34.179Z
8386033 8386033 20251106022123_aMjNB DE000R 2025-11-07T14:09:21.331Z 2025-11-14T15:08:32.890Z
8385732 8385732 20251106011525_1o0le DE000R 2025-11-07T14:07:56.879Z 2025-11-14T15:08:21.145Z
8385730 8385730 20251106011525_UmkeI DE000R 2025-11-07T14:07:56.441Z 2025-11-14T15:08:21.144Z
8385455 8385455 20251106000056_bx458 DE000R 2025-11-07T14:06:48.236Z 2025-11-14T15:08:12.759Z
8385437 8385437 20251105235630_2Z0jK DE000R 2025-11-07T14:06:44.039Z 2025-11-14T15:08:12.110Z
8385357 8385357 20251105231950_Eh3Yl DE000R 2025-11-07T14:06:27.051Z 2025-11-14T15:08:08.012Z
8385027 8385027 20251105205526_CghyO DE000R 2025-11-07T14:04:53.277Z 2025-11-14T15:07:51.181Z
8384965 8384965 20251105200213_yilXo DE000R 2025-11-07T14:04:42.087Z 2025-11-14T15:07:50.485Z
8380627 8380627 20251105024032_fCWuB DE000R 2025-11-06T14:12:30.838Z 2025-11-13T15:14:57.565Z
8379964 8379964 20251105000956_B3tOX DE000R 2025-11-06T14:09:56.562Z 2025-11-13T15:14:34.049Z
8379564 8379564 20251104224942_AoBXb DE000R 2025-11-06T14:08:14.251Z 2025-11-13T15:14:21.113Z
8379431 8379431 20251104221749_c2gAx DE000R 2025-11-06T14:07:49.064Z 2025-11-13T15:14:12.420Z
8379390 8379390 20251104220105_pz4Kf DE000R 2025-11-06T14:07:36.034Z 2025-11-13T15:14:11.821Z
8379350 8379350 20251104214732_uVYHt DE000R 2025-11-06T14:07:28.818Z 2025-11-13T15:14:10.334Z
8378652 8378652 20251104183518_nMT9Z DE000R 2025-11-06T14:04:51.766Z 2025-11-13T15:13:37.231Z
8374778 8374778 20251103045220_ECa9S DE000R 2025-11-05T14:33:11.621Z 2025-11-11T15:08:07.238Z
8374575 8374575 20251103040908_K71Xx DE000R 2025-11-05T14:32:26.437Z 2025-11-11T15:07:44.185Z
8374434 8374434 20251103034201_enOdZ DE000R 2025-11-05T14:32:08.351Z 2025-11-11T15:07:30.437Z
8374327 8374327 20251103032552_rTNPd DE000R 2025-11-05T14:31:37.155Z 2025-11-11T15:07:26.950Z
8374047 8374047 20251103023627_JELdZ DE000R 2025-11-05T14:30:44.840Z 2025-11-11T15:06:48.616Z
8373985 8373985 20251103021223_JDoT3 DE000R 2025-11-05T14:30:30.166Z 2025-11-11T15:06:32.646Z
8373897 8373897 20251103013936_c0sWe DE000R 2025-11-05T14:29:54.042Z 2025-11-11T15:06:29.068Z
8373877 8373877 20251103013149_R8JZ7 DE000R 2025-11-05T14:29:50.480Z 2025-11-11T15:06:28.159Z
8373767 8373767 20251103003316_grg5u DE000R 2025-11-05T14:29:03.550Z 2025-11-11T15:06:20.691Z
8373759 8373759 20251103003005_YhPJR DE000R 2025-11-05T14:29:02.437Z 2025-11-11T15:06:20.318Z
8373578 8373578 20251102222954_BWuPg DE000R 2025-11-05T14:28:08.060Z 2025-11-11T15:06:10.553Z
8342303 8342303 20251031231453_lgXz2 DE000R 2025-11-02T14:38:41.767Z 2025-11-09T15:00:31.847Z
8342046 8342046 20251031221522_1MggZ DE000R 2025-11-02T14:37:55.848Z 2025-11-09T15:00:24.607Z
8335752 8335752 20251031034754_KN8Qz DE000R 2025-11-02T14:28:05.710Z 2025-11-08T15:15:04.879Z
8335477 8335477 20251031032258_fCiHW DE000R 2025-11-02T14:27:24.711Z 2025-11-08T15:14:51.185Z
8335328 8335328 20251031031045_2Y9Xd DE000R 2025-11-02T14:27:13.024Z 2025-11-08T15:14:42.471Z
8331704 8331704 20251101025446_nmnQe DE000R 2025-11-02T14:11:19.723Z 2025-11-09T15:03:12.734Z
8331315 8331315 20251101014652_Y2ijY DE000R 2025-11-02T14:09:41.806Z 2025-11-09T15:01:44.943Z
8331275 8331275 20251101014002_ZjV20 DE000R 2025-11-02T14:09:31.882Z 2025-11-09T15:01:37.487Z
8331092 8331092 20251101011204_liCYE DE000R 2025-11-02T14:08:55.023Z 2025-11-09T15:01:00.807Z
8330922 8330922 20251101003802_N8EK1 DE000R 2025-11-02T14:08:16.388Z 2025-11-09T15:00:45.631Z
8330913 8330913 20251101003719_I3CEo DE000R 2025-11-02T14:08:14.607Z 2025-11-09T15:00:45.385Z
8330900 8330900 20251101003559_z63r6 DE000R 2025-11-02T14:08:12.638Z 2025-11-09T15:00:44.966Z
8330210 8330210 20251031214510_MqbRi DE000R 2025-11-02T14:05:45.456Z 2025-11-09T15:00:18.805Z
8322609 8322609 20251030041846_i5heM DE000R 2025-11-01T12:29:32.586Z 2025-11-07T15:15:42.037Z
8322588 8322588 20251030041749_sxKZk DE000R 2025-11-01T12:29:31.231Z 2025-11-07T15:15:41.783Z

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