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

3,431 rows where station_code = "RU000E" 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
8687088 8687088 20251204032129_ir3bx RU000E 2025-12-05T14:13:51.422Z 2025-12-05T14:14:35.613Z
8687072 8687072 20251204030711_xp3ae RU000E 2025-12-05T14:13:48.810Z 2025-12-05T14:14:35.604Z
8687064 8687064 20251204025835_9v222 RU000E 2025-12-05T14:13:47.120Z 2025-12-05T14:14:35.599Z
8687056 8687056 20251204023418_vXSuU RU000E 2025-12-05T14:13:45.466Z 2025-12-05T14:14:35.592Z
8687052 8687052 20251204022822_a6oV1 RU000E 2025-12-05T14:13:44.585Z 2025-12-05T14:14:35.590Z
8686999 8686999 20251204004128_6lgQ1 RU000E 2025-12-05T14:13:21.536Z 2025-12-05T14:14:35.547Z
8686992 8686992 20251204002423_yKNOr RU000E 2025-12-05T14:13:20.670Z 2025-12-05T14:14:35.543Z
8667655 8667655 20251130030943_qyB4g RU000E 2025-12-02T14:39:37.584Z 2025-12-05T14:43:53.408Z
8667631 8667631 20251130025425_qQbfv RU000E 2025-12-02T14:39:29.720Z 2025-12-05T14:43:45.489Z
8667627 8667627 20251130025321_pDH2X RU000E 2025-12-02T14:39:29.133Z 2025-12-05T14:43:45.215Z
8667606 8667606 20251130024610_VPeDN RU000E 2025-12-02T14:39:25.454Z 2025-12-05T14:43:42.170Z
8667588 8667588 20251130022702_gt1VW RU000E 2025-12-02T14:38:59.755Z 2025-12-05T14:43:35.504Z
8667468 8667468 20251130014442_1jUme RU000E 2025-12-02T14:38:21.924Z 2025-12-05T14:42:57.187Z
8667393 8667393 20251130005655_qEBfp RU000E 2025-12-02T14:37:56.768Z 2025-12-05T14:42:39.818Z
8667374 8667374 20251130003355_OQIy2 RU000E 2025-12-02T14:37:30.364Z 2025-12-05T14:42:11.309Z
8667366 8667366 20251130002157_ilHUx RU000E 2025-12-02T14:37:27.044Z 2025-12-05T14:42:06.849Z
8667337 8667337 20251129235707_U0Nq3 RU000E 2025-12-02T14:37:18.677Z 2025-12-05T14:42:00.773Z
8667320 8667320 20251129233750_x3udX RU000E 2025-12-02T14:37:12.689Z 2025-12-05T14:41:56.996Z
8667307 8667307 20251129223334_9BH6A RU000E 2025-12-02T14:36:43.378Z 2025-12-05T14:41:45.350Z
8667278 8667278 20251129194209_gtEGn RU000E 2025-12-02T14:36:02.309Z 2025-12-05T14:41:00.434Z
8667042 8667042 20251129154705_YHNXp RU000E 2025-12-02T14:34:26.797Z 2025-12-05T14:39:31.755Z
8667036 8667036 20251129153313_o7Y9f RU000E 2025-12-02T14:34:22.859Z 2025-12-05T14:39:26.150Z
8667009 8667009 20251129144206_8y3xf RU000E 2025-12-02T14:33:56.143Z 2025-12-05T14:39:17.958Z
8646757 8646757 20251129024959_o3vFP RU000E 2025-11-30T14:26:48.992Z 2025-12-05T14:51:53.480Z
8646678 8646678 20251129023820_0u5fC RU000E 2025-11-30T14:26:39.418Z 2025-12-05T14:51:47.361Z
8646676 8646676 20251129023817_yIne4 RU000E 2025-11-30T14:26:39.217Z 2025-12-05T14:51:47.268Z
8645879 8645879 20251129001214_0D4iC RU000E 2025-11-30T14:24:39.206Z 2025-12-05T14:51:27.431Z
8645388 8645388 20251128215304_q2Mr3 RU000E 2025-11-30T14:23:39.599Z 2025-12-05T14:50:38.117Z
8645120 8645120 20251128204030_kKa9S RU000E 2025-11-30T14:23:06.865Z 2025-12-05T14:50:31.967Z
8644361 8644361 20251128192335_K4ZJk RU000E 2025-11-30T14:21:52.525Z 2025-12-05T14:50:21.027Z
8644076 8644076 20251128185528_2XWnj RU000E 2025-11-30T14:21:18.646Z 2025-12-05T14:50:15.839Z
8643828 8643828 20251128182936_pZYQr RU000E 2025-11-30T14:20:43.211Z 2025-12-05T14:49:47.940Z
8643727 8643727 20251128181942_HLb91 RU000E 2025-11-30T14:20:37.364Z 2025-12-05T14:49:43.156Z
8643593 8643593 20251128180820_ER6TF RU000E 2025-11-30T14:20:15.540Z 2025-12-05T14:49:29.783Z
8642711 8642711 20251128164033_EqhB9 RU000E 2025-11-30T14:18:30.457Z 2025-12-05T14:49:03.607Z
8641507 8641507 20251128145710_VsAl0 RU000E 2025-11-30T14:16:29.300Z 2025-12-05T14:48:43.417Z
8636141 8636141 20251128032128_PjUnq RU000E 2025-11-29T14:24:57.618Z 2025-12-05T14:59:20.246Z
8635935 8635935 20251128025945_Dh2ZZ RU000E 2025-11-29T14:24:39.826Z 2025-12-05T14:59:16.954Z
8635540 8635540 20251128022351_0biBY RU000E 2025-11-29T14:23:39.053Z 2025-12-05T14:58:59.779Z
8635521 8635521 20251128022159_faRq6 RU000E 2025-11-29T14:23:33.592Z 2025-12-05T14:58:55.770Z
8635085 8635085 20251128014009_YPSGE RU000E 2025-11-29T14:22:39.518Z 2025-12-05T14:58:30.204Z
8634884 8634884 20251128012435_1krHy RU000E 2025-11-29T14:22:09.574Z 2025-12-05T14:58:26.085Z
8634751 8634751 20251128011631_rMjpw RU000E 2025-11-29T14:22:01.034Z 2025-12-05T14:58:24.441Z
8634162 8634162 20251128002924_nl2b2 RU000E 2025-11-29T14:20:50.767Z 2025-12-05T14:58:17.055Z
8634055 8634055 20251128001835_xAqkf RU000E 2025-11-29T14:20:40.794Z 2025-12-05T14:58:16.020Z
8633977 8633977 20251128001055_riIJa RU000E 2025-11-29T14:20:34.330Z 2025-12-05T14:58:14.913Z
8633973 8633973 20251128000942_aah74 RU000E 2025-11-29T14:20:33.942Z 2025-12-05T14:58:14.822Z
8633514 8633514 20251127232808_lq4TL RU000E 2025-11-29T14:19:49.878Z 2025-12-05T14:57:44.570Z
8633488 8633488 20251127232354_3UFJS RU000E 2025-11-29T14:19:47.689Z 2025-12-05T14:57:43.316Z
8633125 8633125 20251127224106_3aeWQ RU000E 2025-11-29T14:19:00.770Z 2025-12-05T14:57:11.122Z
8632977 8632977 20251127222347_MUmEl RU000E 2025-11-29T14:18:38.063Z 2025-12-05T14:56:54.285Z
8632959 8632959 20251127222155_D1Ryv RU000E 2025-11-29T14:18:36.633Z 2025-12-05T14:56:50.235Z
8632771 8632771 20251127215206_LEtKT RU000E 2025-11-29T14:18:20.748Z 2025-12-05T14:56:37.846Z
8632713 8632713 20251127214046_opx4Q RU000E 2025-11-29T14:18:06.653Z 2025-12-05T14:56:33.642Z
8632583 8632583 20251127212238_0sqO3 RU000E 2025-11-29T14:17:49.428Z 2025-12-05T14:56:23.474Z
8630511 8630511 20251127163227_WpbbV RU000E 2025-11-29T14:12:50.109Z 2025-12-05T14:55:32.176Z
8624075 8624075 20251127030122_O1gAl RU000E 2025-11-28T14:23:44.183Z 2025-12-05T15:04:43.839Z
8624016 8624016 20251127024735_dhztS RU000E 2025-11-28T14:23:37.609Z 2025-12-05T15:04:36.565Z
8623999 8623999 20251127024403_K4BpR RU000E 2025-11-28T14:23:35.498Z 2025-12-05T15:04:33.661Z
8623733 8623733 20251127015130_5xubq RU000E 2025-11-28T14:22:37.078Z 2025-12-05T15:04:14.195Z
8623555 8623555 20251127010538_rcLiE RU000E 2025-11-28T14:22:09.057Z 2025-12-05T15:03:59.222Z
8623417 8623417 20251127002732_p20JV RU000E 2025-11-28T14:21:41.902Z 2025-12-05T15:03:49.845Z
8623392 8623392 20251127002123_CY2cM RU000E 2025-11-28T14:21:38.701Z 2025-12-05T15:03:48.547Z
8611846 8611846 20251126020209_Z280e RU000E 2025-11-27T14:22:58.193Z 2025-12-04T15:09:24.755Z
8611221 8611221 20251126013150_QUTTV RU000E 2025-11-27T14:21:40.950Z 2025-12-04T15:08:58.368Z
8610877 8610877 20251126011219_LomxT RU000E 2025-11-27T14:20:54.700Z 2025-12-04T15:08:44.000Z
8610484 8610484 20251126004909_aJ5v0 RU000E 2025-11-27T14:20:13.967Z 2025-12-04T15:08:06.777Z
8608241 8608241 20251125220318_Ec3kz RU000E 2025-11-27T14:15:36.341Z 2025-12-04T15:07:42.955Z
8606712 8606712 20251125193041_xpCPf RU000E 2025-11-27T14:11:00.739Z 2025-12-04T15:06:49.089Z
8606574 8606574 20251125191356_ER4Kb RU000E 2025-11-27T14:10:39.913Z 2025-12-04T15:06:47.113Z
8606508 8606508 20251125190221_O58Wy RU000E 2025-11-27T14:10:22.995Z 2025-12-04T15:06:46.173Z
8606227 8606227 20251125182424_lwapd RU000E 2025-11-27T14:09:37.392Z 2025-12-04T15:06:42.722Z
8606100 8606100 20251125175403_FQxjP RU000E 2025-11-27T14:09:04.927Z 2025-12-04T15:06:06.910Z
8600557 8600557 20251125030612_nBAby RU000E 2025-11-26T14:22:47.399Z 2025-12-02T15:08:46.426Z
8600418 8600418 20251125025853_eu2Hr RU000E 2025-11-26T14:22:40.129Z 2025-12-02T15:08:43.670Z
8599974 8599974 20251125023439_hoYmp RU000E 2025-11-26T14:21:53.839Z 2025-12-02T15:08:33.185Z
8599665 8599665 20251125021619_tnmfx RU000E 2025-11-26T14:21:22.865Z 2025-12-02T15:08:30.830Z
8599580 8599580 20251125021100_Q5kjd RU000E 2025-11-26T14:21:16.871Z 2025-12-02T15:08:29.960Z
8599513 8599513 20251125020926_ASELI RU000E 2025-11-26T14:21:12.230Z 2025-12-02T15:08:27.073Z
8598986 8598986 20251125014010_kzjEL RU000E 2025-11-26T14:20:09.336Z 2025-12-02T15:08:15.408Z
8597839 8597839 20251125001419_9RSfT RU000E 2025-11-26T14:17:45.593Z 2025-12-02T15:07:41.068Z
8597655 8597655 20251124235803_WqngC RU000E 2025-11-26T14:17:17.852Z 2025-12-02T15:07:39.106Z
8597037 8597037 20251124224811_c6wag RU000E 2025-11-26T14:15:54.724Z 2025-12-02T15:07:22.582Z
8596712 8596712 20251124215943_R7JAS RU000E 2025-11-26T14:15:11.316Z 2025-12-02T15:07:07.453Z
8596573 8596573 20251124213257_9c99Q RU000E 2025-11-26T14:14:46.908Z 2025-12-02T15:07:02.922Z
8596373 8596373 20251124210005_3la2b RU000E 2025-11-26T14:14:27.805Z 2025-12-02T15:06:54.362Z
8596082 8596082 20251124194850_hapzI RU000E 2025-11-26T14:13:30.211Z 2025-12-02T15:06:34.061Z
8595899 8595899 20251124185727_gF9ul RU000E 2025-11-26T14:12:54.919Z 2025-12-02T15:06:21.673Z
8595827 8595827 20251124183649_nXrNo RU000E 2025-11-26T14:12:43.614Z 2025-12-02T15:06:13.335Z
8595622 8595622 20251124171603_4gT2C RU000E 2025-11-26T14:11:47.447Z 2025-12-02T15:06:02.572Z
8590582 8590582 20251124025414_FkFkN RU000E 2025-11-25T14:22:14.978Z 2025-12-02T15:12:50.155Z
8590516 8590516 20251124024923_iu945 RU000E 2025-11-25T14:22:09.477Z 2025-12-02T15:12:49.249Z
8590435 8590435 20251124024128_mKLP2 RU000E 2025-11-25T14:22:03.287Z 2025-12-02T15:12:47.673Z
8590135 8590135 20251124022545_0oG9Y RU000E 2025-11-25T14:21:28.068Z 2025-12-02T15:12:42.835Z
8590014 8590014 20251124021624_4A3Us RU000E 2025-11-25T14:21:08.261Z 2025-12-02T15:12:41.395Z
8590001 8590001 20251124021529_G9MH4 RU000E 2025-11-25T14:21:06.802Z 2025-12-02T15:12:41.348Z
8589879 8589879 20251124020141_VQ04F RU000E 2025-11-25T14:20:51.823Z 2025-12-02T15:12:38.974Z
8589672 8589672 20251124014602_mikCk RU000E 2025-11-25T14:20:20.117Z 2025-12-02T15:12:33.139Z
8589239 8589239 20251124011732_2aTpt RU000E 2025-11-25T14:19:32.029Z 2025-12-02T15:12:14.496Z
8589223 8589223 20251124011550_RX637 RU000E 2025-11-25T14:19:29.571Z 2025-12-02T15:12:11.685Z

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