participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
172 rows where station_code = "NZ002M" 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 |
---|---|---|---|---|---|
5138207 | 5138207 | 20240919163955_WwOEm | NZ002M | 2024-09-20T12:06:26.155Z | 2024-09-20T12:06:55.407Z |
5005279 | 5005279 | 20240903144620_3fKfJ | NZ002M | 2024-09-09T12:03:33.333Z | 2024-09-12T12:19:05.636Z |
4910623 | 4910623 | 20240809182231_AAbeb | NZ002M | 2024-08-29T12:06:25.071Z | 2024-09-02T12:21:00.766Z |
4888736 | 4888736 | 20240808183830_127hk | NZ002M | 2024-08-28T12:05:04.762Z | 2024-08-30T12:18:35.758Z |
4865920 | 4865920 | 20240806152146_bnsW2 | NZ002M | 2024-08-18T12:07:17.962Z | 2024-08-27T12:06:35.895Z |
4860707 | 4860707 | 20240806105554_2cYOY | NZ002M | 2024-08-18T12:03:03.839Z | 2024-08-27T12:02:59.463Z |
4846988 | 4846988 | 20240805163608_PP8CX | NZ002M | 2024-08-16T12:10:42.757Z | 2024-08-19T12:21:03.791Z |
4817092 | 4817092 | 20240803183658_zfpX3 | NZ002M | 2024-08-13T12:14:48.132Z | 2024-08-15T12:23:11.097Z |
4809735 | 4809735 | 20240803122954_QBeub | NZ002M | 2024-08-13T12:07:32.524Z | 2024-08-15T12:19:46.103Z |
4799830 | 4799830 | 20240802163403_LE2ee | NZ002M | 2024-08-12T12:10:28.025Z | 2024-08-13T12:16:22.018Z |
4793333 | 4793333 | 20240802142541_WPOWA | NZ002M | 2024-08-11T12:09:24.672Z | 2024-08-13T12:16:12.453Z |
4791872 | 4791872 | 20240802132403_7qY6f | NZ002M | 2024-08-11T12:08:26.305Z | 2024-08-13T12:16:08.806Z |
4789890 | 4789890 | 20240802112043_DejsK | NZ002M | 2024-08-11T12:06:30.060Z | 2024-08-13T12:16:03.548Z |
4788926 | 4788926 | 20240802100528_MsD9i | NZ002M | 2024-08-11T12:05:21.069Z | 2024-08-13T12:15:55.766Z |
4778044 | 4778044 | 20240801182946_z5G0O | NZ002M | 2024-08-07T12:11:05.283Z | 2024-08-11T12:13:28.089Z |
4777863 | 4777863 | 20240801180121_QFHqg | NZ002M | 2024-08-07T12:10:57.072Z | 2024-08-11T12:13:23.397Z |
4776720 | 4776720 | 20240801152657_tPw6h | NZ002M | 2024-08-07T12:09:41.401Z | 2024-08-11T12:12:54.359Z |
4765055 | 4765055 | 20240731095852_oud2w | NZ002M | 2024-08-06T12:06:58.626Z | 2024-08-10T12:19:00.910Z |
4724175 | 4724175 | 20240728101937_VViQE | NZ002M | 2024-07-31T12:10:18.205Z | 2024-08-05T12:20:16.671Z |
4678840 | 4678840 | 20240723112549_Yuont | NZ002M | 2024-07-24T12:04:42.259Z | 2024-07-31T12:18:03.490Z |
4678155 | 4678155 | 20240723063337_ucD8N | NZ002M | 2024-07-24T12:03:15.948Z | 2024-07-31T12:17:58.431Z |
4670639 | 4670639 | 20240719190621_I1YMW | NZ002M | 2024-07-21T12:01:42.780Z | 2024-07-28T12:14:50.096Z |
4670390 | 4670390 | 20240719150306_2Tzqz | NZ002M | 2024-07-21T12:01:07.062Z | 2024-07-28T12:14:48.731Z |
4645401 | 4645401 | 20240714164201_2qAqa | NZ002M | 2024-07-17T12:04:05.137Z | 2024-07-23T12:08:36.561Z |
4645268 | 4645268 | 20240714155402_Oubkt | NZ002M | 2024-07-17T12:03:58.781Z | 2024-07-23T12:08:36.310Z |
4638176 | 4638176 | 20240713164801_f24EK | NZ002M | 2024-07-16T12:04:00.368Z | 2024-07-22T12:10:04.526Z |
4638172 | 4638172 | 20240713164611_SNSrk | NZ002M | 2024-07-16T12:03:59.961Z | 2024-07-22T12:10:04.525Z |
4637894 | 4637894 | 20240713162417_uZCBR | NZ002M | 2024-07-16T12:03:45.538Z | 2024-07-22T12:10:03.923Z |
4637835 | 4637835 | 20240713161727_Gc5DJ | NZ002M | 2024-07-16T12:03:43.215Z | 2024-07-22T12:10:03.817Z |
4636539 | 4636539 | 20240714105822_3Gz6E | NZ002M | 2024-07-16T12:01:36.451Z | 2024-07-23T12:08:34.613Z |
4636532 | 4636532 | 20240714105540_azjtw | NZ002M | 2024-07-16T12:01:35.792Z | 2024-07-23T12:08:34.581Z |
4633691 | 4633691 | 20240712170248_Iy6IM | NZ002M | 2024-07-15T12:06:05.296Z | 2024-07-21T12:13:26.935Z |
4630442 | 4630442 | 20240713140408_NSwdY | NZ002M | 2024-07-15T12:03:01.155Z | 2024-07-22T12:10:01.262Z |
4629266 | 4629266 | 20240713110259_AStu3 | NZ002M | 2024-07-15T12:01:49.000Z | 2024-07-22T12:09:58.021Z |
4627037 | 4627037 | 20240711182723_KGO2q | NZ002M | 2024-07-14T12:07:49.453Z | 2024-07-20T12:13:12.665Z |
4615356 | 4615356 | 20240710144312_TnWtv | NZ002M | 2024-07-13T12:05:04.091Z | 2024-07-19T12:13:36.065Z |
4614164 | 4614164 | 20240710124036_E14Hq | NZ002M | 2024-07-13T12:03:55.402Z | 2024-07-19T12:13:35.406Z |
4576187 | 4576187 | 20240705185730_8f5tf | NZ002M | 2024-07-08T12:09:25.389Z | 2024-07-13T12:13:01.637Z |
4575084 | 4575084 | 20240705161003_ROkyV | NZ002M | 2024-07-08T12:08:59.156Z | 2024-07-13T12:13:00.140Z |
4567638 | 4567638 | 20240704171520_nKnNa | NZ002M | 2024-07-07T12:11:10.142Z | 2024-07-12T12:09:00.161Z |
4555442 | 4555442 | 20240704085600_yrjxK | NZ002M | 2024-07-06T12:06:11.794Z | 2024-07-12T12:08:56.131Z |
4550064 | 4550064 | 20240703153507_HOJ0D | NZ002M | 2024-07-05T12:06:32.612Z | 2024-07-11T12:14:44.534Z |
4548060 | 4548060 | 20240703130505_N1l4v | NZ002M | 2024-07-05T12:05:25.883Z | 2024-07-11T12:14:43.836Z |
4546242 | 4546242 | 20240703094734_zxifw | NZ002M | 2024-07-05T12:04:02.392Z | 2024-07-11T12:14:42.769Z |
4524750 | 4524750 | 20240629144615_pQ4zy | NZ002M | 2024-07-01T12:00:32.875Z | 2024-07-08T12:11:43.688Z |
4498777 | 4498777 | 20240624102122_xYOF3 | NZ002M | 2024-06-26T12:01:17.982Z | 2024-07-03T12:13:03.337Z |
4491663 | 4491663 | 20240620192103_HfiDe | NZ002M | 2024-06-22T12:04:35.892Z | 2024-06-29T12:13:30.575Z |
4487807 | 4487807 | 20240619190627_FkfQt | NZ002M | 2024-06-21T12:04:24.096Z | 2024-06-28T12:09:34.522Z |
4487128 | 4487128 | 20240619161926_uK695 | NZ002M | 2024-06-21T12:03:28.205Z | 2024-06-28T12:09:32.645Z |
4487034 | 4487034 | 20240619153504_HNECo | NZ002M | 2024-06-21T12:03:21.439Z | 2024-06-28T12:09:32.377Z |
4486830 | 4486830 | 20240619124913_LlcN7 | NZ002M | 2024-06-21T12:03:01.004Z | 2024-06-28T12:09:31.815Z |
4484229 | 4484229 | 20240618191622_1HqGE | NZ002M | 2024-06-20T12:05:18.250Z | 2024-06-27T12:11:28.096Z |
4483895 | 4483895 | 20240618181247_iFpGV | NZ002M | 2024-06-20T12:04:43.475Z | 2024-06-27T12:11:25.980Z |
4483386 | 4483386 | 20240618170343_8EGI2 | NZ002M | 2024-06-20T12:04:04.224Z | 2024-06-27T12:11:21.817Z |
4483181 | 4483181 | 20240618163833_iU2sE | NZ002M | 2024-06-20T12:03:43.971Z | 2024-06-27T12:11:20.587Z |
4454156 | 4454156 | 20240611170718_cU7zy | NZ002M | 2024-06-13T12:06:04.317Z | 2024-06-19T12:13:47.545Z |
4454076 | 4454076 | 20240611165630_RPHzz | NZ002M | 2024-06-13T12:06:02.366Z | 2024-06-19T12:13:47.424Z |
4451394 | 4451394 | 20240611095300_v1SSV | NZ002M | 2024-06-13T12:04:22.858Z | 2024-06-19T12:13:40.059Z |
4451065 | 4451065 | 20240611081637_ABOmj | NZ002M | 2024-06-13T12:04:05.138Z | 2024-06-19T12:13:37.029Z |
4447674 | 4447674 | 20240610154241_o6ZvJ | NZ002M | 2024-06-12T12:05:41.655Z | 2024-06-18T12:11:15.216Z |
4447485 | 4447485 | 20240610145853_3Skvl | NZ002M | 2024-06-12T12:05:30.996Z | 2024-06-18T12:11:14.918Z |
4443680 | 4443680 | 20240610124626_3tuT1 | NZ002M | 2024-06-11T12:04:09.454Z | 2024-06-18T12:11:13.092Z |
4441545 | 4441545 | 20240608154703_UnIxT | NZ002M | 2024-06-10T12:04:24.292Z | 2024-06-16T12:14:20.694Z |
4441079 | 4441079 | 20240608115413_YF3Bg | NZ002M | 2024-06-10T12:04:07.235Z | 2024-06-16T12:14:19.642Z |
4436084 | 4436084 | 20240607135950_jzhJU | NZ002M | 2024-06-09T12:03:57.361Z | 2024-06-15T12:17:07.090Z |
4432723 | 4432723 | 20240607191523_KksjS | NZ002M | 2024-06-09T12:01:26.452Z | 2024-06-16T12:13:56.085Z |
4431347 | 4431347 | 20240607153855_6AkwP | NZ002M | 2024-06-09T12:00:28.397Z | 2024-06-16T12:13:52.990Z |
4418198 | 4418198 | 20240604094031_CZeV4 | NZ002M | 2024-06-06T12:10:08.271Z | 2024-06-12T12:10:46.768Z |
4410825 | 4410825 | 20240603180815_yc0qV | NZ002M | 2024-06-05T12:05:57.852Z | 2024-06-12T12:10:35.913Z |
4409951 | 4409951 | 20240603161548_tvnTt | NZ002M | 2024-06-05T12:04:30.308Z | 2024-06-12T12:10:33.918Z |
4405790 | 4405790 | 20240602185053_e00xZ | NZ002M | 2024-06-04T12:05:15.405Z | 2024-06-11T12:13:32.153Z |
4398115 | 4398115 | 20240601082426_fQLZw | NZ002M | 2024-06-03T12:00:17.512Z | 2024-06-10T12:06:41.733Z |
4394620 | 4394620 | 20240531082802_gM2LV | NZ002M | 2024-06-01T12:00:35.843Z | 2024-06-09T12:05:57.782Z |
4390667 | 4390667 | 20240530153459_30tpP | NZ002M | 2024-05-31T12:03:27.789Z | 2024-06-08T12:14:06.704Z |
4329492 | 4329492 | 20240508184745_lqoUZ | NZ002M | 2024-05-17T12:08:47.037Z | 2024-05-19T12:14:23.679Z |
4328999 | 4328999 | 20240508181124_AA2D5 | NZ002M | 2024-05-17T12:08:18.359Z | 2024-05-19T12:14:11.381Z |
4326533 | 4326533 | 20240508163533_a1uT5 | NZ002M | 2024-05-17T12:05:55.455Z | 2024-05-19T12:13:26.514Z |
4325859 | 4325859 | 20240508160214_Bk8Wq | NZ002M | 2024-05-17T12:05:01.560Z | 2024-05-19T12:13:12.555Z |
4325279 | 4325279 | 20240508152317_5FQJV | NZ002M | 2024-05-17T12:04:00.201Z | 2024-05-19T12:13:01.267Z |
4292794 | 4292794 | 20240504180616_Ahsjp | NZ002M | 2024-05-08T12:06:21.851Z | 2024-05-13T12:10:28.075Z |
4292204 | 4292204 | 20240504172814_c3Bdb | NZ002M | 2024-05-08T12:05:26.085Z | 2024-05-13T12:10:16.947Z |
4289710 | 4289710 | 20240504164935_DRZaq | NZ002M | 2024-05-07T12:07:52.740Z | 2024-05-13T12:09:48.154Z |
4288424 | 4288424 | 20240504152242_7Hr1p | NZ002M | 2024-05-07T12:06:33.195Z | 2024-05-13T12:09:10.886Z |
4273489 | 4273489 | 20240503110545_NSy3Z | NZ002M | 2024-05-05T12:04:17.920Z | 2024-05-12T12:15:39.229Z |
4273486 | 4273486 | 20240503110544_mO3bu | NZ002M | 2024-05-05T12:04:17.754Z | 2024-05-12T12:15:39.154Z |
4265340 | 4265340 | 20240501165632_tPq1B | NZ002M | 2024-05-03T12:06:05.917Z | 2024-05-10T12:23:18.995Z |
4248978 | 4248978 | 20240428121055_suUXY | NZ002M | 2024-04-30T12:03:24.452Z | 2024-05-07T12:18:20.185Z |
4248221 | 4248221 | 20240428092051_odgw4 | NZ002M | 2024-04-30T12:01:29.543Z | 2024-05-07T12:18:14.808Z |
4248185 | 4248185 | 20240428090524_EJ0gk | NZ002M | 2024-04-30T12:01:24.403Z | 2024-05-07T12:18:14.668Z |
4247882 | 4247882 | 20240428070254_VBitT | NZ002M | 2024-04-30T12:00:25.800Z | 2024-05-07T12:18:11.452Z |
4246054 | 4246054 | 20240427151553_u0tqj | NZ002M | 2024-04-29T12:06:25.058Z | 2024-05-06T12:21:01.071Z |
4236862 | 4236862 | 20240423154351_uw1Bk | NZ002M | 2024-04-26T12:07:22.957Z | 2024-05-02T12:22:56.742Z |
4232317 | 4232317 | 20240422111525_I3lce | NZ002M | 2024-04-25T12:04:32.393Z | 2024-04-30T12:17:32.414Z |
4168699 | 4168699 | 20240409161603_uDjUd | NZ002M | 2024-04-11T12:11:39.654Z | 2024-04-17T12:21:37.874Z |
4168545 | 4168545 | 20240409154338_HDSNa | NZ002M | 2024-04-11T12:11:26.044Z | 2024-04-17T12:21:36.705Z |
4168497 | 4168497 | 20240409153823_0S3d3 | NZ002M | 2024-04-11T12:11:23.046Z | 2024-04-17T12:21:35.980Z |
4168435 | 4168435 | 20240409152142_3dTAM | NZ002M | 2024-04-11T12:11:18.722Z | 2024-04-17T12:21:35.268Z |
4162357 | 4162357 | 20240408073741_1ubMQ | NZ002M | 2024-04-10T12:06:40.139Z | 2024-04-16T12:20:23.183Z |
4155418 | 4155418 | 20240406142736_ULgSj | NZ002M | 2024-04-08T12:09:50.186Z | 2024-04-14T12:21:06.038Z |
4151228 | 4151228 | 20240405144743_8OdT9 | NZ002M | 2024-04-07T12:08:30.310Z | 2024-04-13T12:21:41.281Z |
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);