participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000M" sorted by created_at descending
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 |
---|---|---|---|---|---|
5565367 | 5565367 | 20241120042113_qvt7C | US000M | 2024-11-21T14:18:47.200Z | 2024-11-21T14:18:54.198Z |
5565060 | 5565060 | 20241120034732_ZPyDE | US000M | 2024-11-21T14:18:26.044Z | 2024-11-21T14:18:54.147Z |
5564858 | 5564858 | 20241120033149_Y5Zb7 | US000M | 2024-11-21T14:18:08.410Z | 2024-11-21T14:18:54.112Z |
5564720 | 5564720 | 20241120032239_5MOas | US000M | 2024-11-21T14:17:59.517Z | 2024-11-21T14:18:54.089Z |
5564708 | 5564708 | 20241120032130_73XAl | US000M | 2024-11-21T14:17:58.993Z | 2024-11-21T14:18:54.086Z |
5564611 | 5564611 | 20241120031406_xl83i | US000M | 2024-11-21T14:17:53.050Z | 2024-11-21T14:18:54.071Z |
5564221 | 5564221 | 20241120024017_t7O4e | US000M | 2024-11-21T14:17:20.367Z | 2024-11-21T14:18:54.006Z |
5563739 | 5563739 | 20241120020032_2rUsg | US000M | 2024-11-21T14:16:37.452Z | 2024-11-21T14:18:53.906Z |
5560335 | 5560335 | 20241120123909_6eJF1 | US000M | 2024-11-21T14:08:41.320Z | 2024-11-21T14:08:41.320Z |
5560303 | 5560303 | 20241120123241_YPwOE | US000M | 2024-11-21T14:08:33.740Z | 2024-11-21T14:08:33.740Z |
5560240 | 5560240 | 20241120122325_WL9B9 | US000M | 2024-11-21T14:08:21.927Z | 2024-11-21T14:08:21.927Z |
5560124 | 5560124 | 20241120120439_0C0Bu | US000M | 2024-11-21T14:08:06.062Z | 2024-11-21T14:08:06.062Z |
5560089 | 5560089 | 20241120115758_E2N2i | US000M | 2024-11-21T14:08:01.420Z | 2024-11-21T14:08:01.420Z |
5559850 | 5559850 | 20241120112402_LV93V | US000M | 2024-11-21T14:07:19.920Z | 2024-11-21T14:07:19.920Z |
5559814 | 5559814 | 20241120112127_NoRsY | US000M | 2024-11-21T14:07:14.397Z | 2024-11-21T14:07:14.397Z |
5559795 | 5559795 | 20241120111817_JE5Wq | US000M | 2024-11-21T14:07:12.278Z | 2024-11-21T14:07:12.278Z |
5559787 | 5559787 | 20241120111713_Q9xRR | US000M | 2024-11-21T14:07:11.144Z | 2024-11-21T14:07:11.144Z |
5559747 | 5559747 | 20241120111202_Dl4Sa | US000M | 2024-11-21T14:07:06.496Z | 2024-11-21T14:07:06.496Z |
5559740 | 5559740 | 20241120111107_lR8WU | US000M | 2024-11-21T14:07:05.653Z | 2024-11-21T14:07:05.653Z |
5559680 | 5559680 | 20241120105735_S3zXY | US000M | 2024-11-21T14:06:56.880Z | 2024-11-21T14:06:56.880Z |
5559581 | 5559581 | 20241120104505_JR6hc | US000M | 2024-11-21T14:06:39.234Z | 2024-11-21T14:06:39.234Z |
5559550 | 5559550 | 20241120104129_Cciva | US000M | 2024-11-21T14:06:34.903Z | 2024-11-21T14:06:34.903Z |
5559510 | 5559510 | 20241120103559_bbyj1 | US000M | 2024-11-21T14:06:29.704Z | 2024-11-21T14:06:29.704Z |
5559490 | 5559490 | 20241120103250_mGn5q | US000M | 2024-11-21T14:06:26.827Z | 2024-11-21T14:06:26.827Z |
5559480 | 5559480 | 20241120102848_y8IIN | US000M | 2024-11-21T14:06:25.325Z | 2024-11-21T14:06:25.325Z |
5559443 | 5559443 | 20241120102354_ZRE9o | US000M | 2024-11-21T14:06:20.841Z | 2024-11-21T14:06:20.841Z |
5559414 | 5559414 | 20241120102016_eZ4KZ | US000M | 2024-11-21T14:06:16.427Z | 2024-11-21T14:06:16.427Z |
5559057 | 5559057 | 20241120090829_QMPUy | US000M | 2024-11-21T14:05:10.045Z | 2024-11-21T14:05:10.045Z |
5558989 | 5558989 | 20241120090256_82jXv | US000M | 2024-11-21T14:04:58.927Z | 2024-11-21T14:04:58.927Z |
5558472 | 5558472 | 20241120061029_6ztFO | US000M | 2024-11-21T14:03:22.004Z | 2024-11-21T14:03:22.004Z |
5558356 | 5558356 | 20241120055845_tGxYp | US000M | 2024-11-21T14:03:06.506Z | 2024-11-21T14:03:06.506Z |
5558020 | 5558020 | 20241120053205_RrKv6 | US000M | 2024-11-21T14:02:19.679Z | 2024-11-21T14:02:19.679Z |
5557197 | 5557197 | 20241119042858_42hrz | US000M | 2024-11-20T14:12:26.904Z | 2024-11-21T14:20:49.379Z |
5557006 | 5557006 | 20241119032116_JLJlz | US000M | 2024-11-20T14:11:58.423Z | 2024-11-21T14:20:43.070Z |
5556974 | 5556974 | 20241119031234_BP3FX | US000M | 2024-11-20T14:11:53.254Z | 2024-11-21T14:20:42.427Z |
5556919 | 5556919 | 20241119024819_Cqikw | US000M | 2024-11-20T14:11:41.442Z | 2024-11-21T14:20:39.671Z |
5556841 | 5556841 | 20241119021039_I3PaN | US000M | 2024-11-20T14:11:32.833Z | 2024-11-21T14:20:37.088Z |
5555254 | 5555254 | 20241119122452_i6lHd | US000M | 2024-11-20T14:05:01.172Z | 2024-11-21T14:18:53.236Z |
5555208 | 5555208 | 20241119121512_sZZbA | US000M | 2024-11-20T14:04:46.941Z | 2024-11-21T14:18:53.227Z |
5555131 | 5555131 | 20241119115340_4hKH3 | US000M | 2024-11-20T14:04:31.465Z | 2024-11-21T14:18:53.208Z |
5555126 | 5555126 | 20241119115154_bH84g | US000M | 2024-11-20T14:04:31.159Z | 2024-11-21T14:18:53.207Z |
5555084 | 5555084 | 20241119113617_h307W | US000M | 2024-11-20T14:04:25.788Z | 2024-11-21T14:18:53.199Z |
5555034 | 5555034 | 20241119112327_LMfHO | US000M | 2024-11-20T14:04:09.592Z | 2024-11-21T14:18:53.187Z |
5555012 | 5555012 | 20241119111935_A52W4 | US000M | 2024-11-20T14:04:06.235Z | 2024-11-21T14:18:53.183Z |
5554951 | 5554951 | 20241119111001_AWS3B | US000M | 2024-11-20T14:03:52.977Z | 2024-11-21T14:18:53.171Z |
5554939 | 5554939 | 20241119110730_bMoKe | US000M | 2024-11-20T14:03:50.849Z | 2024-11-21T14:18:53.168Z |
5554910 | 5554910 | 20241119110033_KmDxW | US000M | 2024-11-20T14:03:47.456Z | 2024-11-21T14:18:53.161Z |
5554819 | 5554819 | 20241119104410_EmUOd | US000M | 2024-11-20T14:03:23.010Z | 2024-11-21T14:18:53.140Z |
5554761 | 5554761 | 20241119102956_cr80e | US000M | 2024-11-20T14:03:12.615Z | 2024-11-21T14:18:53.127Z |
5554739 | 5554739 | 20241119102017_zFAJU | US000M | 2024-11-20T14:03:10.226Z | 2024-11-21T14:18:53.123Z |
5554717 | 5554717 | 20241119101619_RwwLS | US000M | 2024-11-20T14:03:06.716Z | 2024-11-21T14:18:53.118Z |
5554515 | 5554515 | 20241119092515_cNYRh | US000M | 2024-11-20T14:02:20.749Z | 2024-11-21T14:18:53.073Z |
5554506 | 5554506 | 20241119092009_voEo2 | US000M | 2024-11-20T14:02:19.465Z | 2024-11-21T14:18:53.070Z |
5554470 | 5554470 | 20241119091131_2IwjK | US000M | 2024-11-20T14:02:14.811Z | 2024-11-21T14:18:53.063Z |
5554467 | 5554467 | 20241119090920_mWNQs | US000M | 2024-11-20T14:02:14.310Z | 2024-11-21T14:18:53.062Z |
5554334 | 5554334 | 20241119081947_vLygf | US000M | 2024-11-20T14:01:41.774Z | 2024-11-21T14:18:53.030Z |
5554179 | 5554179 | 20241119065132_Kezpi | US000M | 2024-11-20T14:01:01.429Z | 2024-11-21T14:18:52.993Z |
5554055 | 5554055 | 20241119055250_LOxij | US000M | 2024-11-20T14:00:34.886Z | 2024-11-21T14:18:52.967Z |
5551168 | 5551168 | 20241118123733_3KGK2 | US000M | 2024-11-19T14:04:01.325Z | 2024-11-21T14:19:44.956Z |
5551144 | 5551144 | 20241118123251_cuqZE | US000M | 2024-11-19T14:03:59.110Z | 2024-11-21T14:19:44.528Z |
5551115 | 5551115 | 20241118122820_XLBIN | US000M | 2024-11-19T14:03:55.935Z | 2024-11-21T14:19:43.581Z |
5551079 | 5551079 | 20241118122227_KXyz7 | US000M | 2024-11-19T14:03:53.190Z | 2024-11-21T14:19:42.734Z |
5550931 | 5550931 | 20241118115227_LhKva | US000M | 2024-11-19T14:03:31.390Z | 2024-11-21T14:19:38.655Z |
5550774 | 5550774 | 20241118112348_9ZkAS | US000M | 2024-11-19T14:03:04.469Z | 2024-11-21T14:19:31.368Z |
5550762 | 5550762 | 20241118112242_jWnYe | US000M | 2024-11-19T14:03:02.760Z | 2024-11-21T14:19:29.766Z |
5549467 | 5549467 | 20241117045939_l5I3T | US000M | 2024-11-18T14:11:39.011Z | 2024-11-21T14:23:17.755Z |
5549414 | 5549414 | 20241117044707_xYB6B | US000M | 2024-11-18T14:11:33.840Z | 2024-11-21T14:23:17.138Z |
5545965 | 5545965 | 20241117082249_2oSjE | US000M | 2024-11-18T14:01:35.079Z | 2024-11-21T14:21:07.172Z |
5545858 | 5545858 | 20241117072717_AnkU9 | US000M | 2024-11-18T14:01:13.254Z | 2024-11-21T14:21:03.022Z |
5545804 | 5545804 | 20241117070622_QRx3e | US000M | 2024-11-18T14:01:00.006Z | 2024-11-21T14:21:00.840Z |
5545760 | 5545760 | 20241117064331_kmq2q | US000M | 2024-11-18T14:00:52.891Z | 2024-11-21T14:20:59.297Z |
5544586 | 5544586 | 20241116124320_ZaZ0N | US000M | 2024-11-17T14:01:36.697Z | 2024-11-21T14:22:37.058Z |
5544582 | 5544582 | 20241116124256_3gN22 | US000M | 2024-11-17T14:01:36.357Z | 2024-11-21T14:22:37.037Z |
5544568 | 5544568 | 20241116124023_KEP0H | US000M | 2024-11-17T14:01:34.839Z | 2024-11-21T14:22:36.914Z |
5544529 | 5544529 | 20241116121513_84FwY | US000M | 2024-11-17T14:01:28.157Z | 2024-11-21T14:22:35.917Z |
5544526 | 5544526 | 20241116121443_35O9Q | US000M | 2024-11-17T14:01:27.159Z | 2024-11-21T14:22:35.855Z |
5544496 | 5544496 | 20241116114832_DiFOs | US000M | 2024-11-17T14:01:17.994Z | 2024-11-21T14:22:34.876Z |
5544487 | 5544487 | 20241116114406_zoQP4 | US000M | 2024-11-17T14:01:16.905Z | 2024-11-21T14:22:34.541Z |
5544484 | 5544484 | 20241116114401_q52h0 | US000M | 2024-11-17T14:01:16.585Z | 2024-11-21T14:22:34.532Z |
5544478 | 5544478 | 20241116114334_mKq9N | US000M | 2024-11-17T14:01:16.133Z | 2024-11-21T14:22:34.524Z |
5544464 | 5544464 | 20241116112853_AunSc | US000M | 2024-11-17T14:01:14.073Z | 2024-11-21T14:22:34.285Z |
5544444 | 5544444 | 20241116110942_wtXkl | US000M | 2024-11-17T14:01:10.517Z | 2024-11-21T14:22:34.048Z |
5544436 | 5544436 | 20241116110236_dJnBX | US000M | 2024-11-17T14:01:08.895Z | 2024-11-21T14:22:33.659Z |
5544432 | 5544432 | 20241116110013_J0P0e | US000M | 2024-11-17T14:01:07.963Z | 2024-11-21T14:22:33.570Z |
5544427 | 5544427 | 20241116105730_qvIwd | US000M | 2024-11-17T14:01:06.966Z | 2024-11-21T14:22:33.507Z |
5544416 | 5544416 | 20241116105456_uDJNN | US000M | 2024-11-17T14:01:04.383Z | 2024-11-21T14:22:33.319Z |
5544404 | 5544404 | 20241116104949_8CZEL | US000M | 2024-11-17T14:01:02.097Z | 2024-11-21T14:22:33.147Z |
5544366 | 5544366 | 20241116102241_s9pe2 | US000M | 2024-11-17T14:00:57.039Z | 2024-11-21T14:22:32.279Z |
5544329 | 5544329 | 20241116100318_6NbsT | US000M | 2024-11-17T14:00:52.582Z | 2024-11-21T14:22:31.213Z |
5544326 | 5544326 | 20241116100237_I67KH | US000M | 2024-11-17T14:00:52.201Z | 2024-11-21T14:22:31.158Z |
5544321 | 5544321 | 20241116095942_IxbJN | US000M | 2024-11-17T14:00:51.477Z | 2024-11-21T14:22:31.120Z |
5544310 | 5544310 | 20241116095006_j8obR | US000M | 2024-11-17T14:00:49.716Z | 2024-11-21T14:22:30.864Z |
5544243 | 5544243 | 20241116090754_t2vHJ | US000M | 2024-11-17T14:00:35.894Z | 2024-11-21T14:22:29.200Z |
5544229 | 5544229 | 20241116085145_c0M8V | US000M | 2024-11-17T14:00:31.309Z | 2024-11-21T14:22:29.047Z |
5544210 | 5544210 | 20241116082911_kzOHj | US000M | 2024-11-17T14:00:28.463Z | 2024-11-21T14:22:28.643Z |
5544198 | 5544198 | 20241116080610_ijcqr | US000M | 2024-11-17T14:00:26.532Z | 2024-11-21T14:22:28.470Z |
5544166 | 5544166 | 20241116071355_40Aar | US000M | 2024-11-17T14:00:21.634Z | 2024-11-21T14:22:28.163Z |
5544159 | 5544159 | 20241116070556_32vN9 | US000M | 2024-11-17T14:00:20.875Z | 2024-11-21T14:22:28.140Z |
5544130 | 5544130 | 20241116064137_NbRam | US000M | 2024-11-17T14:00:17.030Z | 2024-11-21T14:22:27.886Z |
5543942 | 5543942 | 20241115044443_qQUS8 | US000M | 2024-11-16T14:07:43.156Z | 2024-11-21T14:24:36.969Z |
Advanced export
JSON shape: default, array, newline-delimited
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);