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,264 rows where station_code = "IT0008" 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
9267836 9267836 20260127053036_pJGM8 IT0008 2026-01-28T14:23:28.929Z 2026-01-29T14:35:46.928Z
9267740 9267740 20260127043853_lodze IT0008 2026-01-28T14:23:03.313Z 2026-01-29T14:35:35.445Z
9267577 9267577 20260127031702_m136y IT0008 2026-01-28T14:22:22.933Z 2026-01-29T14:35:19.118Z
9267487 9267487 20260127020413_Z23ol IT0008 2026-01-28T14:21:55.841Z 2026-01-29T14:35:06.997Z
9267372 9267372 20260127000437_96Llg IT0008 2026-01-28T14:21:21.599Z 2026-01-29T14:34:55.101Z
9267315 9267315 20260126230908_pBOV8 IT0008 2026-01-28T14:21:06.373Z 2026-01-29T14:34:50.635Z
9262916 9262916 20260126045139_ccSIb IT0008 2026-01-27T14:16:06.883Z 2026-01-29T14:39:01.353Z
9213266 9213266 20260116025712_p84nB IT0008 2026-01-17T14:16:12.863Z 2026-01-24T15:12:06.413Z
9212814 9212814 20260116010832_Ld1T0 IT0008 2026-01-17T14:14:02.850Z 2026-01-24T15:11:27.809Z
9203503 9203503 20260114051153_x4adx IT0008 2026-01-15T14:24:35.868Z 2026-01-22T15:10:08.916Z
9203399 9203399 20260114045352_yK0Hi IT0008 2026-01-15T14:24:19.724Z 2026-01-22T15:10:06.887Z
9189403 9189403 20260112041648_o9EsK IT0008 2026-01-13T14:17:26.562Z 2026-01-20T15:23:08.079Z
9189144 9189144 20260112030910_u3OD9 IT0008 2026-01-13T14:16:03.229Z 2026-01-20T15:22:43.987Z
9188978 9188978 20260112023122_RQhlc IT0008 2026-01-13T14:15:10.907Z 2026-01-20T15:22:32.500Z
9188707 9188707 20260112012055_UQSiX IT0008 2026-01-13T14:13:51.667Z 2026-01-20T15:22:07.331Z
9188593 9188593 20260112005124_NMm75 IT0008 2026-01-13T14:13:11.180Z 2026-01-20T15:22:00.992Z
9188554 9188554 20260112003957_baTJn IT0008 2026-01-13T14:12:57.954Z 2026-01-20T15:21:58.793Z
9188484 9188484 20260112000051_HocBz IT0008 2026-01-13T14:12:33.401Z 2026-01-20T15:21:54.781Z
9181968 9181968 20260111035138_1PEei IT0008 2026-01-12T14:12:45.620Z 2026-01-19T15:17:58.076Z
9181944 9181944 20260111034551_dK0QF IT0008 2026-01-12T14:12:40.061Z 2026-01-19T15:17:56.839Z
9181902 9181902 20260111033737_oWf23 IT0008 2026-01-12T14:12:32.621Z 2026-01-19T15:17:53.231Z
9181900 9181900 20260111033737_yFaMG IT0008 2026-01-12T14:12:32.197Z 2026-01-19T15:17:53.070Z
9181816 9181816 20260111031915_UrXBT IT0008 2026-01-12T14:12:13.515Z 2026-01-19T15:17:49.856Z
9181459 9181459 20260111014850_07yLK IT0008 2026-01-12T14:10:51.850Z 2026-01-19T15:17:20.223Z
9181329 9181329 20260111012131_ok6XJ IT0008 2026-01-12T14:10:22.323Z 2026-01-19T15:17:13.037Z
9181245 9181245 20260111010442_rL4X7 IT0008 2026-01-12T14:10:05.689Z 2026-01-19T15:17:09.357Z
9181042 9181042 20260110235815_Tn5kF IT0008 2026-01-12T14:09:20.713Z 2026-01-19T15:16:45.258Z
9180959 9180959 20260110233419_C2DME IT0008 2026-01-12T14:09:04.197Z 2026-01-19T15:16:40.816Z
9180893 9180893 20260110231437_fULBi IT0008 2026-01-12T14:08:47.480Z 2026-01-19T15:16:37.737Z
9180751 9180751 20260110221017_1Oz8R IT0008 2026-01-12T14:08:15.524Z 2026-01-19T15:16:30.878Z
9180304 9180304 20260110195449_ZrTMj IT0008 2026-01-12T14:06:37.915Z 2026-01-19T15:15:55.642Z
9180151 9180151 20260110192107_Lo0If IT0008 2026-01-12T14:05:59.418Z 2026-01-19T15:15:48.673Z
9180147 9180147 20260110192107_Dqx2D IT0008 2026-01-12T14:05:58.721Z 2026-01-19T15:15:48.568Z
9170982 9170982 20260108181658_HdMmh IT0008 2026-01-10T14:04:30.975Z 2026-01-17T15:23:14.275Z
9167772 9167772 20260108050135_FqDKp IT0008 2026-01-09T14:09:12.135Z 2026-01-16T15:11:50.021Z
9167723 9167723 20260108043146_3SybU IT0008 2026-01-09T14:08:58.300Z 2026-01-16T15:11:46.541Z
9167683 9167683 20260108041052_C8BPk IT0008 2026-01-09T14:08:49.142Z 2026-01-16T15:11:41.627Z
9167647 9167647 20260108034654_GZvHv IT0008 2026-01-09T14:08:38.331Z 2026-01-16T15:11:33.788Z
9167644 9167644 20260108034653_DJgOB IT0008 2026-01-09T14:08:37.394Z 2026-01-16T15:11:33.625Z
9167529 9167529 20260108022506_TgQvd IT0008 2026-01-09T14:08:05.055Z 2026-01-16T15:11:24.444Z
9167404 9167404 20260108011852_MN4zx IT0008 2026-01-09T14:07:35.520Z 2026-01-16T15:11:16.942Z
9167382 9167382 20260108011016_aZh6t IT0008 2026-01-09T14:07:30.428Z 2026-01-16T15:11:15.367Z
9167338 9167338 20260108003509_LneWb IT0008 2026-01-09T14:07:16.468Z 2026-01-16T15:11:05.073Z
9167116 9167116 20260107224733_fyFsV IT0008 2026-01-09T14:06:19.786Z 2026-01-16T15:10:50.710Z
9167084 9167084 20260107223610_Gr294 IT0008 2026-01-09T14:06:12.247Z 2026-01-16T15:10:48.856Z
9122293 9122293 20260101052037_xIivy IT0008 2026-01-02T14:12:14.800Z 2026-01-09T14:53:12.848Z
9122243 9122243 20260101050734_ns8Vf IT0008 2026-01-02T14:11:56.809Z 2026-01-09T14:53:10.101Z
9122239 9122239 20260101050226_VYR0l IT0008 2026-01-02T14:11:56.110Z 2026-01-09T14:53:09.979Z
9122069 9122069 20260101042420_MBWXB IT0008 2026-01-02T14:10:58.621Z 2026-01-09T14:52:58.932Z
9121939 9121939 20260101034850_UmR04 IT0008 2026-01-02T14:10:20.006Z 2026-01-09T14:52:47.101Z
9121894 9121894 20260101033133_RIRsr IT0008 2026-01-02T14:10:03.721Z 2026-01-09T14:52:44.739Z
9121721 9121721 20260101020421_26d0O IT0008 2026-01-02T14:09:00.899Z 2026-01-09T14:52:30.848Z
9119913 9119913 20251229051958_712jx IT0008 2026-01-01T15:11:33.451Z 2026-01-06T15:18:45.101Z
9115956 9115956 20251231053524_56FOq IT0008 2026-01-01T14:26:49.601Z 2026-01-08T15:11:18.060Z
9115286 9115286 20251231045703_R3iCL IT0008 2026-01-01T14:24:56.748Z 2026-01-08T15:10:40.371Z
9115113 9115113 20251231044807_1jS6S IT0008 2026-01-01T14:24:23.474Z 2026-01-01T14:57:53.997Z
9115029 9115029 20251231044255_XjYIZ IT0008 2026-01-01T14:24:10.938Z 2026-01-08T15:10:20.193Z
9114862 9114862 20251231043308_Ds31K IT0008 2026-01-01T14:23:41.567Z 2026-01-08T15:10:11.673Z
9114744 9114744 20251231042856_bgYFt IT0008 2026-01-01T14:23:25.386Z 2026-01-08T15:10:08.463Z
9113664 9113664 20251231034300_XtVMk IT0008 2026-01-01T14:20:02.598Z 2026-01-08T15:08:56.548Z
9113577 9113577 20251231033742_YWDDs IT0008 2026-01-01T14:19:33.862Z 2026-01-08T15:08:50.819Z
9113426 9113426 20251231032814_Ce91y IT0008 2026-01-01T14:18:51.330Z 2026-01-08T15:08:43.934Z
9113156 9113156 20251231031251_lqjhd IT0008 2026-01-01T14:17:44.531Z 2026-01-08T15:08:32.527Z
9112809 9112809 20251231025253_49mDG IT0008 2026-01-01T14:16:23.592Z 2026-01-08T15:08:08.765Z
9112312 9112312 20251231021856_hgOyz IT0008 2026-01-01T14:14:40.941Z 2026-01-08T15:07:37.791Z
9103719 9103719 20251230045457_hemDq IT0008 2025-12-31T14:18:58.368Z 2026-01-07T15:09:05.990Z
9101673 9101673 20251230011508_uTTD4 IT0008 2025-12-31T14:09:55.046Z 2026-01-07T15:06:40.766Z
9101479 9101479 20251230003545_AAr5O IT0008 2025-12-31T14:08:52.862Z 2025-12-31T14:29:52.554Z
9099017 9099017 20251227204443_LLtnY IT0008 2025-12-30T15:11:21.809Z 2026-01-04T15:35:36.762Z
9098321 9098321 20251227184711_8YlgP IT0008 2025-12-30T15:10:05.156Z 2026-01-04T15:34:55.320Z
9097933 9097933 20251227174844_XnTWl IT0008 2025-12-30T15:09:41.042Z 2026-01-04T15:34:25.890Z
9086478 9086478 20251228050441_3ASkn IT0008 2025-12-30T14:41:10.816Z 2026-01-05T15:10:19.939Z
9086411 9086411 20251228045425_yFwGl IT0008 2025-12-30T14:41:01.264Z 2026-01-05T15:10:17.890Z
9086321 9086321 20251228044708_5gx0d IT0008 2025-12-30T14:40:52.038Z 2026-01-05T15:10:15.440Z
9086280 9086280 20251228044403_zDvFN IT0008 2025-12-30T14:40:48.598Z 2026-01-05T15:10:14.265Z
9086276 9086276 20251228044348_sPUbG IT0008 2025-12-30T14:40:48.240Z 2026-01-05T15:10:14.101Z
9086189 9086189 20251228043543_ulL5U IT0008 2025-12-30T14:40:29.033Z 2026-01-05T15:09:58.822Z
9086173 9086173 20251228043300_2hd2u IT0008 2025-12-30T14:40:26.351Z 2026-01-05T15:09:58.118Z
9086152 9086152 20251228043033_GLkrg IT0008 2025-12-30T14:40:23.743Z 2026-01-05T15:09:57.182Z
9085872 9085872 20251228041127_jh8p0 IT0008 2025-12-30T14:39:43.165Z 2025-12-31T14:51:37.994Z
9085743 9085743 20251228035732_iFibs IT0008 2025-12-30T14:39:18.559Z 2026-01-05T15:09:43.902Z
9085728 9085728 20251228035558_HLgw8 IT0008 2025-12-30T14:39:16.597Z 2026-01-05T15:09:43.333Z
9085713 9085713 20251228035357_dhL0w IT0008 2025-12-30T14:39:15.014Z 2026-01-05T15:09:42.725Z
9085687 9085687 20251228035121_35rjE IT0008 2025-12-30T14:39:11.582Z 2026-01-05T15:09:41.653Z
9085626 9085626 20251228034617_q26mc IT0008 2025-12-30T14:39:04.376Z 2026-01-05T15:09:40.063Z
9085578 9085578 20251228033946_1Bt2z IT0008 2025-12-30T14:38:57.904Z 2026-01-05T15:09:38.298Z
9085057 9085057 20251228024908_xAEvR IT0008 2025-12-30T14:37:29.885Z 2025-12-31T14:50:54.233Z
9084938 9084938 20251228023505_ILkoH IT0008 2025-12-30T14:37:14.973Z 2026-01-05T15:09:08.446Z
9084699 9084699 20251228020936_uskl7 IT0008 2025-12-30T14:36:28.844Z 2026-01-05T15:08:53.066Z
9084407 9084407 20251228013914_C3nXp IT0008 2025-12-30T14:35:37.236Z 2025-12-31T14:50:16.315Z
9084389 9084389 20251228013738_ThlJC IT0008 2025-12-30T14:35:35.382Z 2026-01-05T15:08:41.017Z
9083884 9083884 20251228004729_4Q8i6 IT0008 2025-12-30T14:34:06.353Z 2026-01-05T15:08:14.365Z
9083532 9083532 20251228000547_W7E89 IT0008 2025-12-30T14:32:59.703Z 2026-01-05T15:07:52.404Z
9083206 9083206 20251227231822_kqSsk IT0008 2025-12-30T14:31:57.521Z 2026-01-05T15:07:40.939Z
9082990 9082990 20251227222552_B3vCt IT0008 2025-12-30T14:31:16.659Z 2026-01-05T15:07:33.475Z
9082985 9082985 20251227222552_0YGc2 IT0008 2025-12-30T14:31:16.209Z 2026-01-05T15:07:33.327Z
9082868 9082868 20251227215820_fUFew IT0008 2025-12-30T14:30:50.862Z 2026-01-05T15:07:29.506Z
9082857 9082857 20251227215501_XuLSh IT0008 2025-12-30T14:30:49.512Z 2025-12-30T14:53:53.755Z
9082808 9082808 20251227214525_SmsND IT0008 2025-12-30T14:30:42.304Z 2025-12-30T14:53:53.728Z
9082632 9082632 20251227211353_RRneV IT0008 2025-12-30T14:30:05.779Z 2026-01-05T15:07:12.465Z

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