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

79 rows where station_code = "RO000V" 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
9813376 9813376 20260428020042_yGQ4s RO000V 2026-04-29T12:14:15.487Z 2026-04-29T12:24:07.503Z
9813297 9813297 20260428013826_BlvtS RO000V 2026-04-29T12:13:57.613Z 2026-04-29T12:24:07.458Z
9813171 9813171 20260428010959_8EGXi RO000V 2026-04-29T12:13:20.461Z 2026-04-29T12:24:07.385Z
9813083 9813083 20260428005031_ZDuq0 RO000V 2026-04-29T12:12:55.054Z 2026-04-29T12:24:07.338Z
9812830 9812830 20260427234853_o3AJU RO000V 2026-04-29T12:11:46.031Z 2026-04-29T12:24:07.204Z
9812756 9812756 20260427232048_veYx6 RO000V 2026-04-29T12:11:27.453Z 2026-04-29T12:24:07.156Z
9812693 9812693 20260427230257_Tpate RO000V 2026-04-29T12:11:07.930Z 2026-04-29T12:24:07.127Z
9812579 9812579 20260427222041_YMuqH RO000V 2026-04-29T12:10:40.918Z 2026-04-29T12:24:07.065Z
9806784 9806784 20260427015231_IqWES RO000V 2026-04-28T12:13:31.207Z 2026-04-29T12:28:58.225Z
9806480 9806480 20260427011209_z314M RO000V 2026-04-28T12:12:07.534Z 2026-04-29T12:28:39.512Z
9806337 9806337 20260427005152_XcXA9 RO000V 2026-04-28T12:11:31.847Z 2026-04-29T12:28:25.865Z
9806286 9806286 20260427003735_9Qkwb RO000V 2026-04-28T12:11:11.266Z 2026-04-29T12:28:22.640Z
9806121 9806121 20260427000922_2UZDB RO000V 2026-04-28T12:10:19.486Z 2026-04-29T12:28:06.261Z
9805785 9805785 20260426224649_fDBjO RO000V 2026-04-28T12:08:46.235Z 2026-04-29T12:27:43.358Z
9805749 9805749 20260426223755_RExjM RO000V 2026-04-28T12:08:29.347Z 2026-04-29T12:27:38.083Z
9805728 9805728 20260426223020_GANEc RO000V 2026-04-28T12:08:24.151Z 2026-04-29T12:27:36.558Z
9800097 9800097 20260426020453_dOezw RO000V 2026-04-27T12:28:45.459Z 2026-04-29T12:41:06.271Z
9800085 9800085 20260426020258_dNSIm RO000V 2026-04-27T12:28:43.535Z 2026-04-29T12:41:05.753Z
9799839 9799839 20260426014657_eLxjR RO000V 2026-04-27T12:28:01.890Z 2026-04-29T12:40:57.320Z
9799771 9799771 20260426014152_SnWOH RO000V 2026-04-27T12:27:42.225Z 2026-04-29T12:40:54.693Z
9799694 9799694 20260426013603_QHjE0 RO000V 2026-04-27T12:27:32.040Z 2026-04-29T12:40:44.496Z
9799437 9799437 20260426011642_PV9TR RO000V 2026-04-27T12:26:39.892Z 2026-04-29T12:40:32.704Z
9799352 9799352 20260426010335_GSMdr RO000V 2026-04-27T12:26:25.486Z 2026-04-29T12:40:28.838Z
9798673 9798673 20260425235041_7kp7u RO000V 2026-04-27T12:23:54.713Z 2026-04-29T12:39:45.140Z
9798393 9798393 20260425232048_0AGir RO000V 2026-04-27T12:23:01.513Z 2026-04-29T12:39:32.008Z
9798253 9798253 20260425225055_MpgIl RO000V 2026-04-27T12:22:27.936Z 2026-04-29T12:39:26.070Z
9798069 9798069 20260425221805_cqaLy RO000V 2026-04-27T12:21:50.242Z 2026-04-29T12:39:10.947Z
9797677 9797677 20260425211731_6GrRX RO000V 2026-04-27T12:20:28.377Z 2026-04-29T12:38:44.956Z
9797269 9797269 20260425201920_3zOyy RO000V 2026-04-27T12:18:47.586Z 2026-04-29T12:38:24.629Z
9796993 9796993 20260425192837_G9xs4 RO000V 2026-04-27T12:17:38.450Z 2026-04-29T12:38:02.321Z
9796926 9796926 20260425192154_2c86R RO000V 2026-04-27T12:17:25.877Z 2026-04-29T12:37:59.126Z
9796870 9796870 20260425191413_KAfdr RO000V 2026-04-27T12:17:10.230Z 2026-04-29T12:37:56.959Z
9753708 9753708 20260423010525_tpyTp RO000V 2026-04-24T12:05:55.368Z 2026-04-29T13:05:56.366Z
9753675 9753675 20260423010441_FGxAS RO000V 2026-04-24T12:05:54.914Z 2026-04-29T13:05:56.152Z
9753671 9753671 20260423010417_86x4W RO000V 2026-04-24T12:05:54.793Z 2026-04-29T13:05:56.059Z
9753610 9753610 20260423010246_xU2Sj RO000V 2026-04-24T12:05:53.436Z 2026-04-29T13:05:55.151Z
9752895 9752895 20260423003916_demqO RO000V 2026-04-24T12:05:32.530Z 2026-04-29T13:05:46.711Z
9752115 9752115 20260423001409_QX90q RO000V 2026-04-24T12:05:06.809Z 2026-04-29T13:04:59.780Z
9751766 9751766 20260423000230_TPJ13 RO000V 2026-04-24T12:04:59.886Z 2026-04-29T13:04:53.587Z
9750843 9750843 20260422232719_Rn67o RO000V 2026-04-24T12:04:31.872Z 2026-04-29T13:04:42.899Z
9750548 9750548 20260422231344_6ACYR RO000V 2026-04-24T12:04:25.886Z 2026-04-29T13:04:38.426Z
9750505 9750505 20260422231157_V3nwE RO000V 2026-04-24T12:04:25.231Z 2026-04-29T13:04:35.602Z
9749919 9749919 20260422224146_BcsPm RO000V 2026-04-24T12:04:03.916Z 2026-04-29T13:03:56.932Z
9749588 9749588 20260422222427_i5J5s RO000V 2026-04-24T12:03:56.049Z 2026-04-29T13:03:51.042Z
9748813 9748813 20260422213941_Bj3JK RO000V 2026-04-24T12:03:33.401Z 2026-04-29T13:03:41.151Z
9748786 9748786 20260422213720_Gf1IM RO000V 2026-04-24T12:03:32.354Z 2026-04-29T13:03:40.869Z
9719786 9719786 20260420015109_8KExV RO000V 2026-04-21T12:26:08.754Z 2026-04-28T13:38:30.611Z
9719758 9719758 20260420014625_ererA RO000V 2026-04-21T12:26:04.939Z 2026-04-28T13:38:28.192Z
9719610 9719610 20260420013539_fDyHk RO000V 2026-04-21T12:25:36.649Z 2026-04-28T13:38:26.009Z
9719423 9719423 20260420012214_i6JRi RO000V 2026-04-21T12:25:08.919Z 2026-04-28T13:38:21.966Z
9719415 9719415 20260420012049_aXiyB RO000V 2026-04-21T12:25:07.813Z 2026-04-28T13:38:21.794Z
9719148 9719148 20260420005047_6WIAB RO000V 2026-04-21T12:24:27.717Z 2026-04-28T13:38:18.049Z
9718906 9718906 20260420002351_6v13w RO000V 2026-04-21T12:23:39.577Z 2026-04-28T13:38:14.347Z
9718199 9718199 20260419232155_2zoww RO000V 2026-04-21T12:21:58.158Z 2026-04-28T13:37:22.050Z
9708660 9708660 20260418235436_bYhOs RO000V 2026-04-20T12:17:35.648Z 2026-04-27T13:47:23.534Z
9708034 9708034 20260418224553_6mpKA RO000V 2026-04-20T12:15:38.089Z 2026-04-27T13:46:48.402Z
9707864 9707864 20260418223345_tLVdx RO000V 2026-04-20T12:15:05.574Z 2026-04-27T13:46:44.371Z
9707839 9707839 20260418223134_G3gNI RO000V 2026-04-20T12:15:00.977Z 2026-04-27T13:46:43.792Z
9702022 9702022 20260418013242_5YApd RO000V 2026-04-19T12:22:06.716Z 2026-04-26T13:11:04.061Z
9701451 9701451 20260418003315_4dmTU RO000V 2026-04-19T12:20:09.927Z 2026-04-26T13:10:59.808Z
9701439 9701439 20260418003216_Qbr1T RO000V 2026-04-19T12:20:04.246Z 2026-04-26T13:10:59.691Z
9694788 9694788 20260416202813_IssVJ RO000V 2026-04-18T12:20:42.671Z 2026-04-25T13:58:09.666Z
9689094 9689094 20260415220456_3fhur RO000V 2026-04-17T12:27:24.582Z 2026-04-24T12:24:43.426Z
9689092 9689092 20260415220351_tXJzh RO000V 2026-04-17T12:27:24.147Z 2026-04-24T12:24:43.369Z
9689076 9689076 20260415215907_InZPh RO000V 2026-04-17T12:27:11.704Z 2026-04-24T12:24:43.246Z
9680854 9680854 20260415020546_y3Ar1 RO000V 2026-04-16T12:24:02.134Z 2026-04-23T13:12:35.342Z
9680472 9680472 20260415004905_6hyf2 RO000V 2026-04-16T12:22:51.674Z 2026-04-23T13:12:03.401Z
9680275 9680275 20260415001500_gr3gc RO000V 2026-04-16T12:22:22.381Z 2026-04-23T13:11:59.754Z
9680269 9680269 20260415001436_8sYhn RO000V 2026-04-16T12:22:21.638Z 2026-04-23T13:11:59.556Z
9680152 9680152 20260414235539_5RKtj RO000V 2026-04-16T12:22:07.647Z 2026-04-23T13:11:57.433Z
9680127 9680127 20260414235259_RUtEc RO000V 2026-04-16T12:22:05.530Z 2026-04-23T13:11:56.930Z
9680118 9680118 20260414234905_4R90Z RO000V 2026-04-16T12:22:04.566Z 2026-04-23T13:11:56.738Z
9679933 9679933 20260414231721_OHLFO RO000V 2026-04-16T12:21:32.826Z 2026-04-23T13:11:43.553Z
9679738 9679738 20260414223958_dok85 RO000V 2026-04-16T12:20:55.498Z 2026-04-23T13:11:24.049Z
9679690 9679690 20260414223336_79VxF RO000V 2026-04-16T12:20:50.080Z 2026-04-23T13:11:23.140Z
9679621 9679621 20260414222450_ZZNLK RO000V 2026-04-16T12:20:33.589Z 2026-04-23T13:11:19.595Z
9679529 9679529 20260414220226_C0ZZu RO000V 2026-04-16T12:20:18.012Z 2026-04-23T13:11:17.572Z
9679454 9679454 20260414213845_glj6e RO000V 2026-04-16T12:20:09.938Z 2026-04-23T13:11:16.299Z
9679101 9679101 20260414190529_BgE2p RO000V 2026-04-16T12:18:43.323Z 2026-04-23T13:11:07.251Z

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