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,034 rows where station_code = "CA0026" 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
9260495 9260495 20260125045240_AOv4M CA0026 2026-01-26T14:21:59.970Z 2026-01-29T14:44:18.355Z
9260493 9260493 20260125045240_sBXVD CA0026 2026-01-26T14:21:59.644Z 2026-01-29T14:44:18.169Z
9259832 9259832 20260125003928_rnJgq CA0026 2026-01-26T14:18:48.637Z 2026-01-29T14:43:24.370Z
9253092 9253092 20260124091553_aKbyG CA0026 2026-01-25T14:00:39.201Z 2026-01-29T14:40:14.748Z
9250044 9250044 20260123095512_fwhWU CA0026 2026-01-24T14:00:49.721Z 2026-01-29T14:44:55.515Z
9190717 9190717 20260112094609_aL4xD CA0026 2026-01-13T14:23:15.929Z 2026-01-20T15:24:45.184Z
9177617 9177617 20260110103713_ntKhd CA0026 2026-01-11T14:12:30.422Z 2026-01-18T15:09:52.248Z
9171898 9171898 20260109043021_qmWQc CA0026 2026-01-10T14:10:23.010Z 2026-01-17T15:24:41.619Z
9117485 9117485 20251231110906_T2Hjt CA0026 2026-01-01T14:31:52.124Z 2026-01-08T15:13:09.858Z
9117149 9117149 20251231094232_9te7W CA0026 2026-01-01T14:30:24.567Z 2026-01-08T15:12:41.010Z
9087185 9087185 20251228073201_vm1MO CA0026 2025-12-30T14:43:16.100Z 2026-01-05T15:10:55.840Z
9087075 9087075 20251228065756_01A2O CA0026 2025-12-30T14:43:00.308Z 2026-01-05T15:10:51.994Z
9086892 9086892 20251228055848_8jUCh CA0026 2025-12-30T14:42:25.035Z 2026-01-05T15:10:42.134Z
9086808 9086808 20251228054000_Oe7J8 CA0026 2025-12-30T14:42:07.898Z 2026-01-05T15:10:32.852Z
9086672 9086672 20251228052452_CDl9W CA0026 2025-12-30T14:41:50.251Z 2026-01-05T15:10:26.498Z
9086068 9086068 20251228042604_G3PVP CA0026 2025-12-30T14:40:14.527Z 2026-01-05T15:09:53.771Z
9007424 9007424 20251221094512_qCoyP CA0026 2025-12-27T14:40:23.571Z 2025-12-27T14:40:23.571Z
9001939 9001939 20251222105611_5WVD3 CA0026 2025-12-27T14:23:37.336Z 2025-12-30T15:48:03.279Z
9001527 9001527 20251222101953_CIsny CA0026 2025-12-27T14:22:21.044Z 2025-12-30T15:47:59.002Z
8987384 8987384 20251218081834_HIx7Z CA0026 2025-12-26T14:40:08.993Z 2025-12-27T15:20:19.465Z
8987341 8987341 20251218081149_MDWgx CA0026 2025-12-26T14:40:04.741Z 2025-12-27T15:20:13.939Z
8987315 8987315 20251218080601_3jAGD CA0026 2025-12-26T14:40:01.543Z 2025-12-27T15:20:10.291Z
8987285 8987285 20251218080301_Y3eXu CA0026 2025-12-26T14:39:59.657Z 2025-12-27T15:20:08.594Z
8987211 8987211 20251218075006_U7AQf CA0026 2025-12-26T14:39:42.864Z 2025-12-27T15:20:06.204Z
8987020 8987020 20251218071538_Tt9qt CA0026 2025-12-26T14:39:21.981Z 2025-12-27T15:19:58.450Z
8986841 8986841 20251218064553_rZ37c CA0026 2025-12-26T14:38:56.136Z 2025-12-27T15:19:41.377Z
8986791 8986791 20251218063730_qr3Qy CA0026 2025-12-26T14:38:51.797Z 2025-12-27T15:19:38.008Z
8713395 8713395 20251209034118_AFZeR CA0026 2025-12-10T14:16:20.121Z 2025-12-17T15:34:30.170Z
8712684 8712684 20251209004923_Y3adG CA0026 2025-12-10T14:14:34.808Z 2025-12-17T15:34:20.560Z
8712643 8712643 20251209003538_7RB1Z CA0026 2025-12-10T14:14:30.482Z 2025-12-17T15:34:20.121Z
8688188 8688188 20251205104418_GwRx5 CA0026 2025-12-06T14:03:35.888Z 2025-12-14T16:05:15.870Z
8688120 8688120 20251205102742_cIkTC CA0026 2025-12-06T14:03:14.228Z 2025-12-14T16:05:14.061Z
8687692 8687692 20251205083215_qOHDh CA0026 2025-12-06T14:01:24.459Z 2025-12-14T16:05:00.695Z
8687592 8687592 20251205075551_f3Vfk CA0026 2025-12-06T14:00:54.431Z 2025-12-14T16:04:58.687Z
8687586 8687586 20251205075136_4ytRE CA0026 2025-12-06T14:00:53.126Z 2025-12-14T16:04:58.575Z
8687431 8687431 20251205061905_AW3LB CA0026 2025-12-06T14:00:12.753Z 2025-12-14T16:04:54.741Z
8667815 8667815 20251130041216_ygNjZ CA0026 2025-12-02T14:40:28.507Z 2025-12-08T14:56:01.787Z
8667754 8667754 20251130034834_ClX3Y CA0026 2025-12-02T14:40:15.840Z 2025-12-08T14:55:55.933Z
8667590 8667590 20251130023118_IzqHf CA0026 2025-12-02T14:39:01.213Z 2025-12-08T14:54:59.842Z
8667383 8667383 20251130004321_fkT7t CA0026 2025-12-02T14:37:36.165Z 2025-12-08T14:54:12.878Z
8658731 8658731 20251201094532_SkJBq CA0026 2025-12-02T14:00:29.703Z 2025-12-10T14:36:42.011Z
8625208 8625208 20251127083505_L7hup CA0026 2025-11-28T14:26:25.699Z 2025-12-05T15:05:47.389Z
8625109 8625109 20251127080531_6XORk CA0026 2025-11-28T14:26:15.056Z 2025-12-05T15:05:42.240Z
8625059 8625059 20251127074936_SyMpJ CA0026 2025-11-28T14:26:11.499Z 2025-12-05T15:05:41.235Z
8624989 8624989 20251127072946_j0nQi CA0026 2025-11-28T14:26:06.757Z 2025-12-05T15:05:36.207Z
8624987 8624987 20251127072831_PfZp1 CA0026 2025-11-28T14:26:06.685Z 2025-12-05T15:05:36.171Z
8624884 8624884 20251127065754_j47jT CA0026 2025-11-28T14:25:44.104Z 2025-12-05T15:05:31.618Z
8624839 8624839 20251127064805_B1J2S CA0026 2025-11-28T14:25:35.919Z 2025-12-05T15:05:29.701Z
8617435 8617435 20251127092715_6QeXE CA0026 2025-11-28T14:00:50.615Z 2025-12-06T14:58:03.232Z
8617418 8617418 20251127092416_QDs13 CA0026 2025-11-28T14:00:47.036Z 2025-12-06T14:58:02.231Z
8592905 8592905 20251119101941_cgHcP CA0026 2025-11-25T15:01:03.200Z 2025-11-27T15:13:36.031Z
8592903 8592903 20251119094000_UTU1G CA0026 2025-11-25T15:01:02.261Z 2025-11-27T15:13:32.850Z
8584036 8584036 20251123104046_6zpMq CA0026 2025-11-25T14:05:07.944Z 2025-12-02T15:09:45.535Z
8583920 8583920 20251123101536_LLrgz CA0026 2025-11-25T14:04:35.854Z 2025-12-02T15:09:44.261Z
8583037 8583037 20251123094725_gJhHw CA0026 2025-11-24T14:34:46.622Z 2025-12-01T15:22:31.082Z
8583029 8583029 20251123094430_QewAG CA0026 2025-11-24T14:34:46.056Z 2025-12-01T15:22:31.003Z
8582913 8582913 20251123091008_7qMbe CA0026 2025-11-24T14:34:37.101Z 2025-12-01T15:22:29.483Z
8582908 8582908 20251123090710_y37PN CA0026 2025-11-24T14:34:36.787Z 2025-12-01T15:22:29.393Z
8582900 8582900 20251123090555_uSCX8 CA0026 2025-11-24T14:34:36.435Z 2025-12-01T15:22:29.270Z
8582826 8582826 20251123084935_R6mz1 CA0026 2025-11-24T14:34:32.392Z 2025-12-01T15:22:28.375Z
8582806 8582806 20251123083844_3dHWy CA0026 2025-11-24T14:34:31.599Z 2025-12-01T15:22:28.137Z
8582766 8582766 20251123082605_Qi31H CA0026 2025-11-24T14:34:29.570Z 2025-12-01T15:22:27.668Z
8582747 8582747 20251123081927_99FDk CA0026 2025-11-24T14:34:28.686Z 2025-12-01T15:22:27.448Z
8582699 8582699 20251123080052_u3M9h CA0026 2025-11-24T14:34:25.790Z 2025-12-01T15:22:26.676Z
8582667 8582667 20251123074535_RzPeh CA0026 2025-11-24T14:34:24.532Z 2025-12-01T15:22:26.384Z
8582528 8582528 20251123065404_Hx0ta CA0026 2025-11-24T14:33:52.767Z 2025-12-01T15:22:24.888Z
8582468 8582468 20251123062910_DZ6Zw CA0026 2025-11-24T14:33:39.205Z 2025-12-01T15:22:24.267Z
8582404 8582404 20251123060430_J8TDi CA0026 2025-11-24T14:33:34.897Z 2025-12-01T15:22:23.380Z
8582371 8582371 20251123055450_zde3O CA0026 2025-11-24T14:33:31.979Z 2025-12-01T15:22:22.823Z
8582350 8582350 20251123054945_gTvqK CA0026 2025-11-24T14:33:30.999Z 2025-12-01T15:22:22.486Z
8582336 8582336 20251123054107_XpRJs CA0026 2025-11-24T14:33:30.252Z 2025-12-01T15:22:22.313Z
8582332 8582332 20251123053831_Xu4Ae CA0026 2025-11-24T14:33:30.050Z 2025-12-01T15:22:22.230Z
8582300 8582300 20251123052559_mHOmK CA0026 2025-11-24T14:33:28.467Z 2025-12-01T15:22:21.736Z
8582242 8582242 20251123045455_IKldA CA0026 2025-11-24T14:33:25.166Z 2025-12-01T15:22:19.881Z
8582209 8582209 20251123044508_HAueO CA0026 2025-11-24T14:33:22.760Z 2025-12-01T15:22:18.833Z
8582025 8582025 20251123034354_Ha2bl CA0026 2025-11-24T14:33:10.198Z 2025-12-01T15:22:14.244Z
8574393 8574393 20251122061857_81EzX CA0026 2025-11-23T14:43:24.955Z 2025-11-30T15:07:07.978Z
8574352 8574352 20251122055643_iSk9L CA0026 2025-11-23T14:43:08.934Z 2025-11-30T15:07:05.220Z
8574273 8574273 20251122054041_FVtyg CA0026 2025-11-23T14:43:03.646Z 2025-11-30T15:07:04.396Z
8574264 8574264 20251122053932_ziWZU CA0026 2025-11-23T14:43:02.926Z 2025-11-30T15:07:03.864Z
8574244 8574244 20251122053607_mQ21K CA0026 2025-11-23T14:43:02.217Z 2025-11-30T15:07:03.629Z
8574193 8574193 20251122052329_eJH0f CA0026 2025-11-23T14:42:46.140Z 2025-11-30T15:07:01.898Z
8574160 8574160 20251122051954_Vq3WD CA0026 2025-11-23T14:42:28.758Z 2025-11-30T15:07:00.481Z
8553410 8553410 20251120053154_VUIlD CA0026 2025-11-22T14:33:56.066Z 2025-11-28T14:58:05.917Z
8553356 8553356 20251120052809_4iaiD CA0026 2025-11-22T14:33:52.490Z 2025-11-28T14:58:02.128Z
8553343 8553343 20251120052507_tPd7A CA0026 2025-11-22T14:33:51.195Z 2025-11-28T14:58:01.205Z
8553300 8553300 20251120052140_jh3Ni CA0026 2025-11-22T14:33:49.886Z 2025-11-28T14:57:59.965Z
8552387 8552387 20251120040756_C0J4D CA0026 2025-11-22T14:32:23.207Z 2025-11-28T14:57:31.173Z
8537264 8537264 20251119034239_8Rh1f CA0026 2025-11-21T14:27:26.636Z 2025-11-27T15:12:54.260Z
8529805 8529805 20251119104654_TNInJ CA0026 2025-11-20T14:45:40.931Z 2025-11-27T15:13:39.118Z
8529483 8529483 20251119085235_bOL2o CA0026 2025-11-20T14:44:57.915Z 2025-11-27T15:13:30.841Z
8529463 8529463 20251119083608_pB6PO CA0026 2025-11-20T14:44:57.140Z 2025-11-27T15:13:30.474Z
8529457 8529457 20251119083219_5SFE2 CA0026 2025-11-20T14:44:56.880Z 2025-11-27T15:13:30.082Z
8529447 8529447 20251119082051_CB9MQ CA0026 2025-11-20T14:44:56.152Z 2025-11-27T15:13:29.461Z
8529438 8529438 20251119081504_2KSc6 CA0026 2025-11-20T14:44:55.714Z 2025-11-27T15:13:29.072Z
8529424 8529424 20251119080358_Xv63y CA0026 2025-11-20T14:44:55.355Z 2025-11-27T15:13:28.979Z
8529422 8529422 20251119080246_G2eCW CA0026 2025-11-20T14:44:55.278Z 2025-11-27T15:13:28.974Z
8529393 8529393 20251119074108_6tv0g CA0026 2025-11-20T14:44:54.382Z 2025-11-27T15:13:28.809Z
8529327 8529327 20251119065449_SlDTO CA0026 2025-11-20T14:44:51.204Z 2025-11-20T14:44:51.204Z
8529185 8529185 20251119060539_KXToL CA0026 2025-11-20T14:44:44.445Z 2025-11-27T15:13:22.509Z

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