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,679 rows where station_code = "US002M" 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
8690714 8690714 20251205012734_b05NV US002M 2025-12-06T14:15:15.107Z 2025-12-06T14:18:00.944Z
8637203 8637203 20251128051503_9ZJ3L US002M 2025-11-29T14:26:58.014Z 2025-12-06T15:03:57.661Z
8501485 8501485 20251116110635_Zn2BC US002M 2025-11-18T14:47:26.477Z 2025-11-24T15:06:37.346Z
8500655 8500655 20251116093103_w6aA3 US002M 2025-11-18T14:46:27.764Z 2025-11-24T15:05:54.885Z
8500342 8500342 20251116083449_doozz US002M 2025-11-18T14:46:05.129Z 2025-11-24T15:05:39.533Z
8500278 8500278 20251116082538_JT00g US002M 2025-11-18T14:45:49.672Z 2025-11-24T15:05:37.521Z
8500202 8500202 20251116080637_wCaVH US002M 2025-11-18T14:45:37.723Z 2025-11-24T15:05:35.693Z
8500124 8500124 20251116074503_3li9X US002M 2025-11-18T14:45:33.258Z 2025-11-24T15:05:32.679Z
8482081 8482081 20251116051034_3POOG US002M 2025-11-17T14:22:25.553Z 2025-11-24T15:05:19.135Z
8480926 8480926 20251116005129_3YL2J US002M 2025-11-17T14:19:27.812Z 2025-11-24T15:04:57.282Z
8386025 8386025 20251106021826_ESXNn US002M 2025-11-07T14:09:19.164Z 2025-11-14T15:08:32.121Z
8376313 8376313 20251103103355_JYvPH US002M 2025-11-05T14:36:32.685Z 2025-11-11T15:08:29.239Z
8375810 8375810 20251103090636_6Puj5 US002M 2025-11-05T14:35:33.332Z 2025-11-11T15:08:19.717Z
8366182 8366182 20251102101904_9mR6z US002M 2025-11-04T14:34:47.872Z 2025-11-10T15:10:29.779Z
8358573 8358573 20251102085415_abtME US002M 2025-11-03T14:45:37.236Z 2025-11-10T15:10:21.835Z
8339778 8339778 20251031105219_qEOY3 US002M 2025-11-02T14:34:27.542Z 2025-11-08T15:17:46.928Z
8339064 8339064 20251031095406_SNPP0 US002M 2025-11-02T14:33:26.749Z 2025-11-08T15:17:27.115Z
8327242 8327242 20251030105509_Mok4X US002M 2025-11-01T12:37:15.490Z 2025-11-07T15:18:52.397Z
8326160 8326160 20251030091535_sfm28 US002M 2025-11-01T12:35:18.218Z 2025-11-07T15:17:44.473Z
8326011 8326011 20251030085621_pv7rP US002M 2025-11-01T12:35:11.032Z 2025-11-07T15:17:37.948Z
8284356 8284356 20251028043736_UYnso US002M 2025-10-29T12:45:30.531Z 2025-11-05T15:22:44.910Z
8225410 8225410 20251024080341_lo4n8 US002M 2025-10-26T12:43:16.180Z 2025-11-01T13:11:21.823Z
8225236 8225236 20251024074914_p5b85 US002M 2025-10-26T12:43:08.147Z 2025-11-01T13:11:21.388Z
8217802 8217802 20251024024520_pv6r1 US002M 2025-10-26T12:34:17.393Z 2025-11-01T13:10:46.093Z
8204334 8204334 20251023103501_r6ILq US002M 2025-10-25T12:27:15.295Z 2025-10-31T13:09:06.409Z
8203611 8203611 20251023092110_6LTr9 US002M 2025-10-25T12:25:08.402Z 2025-10-31T13:09:01.369Z
8203488 8203488 20251023091025_YbnqP US002M 2025-10-25T12:24:42.881Z 2025-10-31T13:08:59.918Z
8202783 8202783 20251023073403_g4mFe US002M 2025-10-25T12:22:30.497Z 2025-10-31T13:08:57.592Z
8202692 8202692 20251023072047_SmOsN US002M 2025-10-25T12:22:19.392Z 2025-10-31T13:08:56.490Z
8202383 8202383 20251023062933_kUjBy US002M 2025-10-25T12:21:02.773Z 2025-10-31T13:08:55.121Z
8099628 8099628 20251014061152_MIotj US002M 2025-10-15T12:19:32.472Z 2025-10-22T13:10:16.308Z
8089006 8089006 20251012095737_426Bs US002M 2025-10-13T12:15:13.006Z 2025-10-20T13:04:09.085Z
8088910 8088910 20251012093340_VnX1p US002M 2025-10-13T12:15:06.749Z 2025-10-20T13:04:07.635Z
8088792 8088792 20251012090313_63n13 US002M 2025-10-13T12:14:51.662Z 2025-10-20T13:04:06.116Z
8088086 8088086 20251012045836_OeMeV US002M 2025-10-13T12:12:52.892Z 2025-10-20T13:03:54.038Z
8087810 8087810 20251012035120_C886e US002M 2025-10-13T12:12:05.274Z 2025-10-20T13:03:47.512Z
8083165 8083165 20251011051036_NflJU US002M 2025-10-12T12:09:43.785Z 2025-10-19T12:50:09.301Z
8075851 8075851 20251009045416_cpftw US002M 2025-10-10T12:10:34.952Z 2025-10-17T12:38:00.347Z
8053410 8053410 20251003103325_vAzVx US002M 2025-10-05T12:05:20.602Z 2025-10-12T12:30:28.286Z
8022329 8022329 20250930083432_0oGgS US002M 2025-10-02T12:03:37.060Z 2025-10-09T12:34:52.796Z
8022262 8022262 20250930082403_z9FhO US002M 2025-10-02T12:03:18.354Z 2025-10-09T12:34:40.366Z
8012191 8012191 20250929102611_YZkjO US002M 2025-10-01T12:09:47.254Z 2025-10-08T12:41:45.150Z
8011504 8011504 20250929050000_KsG12 US002M 2025-09-30T12:33:49.332Z 2025-10-07T13:01:30.058Z
7997880 7997880 20250929062517_tePni US002M 2025-09-30T12:00:54.169Z 2025-10-08T12:40:52.711Z
7990176 7990176 20250928063256_wlOOx US002M 2025-09-29T12:00:35.760Z 2025-10-07T12:59:15.964Z
7989683 7989683 20250926040704_NW2wd US002M 2025-09-28T12:36:50.834Z 2025-10-04T13:07:23.874Z
7977221 7977221 20250926071042_BReso US002M 2025-09-28T12:07:52.634Z 2025-10-05T13:08:22.664Z
7977049 7977049 20250926054924_yYh2F US002M 2025-09-28T12:07:11.583Z 2025-10-05T13:08:19.091Z
7976596 7976596 20250927103150_G1kJQ US002M 2025-09-28T12:05:48.483Z 2025-10-05T13:04:54.221Z
7976058 7976058 20250927081640_4F393 US002M 2025-09-28T12:03:37.278Z 2025-09-28T12:03:37.278Z
7952898 7952898 20250925081719_H993o US002M 2025-09-26T12:02:12.547Z 2025-10-04T13:05:35.542Z
7952863 7952863 20250925072002_PBltE US002M 2025-09-26T12:02:02.679Z 2025-10-04T13:05:26.691Z
7952859 7952859 20250925071410_Mx4oM US002M 2025-09-26T12:02:01.701Z 2025-09-26T12:02:01.701Z
7837227 7837227 20250914090452_8IGWU US002M 2025-09-16T12:25:46.472Z 2025-09-22T13:07:51.939Z
7806259 7806259 20250911060200_2KjyH US002M 2025-09-12T12:09:46.169Z 2025-09-19T12:57:19.439Z
7806128 7806128 20250911045009_iFBH5 US002M 2025-09-12T12:09:01.821Z 2025-09-19T12:57:17.102Z
7800303 7800303 20250910024754_xAn0N US002M 2025-09-11T12:08:11.837Z 2025-09-18T12:59:32.365Z
7751652 7751652 20250903033803_df3ib US002M 2025-09-04T12:17:05.190Z 2025-09-11T12:44:09.028Z
7744070 7744070 20250902072102_TnrQp US002M 2025-09-03T12:24:58.540Z 2025-09-10T12:47:42.284Z
7744014 7744014 20250902061130_YRZ8l US002M 2025-09-03T12:24:54.353Z 2025-09-10T12:47:40.397Z
7744010 7744010 20250902055647_2i5HC US002M 2025-09-03T12:24:53.911Z 2025-09-10T12:47:40.029Z
7743978 7743978 20250902050404_9eEPR US002M 2025-09-03T12:24:41.265Z 2025-09-10T12:47:39.231Z
7719465 7719465 20250830063024_r3JSD US002M 2025-09-01T12:38:11.794Z 2025-09-07T12:59:15.221Z
7719428 7719428 20250830062259_CNih7 US002M 2025-09-01T12:38:09.832Z 2025-09-07T12:59:15.014Z
7719281 7719281 20250830053759_tkxic US002M 2025-09-01T12:37:56.474Z 2025-09-07T12:59:11.950Z
7696002 7696002 20250829023923_R0glv US002M 2025-08-30T12:27:51.839Z 2025-09-06T14:13:12.269Z
7686075 7686075 20250828055429_6iJaY US002M 2025-08-29T12:26:57.090Z 2025-09-05T13:06:12.556Z
7685715 7685715 20250828034415_llmrj US002M 2025-08-29T12:26:08.006Z 2025-09-05T13:06:06.350Z
7663854 7663854 20250826070027_H88pr US002M 2025-08-27T12:31:35.957Z 2025-09-03T12:53:08.087Z
7663776 7663776 20250826061546_Zt9gd US002M 2025-08-27T12:31:19.215Z 2025-08-27T12:31:55.480Z
7652223 7652223 20250826101040_8TnSH US002M 2025-08-27T12:01:08.421Z 2025-08-27T12:01:08.421Z
7567427 7567427 20250818073119_zb6Y7 US002M 2025-08-20T12:12:05.180Z 2025-08-20T12:38:25.361Z
7555589 7555589 20250817064328_JixuP US002M 2025-08-19T12:27:46.818Z 2025-08-25T12:51:50.802Z
7555155 7555155 20250817043954_1WNbs US002M 2025-08-19T12:25:40.239Z 2025-08-25T12:51:49.281Z
7554595 7554595 20250817031137_LrOKi US002M 2025-08-19T12:24:00.502Z 2025-08-25T12:51:48.054Z
7521487 7521487 20250815035606_DTQvv US002M 2025-08-17T12:21:05.210Z 2025-08-23T12:48:48.793Z
7507811 7507811 20250814060733_4tRmd US002M 2025-08-16T12:51:54.262Z 2025-08-16T12:51:54.262Z
7506317 7506317 20250814021502_aJqJh US002M 2025-08-16T12:50:17.301Z 2025-08-22T12:46:51.302Z
7490150 7490150 20250813054546_Knql2 US002M 2025-08-15T12:56:06.893Z 2025-08-21T12:47:51.713Z
7450729 7450729 20250812022358_iNzqV US002M 2025-08-13T12:17:23.457Z 2025-08-20T13:06:13.006Z
7408100 7408100 20250808093038_DblCM US002M 2025-08-09T12:16:32.765Z 2025-08-16T13:21:26.815Z
7380457 7380457 20250805045543_6qrLB US002M 2025-08-07T12:16:34.389Z 2025-08-13T12:59:26.797Z
7352693 7352693 20250803082638_0Bix3 US002M 2025-08-05T12:21:33.781Z 2025-08-11T12:54:31.025Z
7352520 7352520 20250803081151_7bWTy US002M 2025-08-05T12:21:29.371Z 2025-08-05T12:21:29.371Z
7351772 7351772 20250803071349_852XU US002M 2025-08-05T12:20:38.716Z 2025-08-11T12:54:20.261Z
7351117 7351117 20250803055817_bWQvP US002M 2025-08-05T12:19:44.736Z 2025-08-11T12:54:05.538Z
7267340 7267340 20250730043853_fSP8I US002M 2025-07-31T12:15:48.456Z 2025-07-31T12:15:48.456Z
7267180 7267180 20250730035318_W2fo4 US002M 2025-07-31T12:15:46.871Z 2025-08-07T12:49:17.237Z
7220550 7220550 20250728081143_Pg8P7 US002M 2025-07-29T12:03:31.403Z 2025-07-29T12:03:31.403Z
7162125 7162125 20250724094116_L4a6a US002M 2025-07-25T12:00:19.264Z 2025-07-25T12:00:19.264Z
7162123 7162123 20250724094011_A6UKZ US002M 2025-07-25T12:00:19.259Z 2025-07-25T12:00:19.259Z
7094272 7094272 20250716085320_43HZ6 US002M 2025-07-17T12:11:10.522Z 2025-07-24T12:01:22.602Z
7093859 7093859 20250716061854_ce3Mt US002M 2025-07-17T12:09:43.580Z 2025-07-24T12:01:22.074Z
7031218 7031218 20250704090429_meq3x US002M 2025-07-05T12:06:24.505Z 2025-07-13T12:46:50.413Z
7031070 7031070 20250704082546_2BNTS US002M 2025-07-05T12:05:51.367Z 2025-07-13T12:46:46.735Z
6995175 6995175 20250629075607_a1kP7 US002M 2025-06-30T12:14:00.087Z 2025-07-07T12:30:35.906Z
6977441 6977441 20250626051503_hoG70 US002M 2025-06-27T12:11:45.438Z 2025-07-04T12:35:54.447Z
6977338 6977338 20250626042205_0t88R US002M 2025-06-27T12:11:25.254Z 2025-07-04T12:35:52.185Z
6973206 6973206 20250625082509_G4w2l US002M 2025-06-26T12:17:41.030Z 2025-07-03T13:02:07.196Z
6824668 6824668 20250529051829_cCkCL US002M 2025-05-30T12:18:42.384Z 2025-06-06T13:02:26.162Z

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