participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
130 rows where station_code = "US0044" 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 |
---|---|---|---|---|---|
5067390 | 5067390 | 20240910092253_wwnOf | US0044 | 2024-09-14T12:18:41.504Z | 2024-09-18T12:15:23.969Z |
5066395 | 5066395 | 20240910072302_LhnDX | US0044 | 2024-09-14T12:17:54.723Z | 2024-09-18T12:15:21.795Z |
5055819 | 5055819 | 20240908090644_2otNd | US0044 | 2024-09-13T12:17:23.490Z | 2024-09-16T12:21:22.138Z |
5049250 | 5049250 | 20240909102709_cyeIk | US0044 | 2024-09-13T12:11:49.545Z | 2024-09-17T12:19:09.608Z |
5011579 | 5011579 | 20240904071816_qy5ta | US0044 | 2024-09-09T12:09:52.976Z | 2024-09-12T12:19:32.609Z |
5001757 | 5001757 | 20240902063527_UuxkI | US0044 | 2024-09-08T12:16:56.498Z | 2024-09-10T12:19:34.504Z |
5001341 | 5001341 | 20240902043628_scRmO | US0044 | 2024-09-08T12:16:20.365Z | 2024-09-10T12:19:32.853Z |
5000621 | 5000621 | 20240902023118_XETet | US0044 | 2024-09-08T12:15:32.022Z | 2024-09-10T12:19:28.909Z |
4958221 | 4958221 | 20240811100526_VEK2z | US0044 | 2024-09-03T12:22:16.486Z | 2024-09-06T12:31:56.370Z |
4958160 | 4958160 | 20240811095959_ZRkfE | US0044 | 2024-09-03T12:22:11.767Z | 2024-09-06T12:31:54.288Z |
4957476 | 4957476 | 20240811084758_xPScQ | US0044 | 2024-09-03T12:21:19.637Z | 2024-09-06T12:31:20.459Z |
4957444 | 4957444 | 20240811084435_t7lFi | US0044 | 2024-09-03T12:21:16.510Z | 2024-09-06T12:31:19.335Z |
4956968 | 4956968 | 20240811080352_Zq3U2 | US0044 | 2024-09-03T12:20:45.140Z | 2024-09-06T12:30:56.439Z |
4956823 | 4956823 | 20240811075206_az50o | US0044 | 2024-09-03T12:20:40.209Z | 2024-09-06T12:30:49.136Z |
4956511 | 4956511 | 20240811072710_oNXm6 | US0044 | 2024-09-03T12:20:29.923Z | 2024-09-06T12:30:35.898Z |
4956018 | 4956018 | 20240811063625_JHZKF | US0044 | 2024-09-03T12:19:44.816Z | 2024-09-06T12:30:07.852Z |
4956006 | 4956006 | 20240811063539_3sFaW | US0044 | 2024-09-03T12:19:43.557Z | 2024-09-06T12:30:07.022Z |
4955510 | 4955510 | 20240811051906_hAOxW | US0044 | 2024-09-03T12:19:16.836Z | 2024-09-06T12:29:45.519Z |
4952402 | 4952402 | 20240811022106_25VD8 | US0044 | 2024-09-03T12:16:57.208Z | 2024-09-06T12:28:00.056Z |
4930873 | 4930873 | 20240810090934_ZhGgu | US0044 | 2024-08-31T12:24:00.947Z | 2024-09-02T12:30:30.157Z |
4930862 | 4930862 | 20240810090744_fv1sM | US0044 | 2024-08-31T12:24:00.102Z | 2024-09-02T12:30:29.453Z |
4930461 | 4930461 | 20240810081624_3NMxo | US0044 | 2024-08-31T12:23:32.039Z | 2024-09-02T12:30:13.729Z |
4930279 | 4930279 | 20240810075058_sYzGD | US0044 | 2024-08-31T12:23:16.026Z | 2024-09-02T12:30:06.447Z |
4929872 | 4929872 | 20240810064708_e5G7B | US0044 | 2024-08-31T12:22:52.689Z | 2024-09-02T12:29:49.627Z |
4929793 | 4929793 | 20240810062123_wOuN3 | US0044 | 2024-08-31T12:22:40.747Z | 2024-09-02T12:29:46.539Z |
4929775 | 4929775 | 20240810061757_0m03p | US0044 | 2024-08-31T12:22:39.957Z | 2024-09-02T12:29:45.752Z |
4929740 | 4929740 | 20240810055653_0jS6D | US0044 | 2024-08-31T12:22:35.925Z | 2024-09-02T12:29:44.096Z |
4929433 | 4929433 | 20240810041002_7j5rP | US0044 | 2024-08-31T12:22:16.372Z | 2024-09-02T12:29:34.431Z |
4904736 | 4904736 | 20240808070605_6xMIU | US0044 | 2024-08-28T12:20:42.494Z | 2024-08-28T12:20:42.494Z |
4903233 | 4903233 | 20240808024555_Uj9Zt | US0044 | 2024-08-28T12:19:32.762Z | 2024-08-28T12:19:32.762Z |
4893406 | 4893406 | 20240809093042_kwj2q | US0044 | 2024-08-28T12:11:25.681Z | 2024-08-30T12:22:56.453Z |
4892677 | 4892677 | 20240809060031_204A3 | US0044 | 2024-08-28T12:10:29.440Z | 2024-08-30T12:22:25.679Z |
4885196 | 4885196 | 20240807082544_paHsw | US0044 | 2024-08-20T12:16:21.685Z | 2024-08-27T12:16:59.980Z |
4885182 | 4885182 | 20240807081706_m9Dmc | US0044 | 2024-08-20T12:16:20.979Z | 2024-08-27T12:16:59.415Z |
4884908 | 4884908 | 20240807070649_3tBr4 | US0044 | 2024-08-20T12:16:06.640Z | 2024-08-27T12:16:38.484Z |
4884827 | 4884827 | 20240807063204_o2W26 | US0044 | 2024-08-20T12:16:03.265Z | 2024-08-27T12:16:35.136Z |
4882687 | 4882687 | 20240807021857_ul5wx | US0044 | 2024-08-20T12:14:35.953Z | 2024-08-27T12:15:37.563Z |
4879116 | 4879116 | 20240807085052_ZR08w | US0044 | 2024-08-20T12:00:11.471Z | 2024-08-28T12:11:46.971Z |
4867995 | 4867995 | 20240806051306_vcRXZ | US0044 | 2024-08-18T12:23:56.052Z | 2024-08-19T12:28:32.057Z |
4847636 | 4847636 | 20240805045951_w2t5F | US0044 | 2024-08-16T12:21:03.725Z | 2024-08-17T12:33:09.718Z |
4847472 | 4847472 | 20240805035903_FX3b7 | US0044 | 2024-08-16T12:20:56.395Z | 2024-08-17T12:33:03.499Z |
4837790 | 4837790 | 20240805074834_SE3Xo | US0044 | 2024-08-16T12:01:22.966Z | 2024-08-19T12:15:24.659Z |
4826609 | 4826609 | 20240804050055_Wbt2u | US0044 | 2024-08-14T12:21:15.979Z | 2024-08-15T12:26:22.560Z |
4818235 | 4818235 | 20240804085043_mUS20 | US0044 | 2024-08-14T12:02:18.399Z | 2024-08-17T12:24:26.850Z |
4818211 | 4818211 | 20240804084845_6ezbj | US0044 | 2024-08-14T12:02:15.608Z | 2024-08-17T12:24:25.240Z |
4817785 | 4817785 | 20240804074541_Qldd7 | US0044 | 2024-08-14T12:01:12.648Z | 2024-08-17T12:23:47.042Z |
4817515 | 4817515 | 20240804062152_lzYPs | US0044 | 2024-08-14T12:00:29.487Z | 2024-08-17T12:23:24.305Z |
4806870 | 4806870 | 20240803090701_qhkmM | US0044 | 2024-08-13T12:01:46.412Z | 2024-08-15T12:18:11.285Z |
4788159 | 4788159 | 20240802083834_VyVjm | US0044 | 2024-08-11T12:03:55.758Z | 2024-08-13T12:15:45.236Z |
4773230 | 4773230 | 20240801092912_WBcdJ | US0044 | 2024-08-07T12:05:31.105Z | 2024-08-11T12:11:53.896Z |
4772245 | 4772245 | 20240801063123_Q13b6 | US0044 | 2024-08-07T12:02:59.352Z | 2024-08-11T12:11:20.593Z |
4772152 | 4772152 | 20240801060849_2JS3a | US0044 | 2024-08-07T12:02:37.683Z | 2024-08-11T12:11:17.145Z |
4746709 | 4746709 | 20240730061831_uu3mx | US0044 | 2024-08-04T12:09:24.987Z | 2024-08-08T12:19:02.094Z |
4746654 | 4746654 | 20240730060004_7NZPo | US0044 | 2024-08-04T12:09:20.892Z | 2024-08-08T12:18:59.226Z |
4737040 | 4737040 | 20240729074043_y2dOh | US0044 | 2024-08-01T12:06:05.248Z | 2024-08-06T12:15:05.175Z |
4665117 | 4665117 | 20240717072942_EPDXQ | US0044 | 2024-07-19T12:09:28.444Z | 2024-07-25T12:14:12.859Z |
4636112 | 4636112 | 20240714090452_Y9i2q | US0044 | 2024-07-16T12:01:01.487Z | 2024-07-23T12:08:32.911Z |
4628525 | 4628525 | 20240713084314_LCF3z | US0044 | 2024-07-15T12:00:47.568Z | 2024-07-22T12:09:54.921Z |
4628306 | 4628306 | 20240713074008_tW6AZ | US0044 | 2024-07-15T12:00:27.506Z | 2024-07-22T12:09:53.819Z |
4628238 | 4628238 | 20240713072018_DNrx9 | US0044 | 2024-07-15T12:00:21.579Z | 2024-07-22T12:09:53.424Z |
4621529 | 4621529 | 20240712075635_Zkunc | US0044 | 2024-07-14T12:01:10.594Z | 2024-07-21T12:13:16.276Z |
4621359 | 4621359 | 20240712071354_zw6b9 | US0044 | 2024-07-14T12:00:54.205Z | 2024-07-21T12:13:15.618Z |
4612494 | 4612494 | 20240711074133_m4WHN | US0044 | 2024-07-13T12:01:01.974Z | 2024-07-20T12:13:06.507Z |
4612281 | 4612281 | 20240711064904_TCYDq | US0044 | 2024-07-13T12:00:37.089Z | 2024-07-20T12:13:06.053Z |
4563170 | 4563170 | 20240705055953_BxC3z | US0044 | 2024-07-07T12:04:54.607Z | 2024-07-13T12:12:51.210Z |
4554772 | 4554772 | 20240704073338_WORAM | US0044 | 2024-07-06T12:04:52.772Z | 2024-07-12T12:08:55.512Z |
4505925 | 4505925 | 20240626084227_BDJo9 | US0044 | 2024-06-27T12:05:13.486Z | 2024-07-04T12:08:57.802Z |
4505784 | 4505784 | 20240626075538_rUDT5 | US0044 | 2024-06-27T12:05:02.809Z | 2024-07-04T12:08:57.269Z |
4505782 | 4505782 | 20240626075422_gH2hZ | US0044 | 2024-06-27T12:05:02.682Z | 2024-07-04T12:08:57.268Z |
4505768 | 4505768 | 20240626074458_dpO5s | US0044 | 2024-06-27T12:05:01.978Z | 2024-07-04T12:08:57.153Z |
4505534 | 4505534 | 20240626032951_T3y3N | US0044 | 2024-06-27T12:04:49.854Z | 2024-07-04T12:08:55.857Z |
4502003 | 4502003 | 20240625080320_UpOUW | US0044 | 2024-06-26T12:06:21.136Z | 2024-07-03T12:13:22.346Z |
4489954 | 4489954 | 20240621083702_e2S3l | US0044 | 2024-06-22T12:00:31.864Z | 2024-06-30T12:09:34.055Z |
4489948 | 4489948 | 20240621082756_VdaLw | US0044 | 2024-06-22T12:00:30.890Z | 2024-06-30T12:09:34.023Z |
4489923 | 4489923 | 20240621073910_7LI9L | US0044 | 2024-06-22T12:00:28.122Z | 2024-06-30T12:09:33.911Z |
4489867 | 4489867 | 20240621064010_TY4Y2 | US0044 | 2024-06-22T12:00:19.564Z | 2024-06-30T12:09:33.265Z |
4485389 | 4485389 | 20240620090802_3ZZWt | US0044 | 2024-06-21T12:00:40.048Z | 2024-06-29T12:13:20.730Z |
4464363 | 4464363 | 20240615042938_2IDHQ | US0044 | 2024-06-16T12:02:12.870Z | 2024-06-23T12:11:45.792Z |
4457377 | 4457377 | 20240613074345_K2wQg | US0044 | 2024-06-14T12:02:57.198Z | 2024-06-21T12:11:38.993Z |
4457275 | 4457275 | 20240613071251_2kXEJ | US0044 | 2024-06-14T12:02:49.565Z | 2024-06-21T12:11:38.364Z |
4450197 | 4450197 | 20240612071706_ziddx | US0044 | 2024-06-13T12:02:27.089Z | 2024-06-20T12:11:57.764Z |
4440269 | 4440269 | 20240608083101_NxhON | US0044 | 2024-06-10T12:03:44.738Z | 2024-06-16T12:14:16.392Z |
4411515 | 4411515 | 20240603055516_J3wR6 | US0044 | 2024-06-05T12:09:16.432Z | 2024-06-11T12:13:41.812Z |
4411352 | 4411352 | 20240603015656_1xcLn | US0044 | 2024-06-05T12:08:56.902Z | 2024-06-11T12:13:38.778Z |
4377521 | 4377521 | 20240527034205_653Nz | US0044 | 2024-05-28T12:00:10.613Z | 2024-06-05T12:17:41.965Z |
4357780 | 4357780 | 20240511051025_vmEnK | US0044 | 2024-05-22T12:12:14.716Z | 2024-05-22T12:12:14.716Z |
4356937 | 4356937 | 20240512091350_t88xx | US0044 | 2024-05-22T12:07:56.739Z | 2024-05-22T12:07:56.739Z |
4356611 | 4356611 | 20240512070510_tJ0q2 | US0044 | 2024-05-22T12:07:30.581Z | 2024-05-22T12:07:30.581Z |
4267285 | 4267285 | 20240502071751_hD2PJ | US0044 | 2024-05-04T12:01:14.520Z | 2024-05-11T12:25:12.316Z |
4267237 | 4267237 | 20240502070856_33Zkp | US0044 | 2024-05-04T12:01:02.626Z | 2024-05-11T12:25:09.522Z |
4266732 | 4266732 | 20240502032639_m8iYf | US0044 | 2024-05-03T12:08:35.480Z | 2024-05-10T12:23:51.501Z |
4231682 | 4231682 | 20240422090652_mKxPj | US0044 | 2024-04-25T12:02:49.364Z | 2024-04-30T12:17:22.982Z |
4110976 | 4110976 | 20240324074415_LfK0N | US0044 | 2024-03-25T12:04:07.569Z | 2024-04-01T12:16:13.172Z |
4094792 | 4094792 | 20240319081035_ugQFo | US0044 | 2024-03-21T12:10:27.963Z | 2024-03-27T12:19:26.629Z |
4094729 | 4094729 | 20240319071549_gzNFC | US0044 | 2024-03-21T12:10:20.753Z | 2024-03-27T12:19:24.506Z |
4087995 | 4087995 | 20240317055910_CxAN9 | US0044 | 2024-03-19T12:13:23.256Z | 2024-03-25T12:22:27.562Z |
4072232 | 4072232 | 20240314071503_ffFUj | US0044 | 2024-03-16T12:12:17.149Z | 2024-03-22T12:17:42.845Z |
4068511 | 4068511 | 20240313072434_1nXUs | US0044 | 2024-03-15T12:09:02.671Z | 2024-03-21T12:22:21.928Z |
4065845 | 4065845 | 20240313050558_uvLNn | US0044 | 2024-03-14T12:08:32.255Z | 2024-03-21T12:22:19.233Z |
4063824 | 4063824 | 20240312093840_ImCKX | US0044 | 2024-03-13T12:07:10.566Z | 2024-03-20T12:21:41.947Z |
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);