participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
524 rows where station_code = "IL0008" 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 |
---|---|---|---|---|---|
5104332 | 5104332 | 20240913020522_vQwo9 | IL0008 | 2024-09-17T12:11:33.424Z | 2024-09-20T12:20:33.984Z |
5078534 | 5078534 | 20240911020310_4U8Ny | IL0008 | 2024-09-15T12:15:42.879Z | 2024-09-19T12:21:40.497Z |
5075801 | 5075801 | 20240912000805_FGwEd | IL0008 | 2024-09-15T12:10:14.555Z | 2024-09-20T12:21:41.103Z |
5075354 | 5075354 | 20240911234239_tm3cG | IL0008 | 2024-09-15T12:09:37.482Z | 2024-09-20T12:21:39.573Z |
5046869 | 5046869 | 20240909014242_U72y0 | IL0008 | 2024-09-13T12:07:45.456Z | 2024-09-17T12:19:00.525Z |
4998129 | 4998129 | 20240903021705_ReZ0u | IL0008 | 2024-09-08T12:07:16.209Z | 2024-09-11T12:21:11.084Z |
4997800 | 4997800 | 20240903012928_xiToz | IL0008 | 2024-09-08T12:06:49.516Z | 2024-09-11T12:21:09.037Z |
4997726 | 4997726 | 20240903011454_2jmHu | IL0008 | 2024-09-08T12:06:43.707Z | 2024-09-11T12:21:08.013Z |
4997660 | 4997660 | 20240903005821_iw1Pl | IL0008 | 2024-09-08T12:06:35.557Z | 2024-09-11T12:21:07.294Z |
4891866 | 4891866 | 20240809014336_ASz1Y | IL0008 | 2024-08-28T12:09:33.289Z | 2024-08-30T12:21:28.268Z |
4891533 | 4891533 | 20240809010952_zhy9q | IL0008 | 2024-08-28T12:09:08.705Z | 2024-08-30T12:21:17.152Z |
4891512 | 4891512 | 20240809010737_AvSdR | IL0008 | 2024-08-28T12:09:07.622Z | 2024-08-30T12:21:16.538Z |
4890546 | 4890546 | 20240808232331_1VSbA | IL0008 | 2024-08-28T12:07:52.317Z | 2024-08-30T12:20:19.485Z |
4889738 | 4889738 | 20240808214241_lIkX0 | IL0008 | 2024-08-28T12:06:40.508Z | 2024-08-30T12:19:33.995Z |
4889643 | 4889643 | 20240808212922_q4o8f | IL0008 | 2024-08-28T12:06:32.494Z | 2024-08-30T12:19:30.507Z |
4888797 | 4888797 | 20240808184914_FeBi6 | IL0008 | 2024-08-28T12:05:08.811Z | 2024-08-30T12:18:38.484Z |
4888255 | 4888255 | 20240808173722_2aRfl | IL0008 | 2024-08-28T12:04:26.336Z | 2024-08-30T12:18:04.923Z |
4880390 | 4880390 | 20240807011907_NJHUm | IL0008 | 2024-08-20T12:13:25.015Z | 2024-08-27T12:14:42.430Z |
4880055 | 4880055 | 20240807011108_Ef0Tr | IL0008 | 2024-08-20T12:13:18.054Z | 2024-08-27T12:14:34.215Z |
4878029 | 4878029 | 20240807001755_XQXpj | IL0008 | 2024-08-19T12:14:02.580Z | 2024-08-27T12:13:34.106Z |
4873849 | 4873849 | 20240806223525_g1eUC | IL0008 | 2024-08-19T12:11:08.714Z | 2024-08-27T12:11:24.211Z |
4822110 | 4822110 | 20240803210150_EBoBb | IL0008 | 2024-08-14T12:16:38.870Z | 2024-08-15T12:24:10.114Z |
4822058 | 4822058 | 20240803205822_qnsMD | IL0008 | 2024-08-14T12:16:33.131Z | 2024-08-15T12:24:08.073Z |
4804677 | 4804677 | 20240802225950_ebqCM | IL0008 | 2024-08-12T12:16:48.175Z | 2024-08-13T12:17:01.089Z |
4796096 | 4796096 | 20240802015614_LQ031 | IL0008 | 2024-08-11T12:15:57.316Z | 2024-08-11T12:15:57.316Z |
4795785 | 4795785 | 20240802014233_S4YU3 | IL0008 | 2024-08-11T12:15:48.951Z | 2024-08-11T12:15:48.951Z |
4795171 | 4795171 | 20240802011310_IOygn | IL0008 | 2024-08-11T12:15:13.879Z | 2024-08-11T12:15:13.879Z |
4784412 | 4784412 | 20240801232628_vMSch | IL0008 | 2024-08-10T12:15:01.429Z | 2024-08-11T12:14:28.818Z |
4783327 | 4783327 | 20240801222055_reF8k | IL0008 | 2024-08-10T12:13:43.587Z | 2024-08-11T12:14:09.570Z |
4782721 | 4782721 | 20240801212517_O2UXU | IL0008 | 2024-08-10T12:12:37.411Z | 2024-08-11T12:13:51.855Z |
4782170 | 4782170 | 20240801194550_gIUf1 | IL0008 | 2024-08-10T12:11:22.636Z | 2024-08-11T12:13:37.589Z |
4778470 | 4778470 | 20240731225813_LRx45 | IL0008 | 2024-08-07T12:13:46.168Z | 2024-08-10T12:21:06.034Z |
4771343 | 4771343 | 20240731010812_qKTK8 | IL0008 | 2024-08-06T12:14:13.977Z | 2024-08-08T12:25:21.695Z |
4770537 | 4770537 | 20240731002914_gVJIu | IL0008 | 2024-08-06T12:14:01.474Z | 2024-08-08T12:25:11.983Z |
4769978 | 4769978 | 20240731214542_uiv8b | IL0008 | 2024-08-06T12:11:25.992Z | 2024-08-10T12:20:50.668Z |
4769461 | 4769461 | 20240731204249_3P7aZ | IL0008 | 2024-08-06T12:10:53.768Z | 2024-08-10T12:20:36.146Z |
4761874 | 4761874 | 20240731013627_2k6kq | IL0008 | 2024-08-06T12:01:12.121Z | 2024-08-10T12:17:28.868Z |
4761375 | 4761375 | 20240731011340_fVkpD | IL0008 | 2024-08-06T12:00:13.438Z | 2024-08-10T12:17:14.897Z |
4761237 | 4761237 | 20240731001153_VTeHU | IL0008 | 2024-08-05T12:16:29.694Z | 2024-08-08T12:25:02.218Z |
4759771 | 4759771 | 20240730230754_B6bGc | IL0008 | 2024-08-05T12:15:35.793Z | 2024-08-08T12:24:14.580Z |
4758978 | 4758978 | 20240730222823_qU82g | IL0008 | 2024-08-05T12:14:50.460Z | 2024-08-08T12:23:47.504Z |
4757533 | 4757533 | 20240730204926_v0cbh | IL0008 | 2024-08-05T12:13:26.364Z | 2024-08-08T12:22:51.890Z |
4757451 | 4757451 | 20240730204008_2q62F | IL0008 | 2024-08-05T12:13:19.065Z | 2024-08-08T12:22:47.280Z |
4744423 | 4744423 | 20240730014700_eQ2wN | IL0008 | 2024-08-04T12:06:18.834Z | 2024-08-08T12:17:52.962Z |
4727179 | 4727179 | 20240728205305_MK82r | IL0008 | 2024-07-31T12:12:49.115Z | 2024-08-05T12:20:25.623Z |
4726945 | 4726945 | 20240728191958_VUPGm | IL0008 | 2024-07-31T12:12:41.897Z | 2024-08-05T12:20:24.528Z |
4671207 | 4671207 | 20240719231137_3mwSF | IL0008 | 2024-07-21T12:02:42.435Z | 2024-07-28T12:14:52.616Z |
4668068 | 4668068 | 20240719012713_mYqYF | IL0008 | 2024-07-20T12:04:15.601Z | 2024-07-27T12:17:14.326Z |
4667950 | 4667950 | 20240719011711_jcEFd | IL0008 | 2024-07-20T12:04:08.882Z | 2024-07-27T12:17:13.903Z |
4667563 | 4667563 | 20240719005408_6UETu | IL0008 | 2024-07-20T12:03:51.767Z | 2024-07-27T12:17:11.636Z |
4667421 | 4667421 | 20240719004557_cipGP | IL0008 | 2024-07-20T12:03:44.799Z | 2024-07-27T12:17:10.804Z |
4667011 | 4667011 | 20240719002605_vRmPY | IL0008 | 2024-07-20T12:03:19.840Z | 2024-07-27T12:17:08.749Z |
4666726 | 4666726 | 20240719000356_zYI62 | IL0008 | 2024-07-20T12:02:49.961Z | 2024-07-27T12:17:06.565Z |
4665671 | 4665671 | 20240718212434_LX2Hp | IL0008 | 2024-07-20T12:01:14.493Z | 2024-07-27T12:16:52.735Z |
4662737 | 4662737 | 20240718014640_7J9Hh | IL0008 | 2024-07-19T12:05:02.372Z | 2024-07-26T12:17:44.921Z |
4662716 | 4662716 | 20240718014406_F3wIA | IL0008 | 2024-07-19T12:05:01.074Z | 2024-07-26T12:17:44.856Z |
4662324 | 4662324 | 20240718004618_uqr7d | IL0008 | 2024-07-19T12:04:22.423Z | 2024-07-26T12:17:40.163Z |
4661923 | 4661923 | 20240717235342_mUVxK | IL0008 | 2024-07-19T12:03:58.924Z | 2024-07-26T12:17:34.977Z |
4659358 | 4659358 | 20240710000642_ItSAs | IL0008 | 2024-07-18T12:16:57.279Z | 2024-07-18T12:16:57.279Z |
4657533 | 4657533 | 20240715233938_d0zjQ | IL0008 | 2024-07-18T12:08:53.540Z | 2024-07-24T12:17:07.534Z |
4657080 | 4657080 | 20240715220843_s0DoO | IL0008 | 2024-07-18T12:08:14.785Z | 2024-07-24T12:17:01.394Z |
4655410 | 4655410 | 20240717003510_a82Kq | IL0008 | 2024-07-18T12:05:53.676Z | 2024-07-25T12:14:01.907Z |
4618801 | 4618801 | 20240710224029_RSMqW | IL0008 | 2024-07-13T12:08:05.828Z | 2024-07-19T12:13:39.691Z |
4611628 | 4611628 | 20240710011032_OKDqc | IL0008 | 2024-07-12T12:06:57.416Z | 2024-07-18T12:16:58.784Z |
4611553 | 4611553 | 20240710004132_21oY6 | IL0008 | 2024-07-12T12:06:55.163Z | 2024-07-18T12:16:58.230Z |
4611506 | 4611506 | 20240710002925_phXOG | IL0008 | 2024-07-12T12:06:53.880Z | 2024-07-18T12:16:57.935Z |
4611290 | 4611290 | 20240709232058_WDqkH | IL0008 | 2024-07-12T12:06:46.533Z | 2024-07-18T12:16:55.479Z |
4602527 | 4602527 | 20240708221510_n4xRF | IL0008 | 2024-07-11T12:09:22.092Z | 2024-07-16T12:09:23.709Z |
4596112 | 4596112 | 20240708011723_m8LXQ | IL0008 | 2024-07-11T12:00:44.091Z | 2024-07-16T12:09:08.451Z |
4595591 | 4595591 | 20240707233048_Eayl0 | IL0008 | 2024-07-10T12:11:12.676Z | 2024-07-15T12:12:27.380Z |
4595541 | 4595541 | 20240707232731_XDLXw | IL0008 | 2024-07-10T12:11:10.439Z | 2024-07-15T12:12:27.099Z |
4595528 | 4595528 | 20240707232645_Ix2to | IL0008 | 2024-07-10T12:11:09.927Z | 2024-07-15T12:12:27.093Z |
4595003 | 4595003 | 20240707224106_uVTBe | IL0008 | 2024-07-10T12:10:42.290Z | 2024-07-15T12:12:24.698Z |
4594547 | 4594547 | 20240707201741_eOiJI | IL0008 | 2024-07-10T12:10:11.608Z | 2024-07-15T12:12:22.638Z |
4588525 | 4588525 | 20240708011114_2CEyf | IL0008 | 2024-07-10T12:01:59.895Z | 2024-07-16T12:09:08.235Z |
4576574 | 4576574 | 20240705203530_DA0jq | IL0008 | 2024-07-08T12:09:40.011Z | 2024-07-13T12:13:02.360Z |
4538114 | 4538114 | 20240702215202_e2qaR | IL0008 | 2024-07-04T12:01:44.670Z | 2024-07-11T12:14:33.282Z |
4519473 | 4519473 | 20240628202844_6goTM | IL0008 | 2024-06-30T12:03:01.028Z | 2024-07-07T12:13:45.111Z |
4513634 | 4513634 | 20240627230039_vXrH5 | IL0008 | 2024-06-29T12:05:43.919Z | 2024-07-06T12:16:21.268Z |
4508789 | 4508789 | 20240626205041_3f6EX | IL0008 | 2024-06-28T12:03:08.196Z | 2024-07-05T12:11:23.761Z |
4503884 | 4503884 | 20240625213739_jZ1c1 | IL0008 | 2024-06-27T12:02:59.583Z | 2024-07-04T12:08:47.004Z |
4492455 | 4492455 | 20240621004146_wXloG | IL0008 | 2024-06-22T12:05:42.703Z | 2024-06-29T12:13:34.643Z |
4489593 | 4489593 | 20240619012534_hpVUT | IL0008 | 2024-06-21T12:08:14.348Z | 2024-06-27T12:11:35.179Z |
4478856 | 4478856 | 20240617232343_EiElc | IL0008 | 2024-06-19T12:07:18.570Z | 2024-06-26T12:14:47.851Z |
4471500 | 4471500 | 20240616002254_iig34 | IL0008 | 2024-06-18T12:00:13.352Z | 2024-06-24T12:10:56.709Z |
4471264 | 4471264 | 20240615210148_MjgEY | IL0008 | 2024-06-17T12:08:36.096Z | 2024-06-23T12:12:37.250Z |
4471250 | 4471250 | 20240615204815_RAxs8 | IL0008 | 2024-06-17T12:08:32.912Z | 2024-06-23T12:12:37.081Z |
4466956 | 4466956 | 20240614193718_7kSAW | IL0008 | 2024-06-16T12:08:04.000Z | 2024-06-22T12:16:38.993Z |
4463919 | 4463919 | 20240615001955_gBHli | IL0008 | 2024-06-16T12:00:53.758Z | 2024-06-23T12:11:33.393Z |
4460448 | 4460448 | 20240614003302_VTcDc | IL0008 | 2024-06-15T12:01:53.024Z | 2024-06-22T12:16:21.722Z |
4460040 | 4460040 | 20240613213436_5TMNz | IL0008 | 2024-06-15T12:00:25.738Z | 2024-06-22T12:16:16.096Z |
4455491 | 4455491 | 20240612223046_Na6mb | IL0008 | 2024-06-14T12:00:52.354Z | 2024-06-21T12:11:27.986Z |
4448925 | 4448925 | 20240611233537_RmCAd | IL0008 | 2024-06-13T12:00:50.423Z | 2024-06-20T12:11:48.294Z |
4448799 | 4448799 | 20240611231206_tX9ZI | IL0008 | 2024-06-13T12:00:40.773Z | 2024-06-20T12:11:47.007Z |
4446037 | 4446037 | 20240611012703_nM9rj | IL0008 | 2024-06-12T12:02:19.328Z | 2024-06-19T12:13:32.389Z |
4441933 | 4441933 | 20240609213031_hbuYQ | IL0008 | 2024-06-11T12:00:50.896Z | 2024-06-18T12:11:01.791Z |
4441899 | 4441899 | 20240609193146_DWcjB | IL0008 | 2024-06-11T12:00:47.101Z | 2024-06-18T12:11:01.611Z |
4436658 | 4436658 | 20240608220428_3Y2GO | IL0008 | 2024-06-10T12:00:36.211Z | 2024-06-17T12:15:02.516Z |
4436592 | 4436592 | 20240608212816_RVbZu | IL0008 | 2024-06-10T12:00:31.099Z | 2024-06-17T12:15:01.808Z |
4433984 | 4433984 | 20240608010907_BX2Uv | IL0008 | 2024-06-09T12:02:23.785Z | 2024-06-16T12:14:10.388Z |
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);