participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,902 rows where station_code = "NZ002F" 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 |
---|---|---|---|---|---|
5573276 | 5573276 | 20241119144020_pwKe3 | NZ002F | 2024-11-22T14:20:12.369Z | 2024-11-22T14:20:12.369Z |
5573272 | 5573272 | 20241119132136_B23nR | NZ002F | 2024-11-22T14:20:06.770Z | 2024-11-22T14:20:06.770Z |
5569706 | 5569706 | 20241120130116_dNb2h | NZ002F | 2024-11-22T14:13:40.141Z | 2024-11-22T14:19:21.672Z |
5569436 | 5569436 | 20241121153007_33ryN | NZ002F | 2024-11-22T14:10:52.861Z | 2024-11-22T14:10:52.861Z |
5569433 | 5569433 | 20241121152947_YygU3 | NZ002F | 2024-11-22T14:10:52.519Z | 2024-11-22T14:10:52.519Z |
5569426 | 5569426 | 20241121152733_cZAP3 | NZ002F | 2024-11-22T14:10:52.104Z | 2024-11-22T14:10:52.104Z |
5560786 | 5560786 | 20241120142319_idTR6 | NZ002F | 2024-11-21T14:09:44.800Z | 2024-11-22T14:19:21.732Z |
5560764 | 5560764 | 20241120141711_Xv6mP | NZ002F | 2024-11-21T14:09:43.413Z | 2024-11-22T14:19:21.729Z |
5560736 | 5560736 | 20241120141106_iKvm0 | NZ002F | 2024-11-21T14:09:40.997Z | 2024-11-22T14:19:21.724Z |
5560719 | 5560719 | 20241120140324_0SWBl | NZ002F | 2024-11-21T14:09:35.906Z | 2024-11-22T14:19:21.720Z |
5560714 | 5560714 | 20241120140233_jHreh | NZ002F | 2024-11-21T14:09:34.937Z | 2024-11-22T14:19:21.720Z |
5560479 | 5560479 | 20241120125525_FsPec | NZ002F | 2024-11-21T14:08:56.298Z | 2024-11-22T14:19:21.667Z |
5560377 | 5560377 | 20241120124519_1asLO | NZ002F | 2024-11-21T14:08:46.197Z | 2024-11-22T14:19:21.648Z |
5560138 | 5560138 | 20241120120727_tw0Ul | NZ002F | 2024-11-21T14:08:07.422Z | 2024-11-22T14:19:21.596Z |
5560090 | 5560090 | 20241120115759_Qp2JL | NZ002F | 2024-11-21T14:08:01.896Z | 2024-11-22T14:19:21.586Z |
5560048 | 5560048 | 20241120115143_whclI | NZ002F | 2024-11-21T14:07:56.175Z | 2024-11-22T14:19:21.575Z |
5560032 | 5560032 | 20241120114853_LzrF4 | NZ002F | 2024-11-21T14:07:54.172Z | 2024-11-22T14:19:21.572Z |
5559768 | 5559768 | 20241120111518_cGeur | NZ002F | 2024-11-21T14:07:09.399Z | 2024-11-22T14:19:21.521Z |
5559545 | 5559545 | 20241120103954_fHWpk | NZ002F | 2024-11-21T14:06:34.637Z | 2024-11-22T14:19:21.470Z |
5559528 | 5559528 | 20241120103910_5LVu4 | NZ002F | 2024-11-21T14:06:32.334Z | 2024-11-22T14:19:21.466Z |
5559318 | 5559318 | 20241120100306_90CW1 | NZ002F | 2024-11-21T14:05:57.868Z | 2024-11-22T14:19:21.416Z |
5555743 | 5555743 | 20241119152357_W0KUq | NZ002F | 2024-11-20T14:06:31.335Z | 2024-11-22T14:20:13.390Z |
5555710 | 5555710 | 20241119145631_fCTZV | NZ002F | 2024-11-20T14:06:27.656Z | 2024-11-22T14:20:12.693Z |
5555703 | 5555703 | 20241119145145_quLU4 | NZ002F | 2024-11-20T14:06:27.037Z | 2024-11-22T14:20:12.591Z |
5555677 | 5555677 | 20241119143720_RFcot | NZ002F | 2024-11-20T14:06:23.629Z | 2024-11-22T14:20:12.282Z |
5555659 | 5555659 | 20241119142415_CLJJM | NZ002F | 2024-11-20T14:06:21.292Z | 2024-11-22T14:20:11.883Z |
5555587 | 5555587 | 20241119135930_joalQ | NZ002F | 2024-11-20T14:06:03.586Z | 2024-11-22T14:20:10.571Z |
5555576 | 5555576 | 20241119135540_avNKI | NZ002F | 2024-11-20T14:06:02.109Z | 2024-11-22T14:20:10.323Z |
5555553 | 5555553 | 20241119135057_uiIpx | NZ002F | 2024-11-20T14:05:58.760Z | 2024-11-22T14:20:09.651Z |
5555543 | 5555543 | 20241119134721_ZgChy | NZ002F | 2024-11-20T14:05:56.823Z | 2024-11-22T14:20:09.321Z |
5555539 | 5555539 | 20241119134429_rCHJk | NZ002F | 2024-11-20T14:05:56.358Z | 2024-11-22T14:20:09.261Z |
5555525 | 5555525 | 20241119134144_C5Uvk | NZ002F | 2024-11-20T14:05:55.361Z | 2024-11-22T14:20:09.108Z |
5555491 | 5555491 | 20241119133302_B6t3m | NZ002F | 2024-11-20T14:05:51.573Z | 2024-11-22T14:20:07.510Z |
5555466 | 5555466 | 20241119132458_CwWhg | NZ002F | 2024-11-20T14:05:43.009Z | 2024-11-22T14:20:06.921Z |
5555454 | 5555454 | 20241119132136_ee7EQ | NZ002F | 2024-11-20T14:05:40.784Z | 2024-11-21T14:18:53.280Z |
5555440 | 5555440 | 20241119131504_yews8 | NZ002F | 2024-11-20T14:05:38.445Z | 2024-11-22T14:20:06.510Z |
5555419 | 5555419 | 20241119130908_jGAl3 | NZ002F | 2024-11-20T14:05:35.426Z | 2024-11-22T14:20:05.757Z |
5555416 | 5555416 | 20241119130810_skGfI | NZ002F | 2024-11-20T14:05:35.022Z | 2024-11-22T14:20:05.712Z |
5555398 | 5555398 | 20241119130339_3J2nY | NZ002F | 2024-11-20T14:05:29.928Z | 2024-11-22T14:20:05.372Z |
5555352 | 5555352 | 20241119125420_iy26f | NZ002F | 2024-11-20T14:05:16.392Z | 2024-11-22T14:20:04.664Z |
5555332 | 5555332 | 20241119124750_PKhzS | NZ002F | 2024-11-20T14:05:13.033Z | 2024-11-22T14:20:04.307Z |
5555326 | 5555326 | 20241119124259_ijK3w | NZ002F | 2024-11-20T14:05:11.693Z | 2024-11-22T14:20:04.058Z |
5555295 | 5555295 | 20241119123620_qEZPI | NZ002F | 2024-11-20T14:05:07.183Z | 2024-11-22T14:20:03.339Z |
5555288 | 5555288 | 20241119123548_1OXUq | NZ002F | 2024-11-20T14:05:06.823Z | 2024-11-22T14:20:03.218Z |
5555223 | 5555223 | 20241119121959_KBC3d | NZ002F | 2024-11-20T14:04:52.175Z | 2024-11-22T14:20:01.761Z |
5551930 | 5551930 | 20241118154258_Zhoda | NZ002F | 2024-11-19T14:05:48.903Z | 2024-11-22T14:22:13.067Z |
5551889 | 5551889 | 20241118153459_l2Hqo | NZ002F | 2024-11-19T14:05:46.465Z | 2024-11-22T14:22:12.916Z |
5551554 | 5551554 | 20241118141231_hjZvp | NZ002F | 2024-11-19T14:04:59.375Z | 2024-11-22T14:22:11.422Z |
5551442 | 5551442 | 20241118133649_cCpDN | NZ002F | 2024-11-19T14:04:47.579Z | 2024-11-22T14:22:10.707Z |
5551404 | 5551404 | 20241118132707_FbJXq | NZ002F | 2024-11-19T14:04:44.459Z | 2024-11-22T14:22:10.535Z |
5551376 | 5551376 | 20241118131932_mUL2D | NZ002F | 2024-11-19T14:04:41.741Z | 2024-11-22T14:22:10.426Z |
5551364 | 5551364 | 20241118131619_p0cEN | NZ002F | 2024-11-19T14:04:37.451Z | 2024-11-22T14:22:10.361Z |
5551354 | 5551354 | 20241118131104_iv87e | NZ002F | 2024-11-19T14:04:34.782Z | 2024-11-22T14:22:10.327Z |
5551179 | 5551179 | 20241118124029_P9mVl | NZ002F | 2024-11-19T14:04:03.784Z | 2024-11-22T14:22:09.003Z |
5551090 | 5551090 | 20241118122428_rmUB3 | NZ002F | 2024-11-19T14:03:53.990Z | 2024-11-22T14:22:08.206Z |
5550953 | 5550953 | 20241118120216_gvzyY | NZ002F | 2024-11-19T14:03:36.732Z | 2024-11-22T14:22:07.068Z |
5550922 | 5550922 | 20241118115000_UktmI | NZ002F | 2024-11-19T14:03:29.417Z | 2024-11-22T14:22:06.886Z |
5550323 | 5550323 | 20241118100752_oCJjW | NZ002F | 2024-11-19T14:02:11.778Z | 2024-11-22T14:22:01.447Z |
5550212 | 5550212 | 20241118094625_kwsbL | NZ002F | 2024-11-19T14:01:46.640Z | 2024-11-22T14:21:59.725Z |
5550166 | 5550166 | 20241118094308_UvXA1 | NZ002F | 2024-11-19T14:01:40.742Z | 2024-11-22T14:21:59.193Z |
5550047 | 5550047 | 20241118091746_G7HsO | NZ002F | 2024-11-19T14:01:30.085Z | 2024-11-22T14:21:57.265Z |
5547333 | 5547333 | 20241117154332_An29S | NZ002F | 2024-11-18T14:05:32.005Z | 2024-11-22T14:22:39.006Z |
5547279 | 5547279 | 20241117152448_NK3T0 | NZ002F | 2024-11-18T14:05:24.799Z | 2024-11-22T14:22:38.323Z |
5547248 | 5547248 | 20241117151600_DgYGU | NZ002F | 2024-11-18T14:05:21.385Z | 2024-11-22T14:22:38.206Z |
5547230 | 5547230 | 20241117151203_a50kG | NZ002F | 2024-11-18T14:05:18.898Z | 2024-11-22T14:22:38.103Z |
5547206 | 5547206 | 20241117150518_uwB0v | NZ002F | 2024-11-18T14:05:16.418Z | 2024-11-22T14:22:37.933Z |
5547197 | 5547197 | 20241117150458_HjEyT | NZ002F | 2024-11-18T14:05:16.044Z | 2024-11-22T14:22:37.894Z |
5547193 | 5547193 | 20241117150421_KKJA3 | NZ002F | 2024-11-18T14:05:15.751Z | 2024-11-22T14:22:37.893Z |
5547170 | 5547170 | 20241117150336_RrsAn | NZ002F | 2024-11-18T14:05:13.581Z | 2024-11-22T14:22:37.827Z |
5547060 | 5547060 | 20241117143101_DfQhn | NZ002F | 2024-11-18T14:04:52.463Z | 2024-11-22T14:22:36.624Z |
5547013 | 5547013 | 20241117141335_fAyJ4 | NZ002F | 2024-11-18T14:04:42.393Z | 2024-11-22T14:22:36.400Z |
5547000 | 5547000 | 20241117140750_q7fw0 | NZ002F | 2024-11-18T14:04:41.187Z | 2024-11-22T14:22:36.324Z |
5546971 | 5546971 | 20241117134937_fhqMc | NZ002F | 2024-11-18T14:04:35.397Z | 2024-11-22T14:22:35.979Z |
5546954 | 5546954 | 20241117133755_WaSVR | NZ002F | 2024-11-18T14:04:32.955Z | 2024-11-22T14:22:35.715Z |
5546913 | 5546913 | 20241117132316_cy7lt | NZ002F | 2024-11-18T14:04:27.349Z | 2024-11-22T14:22:35.415Z |
5546844 | 5546844 | 20241117130119_UmJv4 | NZ002F | 2024-11-18T14:04:20.510Z | 2024-11-22T14:22:34.971Z |
5546815 | 5546815 | 20241117124931_PCgnY | NZ002F | 2024-11-18T14:04:16.784Z | 2024-11-22T14:22:34.748Z |
5546812 | 5546812 | 20241117124857_IUN8B | NZ002F | 2024-11-18T14:04:16.460Z | 2024-11-22T14:22:34.744Z |
5546782 | 5546782 | 20241117124308_l3P58 | NZ002F | 2024-11-18T14:04:13.883Z | 2024-11-22T14:22:34.610Z |
5546768 | 5546768 | 20241117124012_Zl3zX | NZ002F | 2024-11-18T14:04:12.312Z | 2024-11-22T14:22:34.572Z |
5546614 | 5546614 | 20241117115638_Whida | NZ002F | 2024-11-18T14:03:39.724Z | 2024-11-22T14:22:33.407Z |
5546486 | 5546486 | 20241117111144_xdEo9 | NZ002F | 2024-11-18T14:03:13.001Z | 2024-11-22T14:22:32.264Z |
5546454 | 5546454 | 20241117110428_4fkAW | NZ002F | 2024-11-18T14:03:08.571Z | 2024-11-22T14:22:32.116Z |
5546435 | 5546435 | 20241117105714_CpUya | NZ002F | 2024-11-18T14:03:06.627Z | 2024-11-22T14:22:32.006Z |
5546403 | 5546403 | 20241117104622_Yzo3I | NZ002F | 2024-11-18T14:03:01.944Z | 2024-11-22T14:22:31.803Z |
5546227 | 5546227 | 20241117095716_3rU2Z | NZ002F | 2024-11-18T14:02:30.737Z | 2024-11-22T14:22:30.402Z |
5546188 | 5546188 | 20241117093913_dm2ay | NZ002F | 2024-11-18T14:02:24.862Z | 2024-11-22T14:22:29.924Z |
5546110 | 5546110 | 20241117091632_R1T5D | NZ002F | 2024-11-18T14:02:06.437Z | 2024-11-22T14:22:29.195Z |
5544805 | 5544805 | 20241116153903_WB3cw | NZ002F | 2024-11-17T14:02:10.122Z | 2024-11-22T14:23:06.314Z |
5544786 | 5544786 | 20241116152148_5YrIz | NZ002F | 2024-11-17T14:02:06.610Z | 2024-11-22T14:23:06.293Z |
5544757 | 5544757 | 20241116150409_w2yrp | NZ002F | 2024-11-17T14:02:01.491Z | 2024-11-22T14:23:06.158Z |
5544753 | 5544753 | 20241116150352_Zvh1D | NZ002F | 2024-11-17T14:02:01.108Z | 2024-11-22T14:23:06.151Z |
5544734 | 5544734 | 20241116145506_prIhR | NZ002F | 2024-11-17T14:01:58.232Z | 2024-11-22T14:23:05.958Z |
5544702 | 5544702 | 20241116143138_mHX1y | NZ002F | 2024-11-17T14:01:52.917Z | 2024-11-22T14:23:05.867Z |
5544661 | 5544661 | 20241116135118_DCfYd | NZ002F | 2024-11-17T14:01:47.408Z | 2024-11-22T14:23:05.283Z |
5544649 | 5544649 | 20241116134403_2OXA8 | NZ002F | 2024-11-17T14:01:45.530Z | 2024-11-22T14:23:05.221Z |
5544627 | 5544627 | 20241116131851_siR46 | NZ002F | 2024-11-17T14:01:43.019Z | 2024-11-22T14:23:05.060Z |
5544611 | 5544611 | 20241116130328_AJuWr | NZ002F | 2024-11-17T14:01:40.717Z | 2024-11-22T14:23:04.827Z |
5527265 | 5527265 | 20241111131125_MrA5N | NZ002F | 2024-11-13T14:07:14.528Z | 2024-11-20T14:24:58.221Z |
5520432 | 5520432 | 20241111154934_pl5hW | NZ002F | 2024-11-12T14:06:20.051Z | 2024-11-20T14:25:08.865Z |
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);