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

5,069 rows where station_code = "ES0016" 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
9236447 9236447 20260120031904_mAZTX ES0016 2026-01-21T14:22:51.448Z 2026-01-28T15:00:01.052Z
9235370 9235370 20260120010309_4gbd8 ES0016 2026-01-21T14:18:43.331Z 2026-01-28T14:58:51.599Z
9234335 9234335 20260119205047_3y3d9 ES0016 2026-01-21T14:13:50.057Z 2026-01-28T14:57:30.354Z
9234064 9234064 20260119192806_w9E0p ES0016 2026-01-21T14:12:05.276Z 2026-01-28T14:57:03.108Z
9230806 9230806 20260119051226_Yb24I ES0016 2026-01-20T14:29:50.994Z 2026-01-27T15:05:27.855Z
9230680 9230680 20260119044842_qtxBX ES0016 2026-01-20T14:29:13.289Z 2026-01-27T15:05:20.223Z
9229639 9229639 20260119020940_7n7nO ES0016 2026-01-20T14:23:31.579Z 2026-01-27T15:03:46.224Z
9229241 9229241 20260119011214_fkAGd ES0016 2026-01-20T14:21:41.252Z 2026-01-27T15:03:13.494Z
9229042 9229042 20260119003827_3oCl9 ES0016 2026-01-20T14:20:42.578Z 2026-01-27T15:02:49.056Z
9228802 9228802 20260118235422_Quqm7 ES0016 2026-01-20T14:19:36.506Z 2026-01-27T15:02:36.275Z
9208530 9208530 20260115055447_zcWVp ES0016 2026-01-16T14:13:05.724Z 2026-01-22T15:04:33.047Z
9189255 9189255 20260112034211_kZw1S ES0016 2026-01-13T14:16:37.788Z 2026-01-20T15:23:00.184Z
9188600 9188600 20260112005307_OVLAh ES0016 2026-01-13T14:13:13.150Z 2026-01-20T15:22:01.357Z
9188340 9188340 20260111224432_gv9Rm ES0016 2026-01-13T14:11:49.217Z 2026-01-20T15:21:35.291Z
9188323 9188323 20260111223947_fxqg7 ES0016 2026-01-13T14:11:42.239Z 2026-01-20T15:21:34.219Z
9163013 9163013 20260107052652_ZlfjQ ES0016 2026-01-08T14:07:43.255Z 2026-01-13T15:02:56.955Z
9162435 9162435 20260107024927_QjkXr ES0016 2026-01-08T14:05:06.395Z 2026-01-13T15:02:09.687Z
9162368 9162368 20260107023314_JFdbK ES0016 2026-01-08T14:04:48.599Z 2026-01-13T15:02:04.983Z
9162142 9162142 20260106225240_0OX3k ES0016 2026-01-08T14:03:10.321Z 2026-01-13T15:01:39.815Z
9160610 9160610 20260106063127_EXsWY ES0016 2026-01-07T14:13:08.933Z 2026-01-13T15:09:35.378Z
9160409 9160409 20260106054731_SJUSc ES0016 2026-01-07T14:12:31.088Z 2026-01-13T15:09:25.120Z
9160262 9160262 20260106051638_9MuQW ES0016 2026-01-07T14:12:02.161Z 2026-01-13T15:09:17.057Z
9114672 9114672 20251231042540_IvPVU ES0016 2026-01-01T14:23:13.269Z 2026-01-08T15:09:59.118Z
9109215 9109215 20251227051744_aBYf8 ES0016 2025-12-31T15:11:30.675Z 2026-01-04T15:29:54.173Z
9109203 9109203 20251227013950_XBgLZ ES0016 2025-12-31T15:04:27.118Z 2026-01-04T15:26:16.192Z
9109179 9109179 20251226220511_UURUS ES0016 2025-12-31T14:58:54.620Z 2026-01-04T15:23:31.820Z
9104043 9104043 20251230052746_xCfop ES0016 2025-12-31T14:20:05.476Z 2026-01-07T15:09:20.278Z
9102290 9102290 20251230024511_7bQz5 ES0016 2025-12-31T14:13:09.240Z 2026-01-07T15:07:31.560Z
9101832 9101832 20251230014438_nx2QD ES0016 2025-12-31T14:10:45.215Z 2026-01-07T15:06:50.878Z
9073883 9073883 20251225183851_P1EZI ES0016 2025-12-29T14:59:56.835Z 2025-12-29T14:59:56.835Z
9064392 9064392 20251226040747_7i9dD ES0016 2025-12-29T14:36:49.443Z 2026-01-03T15:36:11.971Z
8950949 8950949 20251215011651_naC4j ES0016 2025-12-24T15:07:41.600Z 2025-12-24T15:07:41.600Z
8949918 8949918 20251215003022_riLa7 ES0016 2025-12-24T15:06:23.487Z 2025-12-24T15:06:23.487Z
8949224 8949224 20251214235817_N42ph ES0016 2025-12-24T15:06:05.936Z 2025-12-24T15:06:05.936Z
8948490 8948490 20251214232532_2x4gk ES0016 2025-12-24T15:05:14.847Z 2025-12-24T15:05:14.847Z
8948484 8948484 20251214232503_HavDl ES0016 2025-12-24T15:05:14.734Z 2025-12-24T15:05:14.734Z
8948353 8948353 20251214231803_mO43h ES0016 2025-12-24T15:04:51.282Z 2025-12-24T15:04:51.282Z
8947536 8947536 20251214223805_Fhgv8 ES0016 2025-12-24T15:04:21.315Z 2025-12-24T15:04:21.315Z
8946677 8946677 20251214215439_N2aOl ES0016 2025-12-24T15:04:03.826Z 2025-12-24T15:04:03.826Z
8943185 8943185 20251214194316_233ks ES0016 2025-12-24T14:59:48.118Z 2025-12-24T14:59:48.118Z
8942920 8942920 20251214193352_FmrK3 ES0016 2025-12-24T14:59:10.414Z 2025-12-24T14:59:10.414Z
8909344 8909344 20251214063540_TJVt6 ES0016 2025-12-23T14:09:17.230Z 2025-12-24T14:22:50.567Z
8909086 8909086 20251214063105_GseuB ES0016 2025-12-23T14:09:03.044Z 2025-12-24T14:22:46.982Z
8908975 8908975 20251214062823_N1KWm ES0016 2025-12-23T14:08:59.495Z 2025-12-24T14:22:45.778Z
8908656 8908656 20251214062218_lRo72 ES0016 2025-12-23T14:08:42.156Z 2025-12-24T14:22:40.302Z
8908324 8908324 20251214061652_AMq2n ES0016 2025-12-23T14:08:31.950Z 2025-12-24T14:22:29.866Z
8907795 8907795 20251214060724_gQSyn ES0016 2025-12-23T14:08:18.084Z 2025-12-24T14:21:51.422Z
8907084 8907084 20251214055506_Xrjej ES0016 2025-12-23T14:08:09.176Z 2025-12-24T14:21:39.307Z
8906748 8906748 20251214054944_JUGPG ES0016 2025-12-23T14:08:07.031Z 2025-12-24T14:21:35.310Z
8906426 8906426 20251214054447_4d9bt ES0016 2025-12-23T14:08:05.701Z 2025-12-24T14:21:26.586Z
8906195 8906195 20251214054106_1vszR ES0016 2025-12-23T14:08:04.329Z 2025-12-24T14:21:08.603Z
8905153 8905153 20251214052637_S70YO ES0016 2025-12-23T14:07:47.340Z 2025-12-24T14:20:35.960Z
8904738 8904738 20251214052143_7d13c ES0016 2025-12-23T14:07:32.892Z 2025-12-24T14:20:31.189Z
8904679 8904679 20251214052044_23FPY ES0016 2025-12-23T14:07:29.179Z 2025-12-24T14:20:29.808Z
8904559 8904559 20251214051932_DWbZG ES0016 2025-12-23T14:07:26.447Z 2025-12-24T14:20:28.861Z
8903515 8903515 20251214050631_TE1tG ES0016 2025-12-23T14:06:26.209Z 2025-12-24T14:19:44.436Z
8903396 8903396 20251214050442_4zQVq ES0016 2025-12-23T14:06:20.803Z 2025-12-24T14:19:40.127Z
8902827 8902827 20251214045836_4k8gX ES0016 2025-12-23T14:05:55.477Z 2025-12-24T14:19:32.274Z
8902602 8902602 20251214045635_oXCYG ES0016 2025-12-23T14:05:54.229Z 2025-12-24T14:19:29.139Z
8902573 8902573 20251214045621_XP1Sv ES0016 2025-12-23T14:05:54.076Z 2025-12-24T14:19:29.055Z
8902464 8902464 20251214045442_HdGVf ES0016 2025-12-23T14:05:52.964Z 2025-12-24T14:19:26.975Z
8902290 8902290 20251214045319_bF7MU ES0016 2025-12-23T14:05:52.228Z 2025-12-24T14:19:12.063Z
8902219 8902219 20251214045257_HR2g3 ES0016 2025-12-23T14:05:51.803Z 2025-12-24T14:19:04.836Z
8900148 8900148 20251214043231_GojNy ES0016 2025-12-23T14:04:46.135Z 2025-12-24T14:17:58.231Z
8899977 8899977 20251214043020_H2rwK ES0016 2025-12-23T14:04:39.651Z 2025-12-24T14:17:54.423Z
8898781 8898781 20251214041844_2tO92 ES0016 2025-12-23T14:04:02.779Z 2025-12-24T14:17:14.887Z
8897847 8897847 20251214025308_wAdP5 ES0016 2025-12-22T14:12:29.826Z 2025-12-23T14:28:01.782Z
8896516 8896516 20251214024200_Eq3Oq ES0016 2025-12-22T14:12:18.100Z 2025-12-23T14:27:55.491Z
8896379 8896379 20251214024056_jFWG0 ES0016 2025-12-22T14:12:16.375Z 2025-12-23T14:27:55.242Z
8895634 8895634 20251214023412_lUeFm ES0016 2025-12-22T14:12:10.961Z 2025-12-23T14:27:54.021Z
8894511 8894511 20251214022507_3Ma3u ES0016 2025-12-22T14:12:03.354Z 2025-12-23T14:27:52.826Z
8894364 8894364 20251214022349_yECDv ES0016 2025-12-22T14:12:02.999Z 2025-12-23T14:27:52.627Z
8894262 8894262 20251214022248_81x57 ES0016 2025-12-22T14:12:02.124Z 2025-12-23T14:27:52.505Z
8893278 8893278 20251214021431_29zKJ ES0016 2025-12-22T14:11:54.632Z 2025-12-23T14:27:49.374Z
8893029 8893029 20251214021304_JkjsS ES0016 2025-12-22T14:11:53.020Z 2025-12-23T14:27:49.020Z
8892152 8892152 20251214020623_82aVi ES0016 2025-12-22T14:11:49.481Z 2025-12-23T14:27:47.770Z
8891810 8891810 20251214020401_iN0UC ES0016 2025-12-22T14:11:47.349Z 2025-12-23T14:27:47.212Z
8891447 8891447 20251214020127_5yRhx ES0016 2025-12-22T14:11:45.495Z 2025-12-23T14:27:46.807Z
8891212 8891212 20251214015915_MkrMF ES0016 2025-12-22T14:11:44.588Z 2025-12-23T14:27:46.525Z
8889596 8889596 20251214014606_dZWPF ES0016 2025-12-22T14:11:37.792Z 2025-12-23T14:27:43.991Z
8887952 8887952 20251214013226_lFEEI ES0016 2025-12-22T14:11:31.179Z 2025-12-23T14:27:41.091Z
8887444 8887444 20251214012837_41WaJ ES0016 2025-12-22T14:11:26.340Z 2025-12-23T14:27:40.302Z
8887434 8887434 20251214012821_lzEXM ES0016 2025-12-22T14:11:26.280Z 2025-12-23T14:27:40.292Z
8885349 8885349 20251214041056_DONni ES0016 2025-12-22T14:03:31.682Z 2025-12-24T14:16:54.603Z
8882445 8882445 20251214034844_Uir9x ES0016 2025-12-22T14:03:11.456Z 2025-12-22T14:12:38.691Z
8881799 8881799 20251214034331_b3rto ES0016 2025-12-22T14:02:51.546Z 2025-12-24T14:15:30.494Z
8881445 8881445 20251214034116_C82gG ES0016 2025-12-22T14:02:44.071Z 2025-12-24T14:15:20.347Z
8880494 8880494 20251214033448_z3gF3 ES0016 2025-12-22T14:02:18.226Z 2025-12-24T14:14:50.811Z
8880391 8880391 20251214033413_hoWUR ES0016 2025-12-22T14:02:17.303Z 2025-12-24T14:14:47.144Z
8879690 8879690 20251214032931_xIyya ES0016 2025-12-22T14:02:07.839Z 2025-12-24T14:14:22.834Z
8879154 8879154 20251214032545_9qQCL ES0016 2025-12-22T14:02:02.091Z 2025-12-24T14:14:13.690Z
8879039 8879039 20251214032450_3Mhm3 ES0016 2025-12-22T14:02:01.018Z 2025-12-24T14:14:11.638Z
8879022 8879022 20251214032437_vjOCL ES0016 2025-12-22T14:02:00.810Z 2025-12-22T14:12:37.164Z
8879019 8879019 20251214032434_23R7B ES0016 2025-12-22T14:02:00.765Z 2025-12-24T14:14:11.135Z
8877506 8877506 20251214031410_iXSaj ES0016 2025-12-22T14:01:24.115Z 2025-12-24T14:13:30.394Z
8876852 8876852 20251214031014_SQCgQ ES0016 2025-12-22T14:00:54.528Z 2025-12-24T14:13:16.989Z
8876722 8876722 20251214030914_IOOO1 ES0016 2025-12-22T14:00:52.400Z 2025-12-24T14:13:14.482Z
8876688 8876688 20251214030858_GMAE9 ES0016 2025-12-22T14:00:51.713Z 2025-12-24T14:13:13.970Z
8876402 8876402 20251214030711_90ce3 ES0016 2025-12-22T14:00:48.571Z 2025-12-24T14:12:59.890Z
8876218 8876218 20251214030606_0Xtkp ES0016 2025-12-22T14:00:46.563Z 2025-12-24T14:12:54.441Z

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