names

57 rows where place_id = 593607

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612558 1871561 1871561 defendant Andrewe John yeoman 593607 593607 Andrewe, John, of Peynton, yeoman 0
4291642 2127088 2127088 defendant Baliffe Anthony gent 593607 593607 Baliffe, Anthony, of Peynton, gent 0
4291643 2127088 2127088 defendant Bayliffe Henry gent 593607 593607 Bayliffe, Henry, of Peynton, gent 1
4426590 2173126 2173126 defendant Brunne John de   593607 593607 Brunne, John de, of Peynton 0
4441316 2182219 2182219 defendant Shepwyk William   593607 593607 Shepwyk, William, of Peynton 0
4475381 2192983 2192983 defendant Raynald William   593607 593607 Raynald, William, of Peynton 0
4579623 2225113 2225113 defendant Page John   593607 593607 Page, John, of peynton 0
4581244 2225601 2225601 defendant Kyn_ John mariner of Dertemouth 593607 593607 Kyn_, John, of Peynton, mariner of Dertemouth 0
4601253 2231626 2231626 defendant Boway John   593607 593607 Boway, John, of Peynton 0
4674527 2257645 2257645 defendant Kyrkham Walter gent 593607 593607 Kyrkham, Walter, of Peynton, gent 1
4674528 2257645 2257645 defendant Hurne William jouter or hawker 593607 593607 Hurne, William, of Peynton, jouter or hawker 2
4674534 2257645 2257645 defendant Bon John stocer 593607 593607 Bon, John, of Peynton, stocer 8
4674542 2257645 2257645 defendant Jurle John husbandman 593607 593607 Jurle, John, of Peynton, husbandman 16
4699665 2265347 2265347 defendant Kyrkham Walter gent 593607 593607 Kyrkham, Walter, of Peynton, gent 1
4699666 2265347 2265347 defendant Hurne William jouter 593607 593607 Hurne, William, of Peynton, jouter 2
4699674 2265347 2265347 defendant Lucas William   593607 593607 Lucas, William, of Peynton, "scosser" 10
4699684 2265347 2265347 defendant Yorle John husbandman 593607 593607 Yorle, John, of Peynton, husbandman 20
4732347 2275294 2275294 defendant Adam Richard husbandman 593607 593607 Adam, Richard, of Peynton, husbandman 0
4750183 2280527 2280527 defendant Covewey Thomas yeoman 593607 593607 Covewey, Thomas, of Peynton, yeoman 2
4766355 2285467 2285467 defendant Jon Thomas mariner 593607 593607 Jon, Thomas, of Peynton, mariner 7
4790772 2293199 2293199 defendant Jon Thomas mariner 593607 593607 Jon, Thomas, of Peynton, mariner 7
4811332 2299654 2299654 defendant Crempe William husbandman 593607 593607 Crempe, William, of Peynton, husbandman 0
4840376 2308534 2308534 defendant Langford William   593607 593607 Langford, William, of Peynton 1
4840377 2308534 2308534 defendant Bastard John   593607 593607 Bastard, John, of Peynton 2
4867617 2316842 2316842 defendant Crympe Elias husbandman 593607 593607 Crympe, Elias, of Peynton, husbandman 2
4895299 2325188 2325188 defendant Vagge Walter husbandman 593607 593607 Vagge, Walter, of Peynton, husbandman 2
4902000 2327229 2327229 defendant Chireton Robert mariner 593607 593607 Chireton, Robert, of Peynton, mariner 0
4936147 2337705 2337705 defendant Crendon John mariner 593607 593607 Crendon, John, of Peynton, mariner 0
4936148 2337705 2337705 defendant Crendon Thomas mariner 593607 593607 Crendon, Thomas, of Peynton, mariner 1
4936149 2337705 2337705 defendant Levelegh or Lenelegh Richard mariner 593607 593607 Levelegh or Lenelegh, Richard, of Peynton, mariner 2
4954716 2343365 2343365 defendant Crempe Elias butcher 593607 593607 Crempe, Elias, of Peynton, butcher 0
5005087 2358387 2358387 defendant Webster Thomas husbandman 593607 593607 Webster, Thomas, of Peynton, husbandman 3
5038607 2368191 2368191 defendant Poulemere Thomas husbandman 593607 593607 Poulemere, Thomas, of Peynton, husbandman 0
5038609 2368192 2368192 defendant Poulemere Thomas husbandman 593607 593607 Poulemere, Thomas, of Peynton, husbandman 0
5072439 2378245 2378245 defendant Smyth Richard tailor 593607 593607 Smyth, Richard, of Peynton, tailor 1
5080781 2380743 2380743 defendant Cave Thomas butcher 593607 593607 Cave, Thomas, of Peynton, butcher 0
5080782 2380743 2380743 defendant Crympe John butcher 593607 593607 Crympe, John, of Peynton, butcher 1
5252508 2430894 2430894 defendant Bartelot Thomas mariner 593607 593607 Bartelot, Thomas, of Peynton, mariner 0
5309315 2447827 2447827 defendant Aysshebury Henry husbandman 593607 593607 Aysshebury, Henry, of Peynton, husbandman 0
5389696 2472115 2472115 defendant Dollyng William husbandman 593607 593607 Dollyng, William, of Peynton, husbandman 0
5402506 2475786 2475786 defendant Dollyng William husbandman 593607 593607 Dollyng, William, of Peynton, husbandman 0
5415426 2479550 2479550 defendant Dollyng William husbandman 593607 593607 Dollyng, William, of Peynton, husbandman 0
5428676 2483493 2483493 defendant Petyr John miller 593607 593607 Petyr, John, of Peynton, miller 0
5428677 2483493 2483493 defendant Corbyn John tailor 593607 593607 Corbyn, John, of Peynton, tailor 1
5428678 2483493 2483493 defendant Bylfford John husbandman 593607 593607 Bylfford, John, of Peynton, husbandman 2
5428679 2483493 2483493 defendant Comyng Stephen husbandman 593607 593607 Comyng, Stephen, of Peynton, husbandman 3
5428680 2483493 2483493 defendant Medeyeate John husbandman 593607 593607 Medeyeate, John, of Peynton, husbandman 4
5431645 2484423 2484423 defendant Dollyng William husbandman 593607 593607 Dollyng, William, of Peynton, husbandman 0
5431647 2484424 2484424 defendant Dollyng William husbandman 593607 593607 Dollyng, William, of Peynton, husbandman 0
5446210 2488752 2488752 defendant Werthe John gent 593607 593607 Werthe, John, of Peynton, gent 0
5458856 2492540 2492540 defendant Werthe John gent 593607 593607 Werthe, John, of Peynton, gent 0
5470449 2496081 2496081 defendant Werthe John gent 593607 593607 Werthe, John, of Peynton, gent 0
5470451 2496082 2496082 defendant Werthe John gent 593607 593607 Werthe, John, of Peynton, gent 0
5470616 2496133 2496133 defendant Gilberd Otto esq 593607 593607 Gilberd, Otto, of Peynton, esq 2
5470627 2496136 2496136 defendant Gilberd Otto esq 593607 593607 Gilberd, Otto, of Peynton, esq 2
5481861 2499508 2499508 defendant Werthe John gent 593607 593607 Werthe, John, of Peynton, gent 0
5486676 2500913 2500913 defendant Cole Stephen butcher 593607 593607 Cole, Stephen, of Peynton, butcher 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);