participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00Q" 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 |
---|---|---|---|---|---|
5565412 | 5565412 | 20241120042343_fp3m0 | USL00Q | 2024-11-21T14:18:48.332Z | 2024-11-21T14:18:54.205Z |
5565108 | 5565108 | 20241120035207_mcynr | USL00Q | 2024-11-21T14:18:31.007Z | 2024-11-21T14:18:54.155Z |
5563909 | 5563909 | 20241120021458_3oAME | USL00Q | 2024-11-21T14:16:56.991Z | 2024-11-21T14:18:53.944Z |
5563903 | 5563903 | 20241120021455_HxBnx | USL00Q | 2024-11-21T14:16:56.569Z | 2024-11-21T14:18:53.943Z |
5560468 | 5560468 | 20241120125421_qknQj | USL00Q | 2024-11-21T14:08:55.061Z | 2024-11-21T14:08:55.061Z |
5560419 | 5560419 | 20241120125001_9heYe | USL00Q | 2024-11-21T14:08:49.298Z | 2024-11-21T14:08:49.298Z |
5560416 | 5560416 | 20241120124902_2TiYR | USL00Q | 2024-11-21T14:08:48.919Z | 2024-11-21T14:08:48.919Z |
5560294 | 5560294 | 20241120123040_BzcxN | USL00Q | 2024-11-21T14:08:32.353Z | 2024-11-21T14:08:32.353Z |
5560281 | 5560281 | 20241120122937_9Z4RQ | USL00Q | 2024-11-21T14:08:30.003Z | 2024-11-21T14:08:30.003Z |
5560269 | 5560269 | 20241120122904_GPk3l | USL00Q | 2024-11-21T14:08:27.120Z | 2024-11-21T14:08:27.120Z |
5560262 | 5560262 | 20241120122653_PQAgY | USL00Q | 2024-11-21T14:08:26.149Z | 2024-11-21T14:08:26.149Z |
5560176 | 5560176 | 20241120121338_selLI | USL00Q | 2024-11-21T14:08:11.538Z | 2024-11-21T14:08:11.538Z |
5560167 | 5560167 | 20241120121015_1J63m | USL00Q | 2024-11-21T14:08:10.761Z | 2024-11-21T14:08:10.761Z |
5560085 | 5560085 | 20241120115745_Ek9P7 | USL00Q | 2024-11-21T14:08:00.693Z | 2024-11-21T14:08:00.693Z |
5560011 | 5560011 | 20241120114605_cZIxp | USL00Q | 2024-11-21T14:07:51.521Z | 2024-11-21T14:07:51.521Z |
5560004 | 5560004 | 20241120114537_2f42Q | USL00Q | 2024-11-21T14:07:50.777Z | 2024-11-21T14:07:50.777Z |
5559930 | 5559930 | 20241120113547_ign65 | USL00Q | 2024-11-21T14:07:35.662Z | 2024-11-21T14:07:35.662Z |
5559866 | 5559866 | 20241120112805_Bfdkw | USL00Q | 2024-11-21T14:07:21.723Z | 2024-11-21T14:07:21.723Z |
5559745 | 5559745 | 20241120111157_A3Rvm | USL00Q | 2024-11-21T14:07:06.198Z | 2024-11-21T14:07:06.198Z |
5559665 | 5559665 | 20241120105549_HfXzQ | USL00Q | 2024-11-21T14:06:56.010Z | 2024-11-21T14:06:56.010Z |
5559616 | 5559616 | 20241120104922_negQB | USL00Q | 2024-11-21T14:06:44.104Z | 2024-11-21T14:06:44.104Z |
5559523 | 5559523 | 20241120103840_xfBMO | USL00Q | 2024-11-21T14:06:31.588Z | 2024-11-21T14:06:31.588Z |
5559334 | 5559334 | 20241120100525_IU83O | USL00Q | 2024-11-21T14:06:00.536Z | 2024-11-21T14:06:00.536Z |
5559297 | 5559297 | 20241120095736_0NUSb | USL00Q | 2024-11-21T14:05:52.941Z | 2024-11-21T14:05:52.941Z |
5559116 | 5559116 | 20241120092600_s2wD3 | USL00Q | 2024-11-21T14:05:24.470Z | 2024-11-21T14:05:24.470Z |
5558937 | 5558937 | 20241120085237_5ZH0N | USL00Q | 2024-11-21T14:04:50.750Z | 2024-11-21T14:04:50.750Z |
5558886 | 5558886 | 20241120084330_RyIyo | USL00Q | 2024-11-21T14:04:43.608Z | 2024-11-21T14:04:43.608Z |
5558571 | 5558571 | 20241120063952_BrRPa | USL00Q | 2024-11-21T14:03:42.755Z | 2024-11-21T14:03:42.755Z |
5558312 | 5558312 | 20241120055457_C3ypp | USL00Q | 2024-11-21T14:02:59.607Z | 2024-11-21T14:02:59.607Z |
5557723 | 5557723 | 20241120050754_stRD4 | USL00Q | 2024-11-21T14:01:35.399Z | 2024-11-21T14:01:35.399Z |
5557519 | 5557519 | 20241120045325_2Qqal | USL00Q | 2024-11-21T14:01:04.703Z | 2024-11-21T14:01:04.703Z |
5557325 | 5557325 | 20241120043928_4ZChK | USL00Q | 2024-11-21T14:00:32.654Z | 2024-11-21T14:00:32.654Z |
5557087 | 5557087 | 20241119034941_kK3nb | USL00Q | 2024-11-20T14:12:15.060Z | 2024-11-21T14:20:45.963Z |
5557066 | 5557066 | 20241119034151_GFYWB | USL00Q | 2024-11-20T14:12:10.700Z | 2024-11-21T14:20:45.211Z |
5557052 | 5557052 | 20241119033224_Jk06m | USL00Q | 2024-11-20T14:12:04.718Z | 2024-11-21T14:20:44.709Z |
5556936 | 5556936 | 20241119025736_tj7Ii | USL00Q | 2024-11-20T14:11:42.804Z | 2024-11-21T14:20:40.080Z |
5556855 | 5556855 | 20241119021836_aWYcQ | USL00Q | 2024-11-20T14:11:34.293Z | 2024-11-21T14:20:37.242Z |
5555348 | 5555348 | 20241119125354_BnBxT | USL00Q | 2024-11-20T14:05:15.644Z | 2024-11-21T14:18:53.258Z |
5555309 | 5555309 | 20241119123817_4UU2t | USL00Q | 2024-11-20T14:05:08.766Z | 2024-11-21T14:18:53.248Z |
5555307 | 5555307 | 20241119123815_omQtJ | USL00Q | 2024-11-20T14:05:08.135Z | 2024-11-21T14:18:53.247Z |
5555269 | 5555269 | 20241119122646_bXKnF | USL00Q | 2024-11-20T14:05:03.221Z | 2024-11-21T14:18:53.239Z |
5555245 | 5555245 | 20241119122203_Rx0eN | USL00Q | 2024-11-20T14:05:00.315Z | 2024-11-21T14:18:53.234Z |
5555213 | 5555213 | 20241119121620_RVhSx | USL00Q | 2024-11-20T14:04:48.228Z | 2024-11-21T14:18:53.228Z |
5555203 | 5555203 | 20241119121343_6Mal5 | USL00Q | 2024-11-20T14:04:43.707Z | 2024-11-21T14:18:53.226Z |
5555193 | 5555193 | 20241119120752_PjmeW | USL00Q | 2024-11-20T14:04:42.065Z | 2024-11-21T14:18:53.223Z |
5555168 | 5555168 | 20241119115959_9tiMd | USL00Q | 2024-11-20T14:04:36.138Z | 2024-11-21T14:18:53.216Z |
5555120 | 5555120 | 20241119114759_WMN1C | USL00Q | 2024-11-20T14:04:30.005Z | 2024-11-21T14:18:53.206Z |
5555068 | 5555068 | 20241119113217_bSwZd | USL00Q | 2024-11-20T14:04:22.691Z | 2024-11-21T14:18:53.195Z |
5555054 | 5555054 | 20241119112754_WYJdP | USL00Q | 2024-11-20T14:04:18.754Z | 2024-11-21T14:18:53.191Z |
5555037 | 5555037 | 20241119112427_XS37s | USL00Q | 2024-11-20T14:04:10.205Z | 2024-11-21T14:18:53.187Z |
5554985 | 5554985 | 20241119111535_JhcM4 | USL00Q | 2024-11-20T14:04:00.048Z | 2024-11-21T14:18:53.178Z |
5554862 | 5554862 | 20241119105046_TJX2R | USL00Q | 2024-11-20T14:03:39.142Z | 2024-11-21T14:18:53.150Z |
5554768 | 5554768 | 20241119103349_M20Vl | USL00Q | 2024-11-20T14:03:13.319Z | 2024-11-21T14:18:53.128Z |
5554749 | 5554749 | 20241119102152_MBAA9 | USL00Q | 2024-11-20T14:03:10.901Z | 2024-11-21T14:18:53.124Z |
5554671 | 5554671 | 20241119100245_Spupy | USL00Q | 2024-11-20T14:02:58.701Z | 2024-11-21T14:18:53.106Z |
5554612 | 5554612 | 20241119094805_USGXg | USL00Q | 2024-11-20T14:02:40.028Z | 2024-11-21T14:18:53.094Z |
5554553 | 5554553 | 20241119093424_nirFx | USL00Q | 2024-11-20T14:02:26.283Z | 2024-11-21T14:18:53.080Z |
5554361 | 5554361 | 20241119082804_nZkLI | USL00Q | 2024-11-20T14:01:45.926Z | 2024-11-21T14:18:53.036Z |
5554313 | 5554313 | 20241119080131_ddiNW | USL00Q | 2024-11-20T14:01:33.597Z | 2024-11-21T14:18:53.025Z |
5553857 | 5553857 | 20241118043329_snQsR | USL00Q | 2024-11-19T14:11:30.258Z | 2024-11-21T14:22:22.838Z |
5553646 | 5553646 | 20241118034003_2d38z | USL00Q | 2024-11-19T14:11:08.883Z | 2024-11-21T14:22:18.617Z |
5553392 | 5553392 | 20241118021823_2xo3o | USL00Q | 2024-11-19T14:10:27.421Z | 2024-11-21T14:22:13.256Z |
5553233 | 5553233 | 20241118014451_FDfsy | USL00Q | 2024-11-19T14:10:11.128Z | 2024-11-21T14:22:09.424Z |
5553229 | 5553229 | 20241118014428_Nmkf5 | USL00Q | 2024-11-19T14:10:10.877Z | 2024-11-21T14:22:09.367Z |
5551337 | 5551337 | 20241118130947_HNDLd | USL00Q | 2024-11-19T14:04:29.491Z | 2024-11-21T14:19:48.992Z |
5551322 | 5551322 | 20241118130636_2w2Y6 | USL00Q | 2024-11-19T14:04:25.055Z | 2024-11-21T14:19:48.461Z |
5551299 | 5551299 | 20241118125817_LFY9O | USL00Q | 2024-11-19T14:04:19.200Z | 2024-11-21T14:19:47.769Z |
5551264 | 5551264 | 20241118125054_9pDre | USL00Q | 2024-11-19T14:04:11.684Z | 2024-11-21T14:19:46.980Z |
5551260 | 5551260 | 20241118125039_sMdgQ | USL00Q | 2024-11-19T14:04:11.136Z | 2024-11-21T14:19:46.856Z |
5551238 | 5551238 | 20241118124826_d1JzV | USL00Q | 2024-11-19T14:04:08.648Z | 2024-11-21T14:19:46.495Z |
5551193 | 5551193 | 20241118124245_0raLw | USL00Q | 2024-11-19T14:04:05.497Z | 2024-11-21T14:19:45.476Z |
5551184 | 5551184 | 20241118124207_NMIzK | USL00Q | 2024-11-19T14:04:04.493Z | 2024-11-21T14:19:45.270Z |
5551126 | 5551126 | 20241118122947_uejMd | USL00Q | 2024-11-19T14:03:56.847Z | 2024-11-21T14:19:44.038Z |
5551106 | 5551106 | 20241118122616_jK3H4 | USL00Q | 2024-11-19T14:03:55.550Z | 2024-11-21T14:19:43.489Z |
5551035 | 5551035 | 20241118121301_A90kH | USL00Q | 2024-11-19T14:03:48.331Z | 2024-11-21T14:19:41.734Z |
5551018 | 5551018 | 20241118120914_i2H4u | USL00Q | 2024-11-19T14:03:46.779Z | 2024-11-21T14:19:41.270Z |
5550999 | 5550999 | 20241118120741_F12BV | USL00Q | 2024-11-19T14:03:45.324Z | 2024-11-21T14:19:40.843Z |
5550966 | 5550966 | 20241118120402_fdqFC | USL00Q | 2024-11-19T14:03:41.899Z | 2024-11-21T14:19:40.011Z |
5550911 | 5550911 | 20241118114829_D5HEo | USL00Q | 2024-11-19T14:03:25.136Z | 2024-11-21T14:19:37.594Z |
5550838 | 5550838 | 20241118113436_jTFDH | USL00Q | 2024-11-19T14:03:11.460Z | 2024-11-21T14:19:34.137Z |
5550787 | 5550787 | 20241118112617_LpiAn | USL00Q | 2024-11-19T14:03:06.100Z | 2024-11-21T14:19:32.592Z |
5550769 | 5550769 | 20241118112326_X6Tp2 | USL00Q | 2024-11-19T14:03:03.685Z | 2024-11-21T14:19:31.041Z |
5550752 | 5550752 | 20241118112053_xsKYq | USL00Q | 2024-11-19T14:03:01.621Z | 2024-11-21T14:19:29.566Z |
5550614 | 5550614 | 20241118105710_wW22D | USL00Q | 2024-11-19T14:02:49.019Z | 2024-11-21T14:19:25.878Z |
5550592 | 5550592 | 20241118105256_aX8mh | USL00Q | 2024-11-19T14:02:43.147Z | 2024-11-21T14:19:25.067Z |
5550463 | 5550463 | 20241118102340_jn3Ag | USL00Q | 2024-11-19T14:02:22.903Z | 2024-11-21T14:19:18.896Z |
5550461 | 5550461 | 20241118102308_va6MD | USL00Q | 2024-11-19T14:02:22.643Z | 2024-11-21T14:19:18.875Z |
5550343 | 5550343 | 20241118100832_vHwC5 | USL00Q | 2024-11-19T14:02:12.924Z | 2024-11-21T14:19:15.152Z |
5550318 | 5550318 | 20241118100711_C3XgQ | USL00Q | 2024-11-19T14:02:11.159Z | 2024-11-21T14:19:14.444Z |
5550296 | 5550296 | 20241118100052_oQDOZ | USL00Q | 2024-11-19T14:02:08.066Z | 2024-11-21T14:19:12.910Z |
5550260 | 5550260 | 20241118095449_deNf1 | USL00Q | 2024-11-19T14:01:59.186Z | 2024-11-21T14:19:11.906Z |
5550255 | 5550255 | 20241118095343_423zA | USL00Q | 2024-11-19T14:01:57.845Z | 2024-11-21T14:19:11.577Z |
5550235 | 5550235 | 20241118095030_5iF6D | USL00Q | 2024-11-19T14:01:52.348Z | 2024-11-21T14:19:10.486Z |
5550202 | 5550202 | 20241118094614_uvUgn | USL00Q | 2024-11-19T14:01:45.199Z | 2024-11-21T14:19:08.486Z |
5550129 | 5550129 | 20241118093511_e8UO5 | USL00Q | 2024-11-19T14:01:36.657Z | 2024-11-21T14:19:06.456Z |
5550104 | 5550104 | 20241118093004_0h5rY | USL00Q | 2024-11-19T14:01:34.742Z | 2024-11-21T14:19:05.331Z |
5549918 | 5549918 | 20241118084354_Anpp2 | USL00Q | 2024-11-19T14:01:13.989Z | 2024-11-21T14:19:02.722Z |
5549870 | 5549870 | 20241118082508_09V7Q | USL00Q | 2024-11-19T14:01:01.950Z | 2024-11-21T14:19:02.160Z |
5549854 | 5549854 | 20241118080601_CdPve | USL00Q | 2024-11-19T14:01:00.154Z | 2024-11-21T14:19:01.891Z |
5549839 | 5549839 | 20241118075334_eEonI | USL00Q | 2024-11-19T14:00:58.351Z | 2024-11-21T14:19:01.626Z |
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);