names

84 rows where place_id = 607328

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668774 1916170 1916170 defendant Morvand Hugh husbandman 607328 607328 Morvand, Hugh, of Lyde, husbandman 0
3702390 1927007 1927007 defendant Swan Thomas yeoman 607328 607328 Swan, Thomas, of Lyde, yeoman 0
3975683 2016054 2016054 plaintiff Hyde Thomas gent 607328 607328 Hyde, Thomas, of Lyde, gent 0
3975685 2016055 2016055 plaintiff Hyde Thomas gent 607328 607328 Hyde, Thomas, of Lyde, gent 0
4117076 2066411 2066411 defendant Morvan Hugh husbandman 607328 607328 Morvan, Hugh, of Lyde, husbandman 0
4193352 2093242 2093242 defendant Berrye John yeoman 607328 607328 Berrye, John, of Lyde, yeoman 0
4360713 2151003 2151003 defendant Collyns John yeoman 607328 607328 Collyns, John, of Lyde, yeoman 0
4360714 2151003 2151003 defendant Lane John yeoman 607328 607328 Lane, John, of Lyde, yeoman 1
4360715 2151003 2151003 defendant Thomas John yeoman 607328 607328 Thomas, John, of Lyde, yeoman 2
4483771 2195617 2195617 defendant Stepene John   607328 607328 Stepene, John, of Lyde 1
4600188 2231286 2231286 plaintiff Thomas John   607328 607328 Thomas, John, of Lyde 0
4600190 2231287 2231287 plaintiff Thomas John   607328 607328 Thomas, John, of Lyde 0
4603943 2232407 2232407 defendant Quykeman Richard   607328 607328 Quykeman, Richard, of Lyde 0
4612453 2234960 2234960 defendant Turnour William   607328 607328 Turnour, William, of Lyde 0
4625183 2238841 2238841 defendant Philip Thomas   607328 607328 Philip, Thomas, of Lyde 0
4664296 2250315 2250315 defendant Vynch John farmer 607328 607328 Vynch, John, of Lyde, farmer 0
4664297 2250315 2250315 defendant Hoghelot William farmer 607328 607328 Hoghelot, William, of Lyde, farmer 1
4664301 2250316 2250316 defendant Vynch John farmer 607328 607328 Vynch, John, of Lyde, farmer 0
4664302 2250316 2250316 defendant Hoghelot William farmer 607328 607328 Hoghelot, William, of Lyde, farmer 1
4665490 2250679 2250679 defendant Hogheleyn Thomas husbandman 607328 607328 Hogheleyn, Thomas, of Lyde, husbandman 2
4665491 2250679 2250679 defendant Lyght John laborer 607328 607328 Lyght, John, of Lyde, laborer 3
4665492 2250679 2250679 defendant Gryme Roger laborer 607328 607328 Gryme, Roger, of Lyde, laborer 4
4681445 2259814 2259814 defendant Penense John yeoman 607328 607328 Penense, John, of Lyde, yeoman 7
4681446 2259814 2259814 defendant Northyngton Geoffrey yeoman 607328 607328 Northyngton, Geoffrey, of Lyde, yeoman 8
4717430 2270788 2270788 plaintiff Aghene Thomas de   607328 607328 Aghene, Thomas de, of Lyde 0
4719418 2271418 2271418 defendant Noryngton Geoffrey farmer 607328 607328 Noryngton, Geoffrey, of Lyde, farmer 0
4719420 2271419 2271419 defendant Norynton Geoffrey farmer 607328 607328 Norynton, Geoffrey, of Lyde, farmer 0
4731423 2275028 2275028 plaintiff Bromley Richard   607328 607328 Bromley, Richard, of Lyde 3
4756019 2282267 2282267 defendant Benet Richard husbandman 607328 607328 Benet, Richard, of Lyde, husbandman 2
4756020 2282267 2282267 defendant Elys Laurence husbandman 607328 607328 Elys, Laurence, of Lyde, husbandman 3
4756021 2282267 2282267 defendant Danyell Thomas husbandman 607328 607328 Danyell, Thomas, of Lyde, husbandman 4
4756032 2282269 2282269 defendant Benet Richard husbandman 607328 607328 Benet, Richard, of Lyde, husbandman 2
4756033 2282269 2282269 defendant Elys Laurence husbandman 607328 607328 Elys, Laurence, of Lyde, husbandman 3
4756034 2282269 2282269 defendant Danyell Thomas   607328 607328 Danyell, Thomas, of Lyde, husbandman [ Benet's forename derived from image: 0824, fronts ] 4
4756047 2282272 2282272 defendant Benet Richard husbandman 607328 607328 Benet, Richard, of Lyde, husbandman 2
4833258 2306411 2306411 defendant Harry Thomas draper 607328 607328 Harry, Thomas, of Lyde, draper 0
4862374 2315240 2315240 defendant Makemete James shipman 607328 607328 Makemete, James, of Lyde, shipman 0
4862375 2315240 2315240 defendant Moryng John shipman 607328 607328 Moryng, John, of Lyde, shipman 1
4862376 2315240 2315240 defendant Gate John shipman 607328 607328 Gate, John, of Lyde, shipman 2
4876964 2319765 2319765 defendant Bayton John husbandman 607328 607328 Bayton, John, of Lyde, husbandman 0
4894133 2324860 2324860 defendant Hendyke Lawrence husbandman 607328 607328 Hendyke, Lawrence, of Lyde, husbandman 1
4900323 2326736 2326736 defendant Watyll John butcher 607328 607328 Watyll, John, of Lyde, butcher 0
4900324 2326736 2326736 defendant Clerk Henry butcher 607328 607328 Clerk, Henry, of Lyde, butcher 1
4942886 2339749 2339749 defendant Couper John cooper 607328 607328 Couper, John, of Lyde, cooper 0
4978462 2350505 2350505 defendant Aghen Roger husbandman 607328 607328 Aghen, Roger, of Lyde, husbandman 3
4988636 2353558 2353558 defendant Hebbyngge William   607328 607328 Hebbyngge, William, of Lyde, vicar 0
4993588 2354956 2354956 defendant Tryppe Augustine butcher 607328 607328 Tryppe, Augustine, of Lyde, butcher 0
5002814 2357728 2357728 defendant Aleyn Henry husbandman 607328 607328 Aleyn, Henry, of Lyde, husbandman 2
5022856 2363596 2363596 plaintiff Gros William   607328 607328 Gros, William, of Lyde 0
5131551 2395709 2395709 defendant atte Watere William tailor 607328 607328 atte Watere, William, of Lyde, tailor 0
5144677 2399599 2399599 defendant Groos William yeoman 607328 607328 Groos, William, of Lyde, yeoman 0
5151010 2401434 2401434 defendant atte Water William tailor 607328 607328 atte Water, William, of Lyde, tailor 0
5151011 2401434 2401434 defendant Fermour John butcher 607328 607328 Fermour, John, of Lyde, butcher 1
5151013 2401435 2401435 defendant atte Water William tailor 607328 607328 atte Water, William, of Lyde, tailor 0
5151014 2401435 2401435 defendant Fermour John butcher 607328 607328 Fermour, John, of Lyde, butcher 1
5151017 2401436 2401436 defendant atte Watere William tailor 607328 607328 atte Watere, William, of Lyde, tailor 0
5151020 2401437 2401437 defendant atte Watere William tailor 607328 607328 atte Watere, William, of Lyde, tailor 0
5165770 2405732 2405732 defendant Groos William yeoman 607328 607328 Groos, William, of Lyde, yeoman 0
5169311 2406759 2406759 defendant atte Water William   607328 607328 atte Water, William, of Lyde 0
5169312 2406759 2406759 defendant Fermour John butcher 607328 607328 together with Fermour, John, of Lyde, butcher 1
5238294 2426783 2426783 defendant Knyght William husbandman 607328 607328 Knyght, William, of Lyde, husbandman 0
5259550 2433110 2433110 defendant Penter or Peuter William beer brewer 607328 607328 Penter or Peuter, William, of Lyde, or of Canterbury, beer brewer 0
5290308 2442171 2442171 defendant Serles John yeoman 607328 607328 Serles, John, of Lyde, yeoman 0
5298367 2444496 2444496 defendant Hogge Stephen fishmonger 607328 607328 Hogge, Stephen, of Lyde, fishmonger 0
5298370 2444497 2444497 defendant Alway John fishmonger 607328 607328 Alway, John, of Lyde, fishmonger 1
5298372 2444498 2444498 defendant Serles John yeoman 607328 607328 Serles, John, of Lyde, yeoman 0
5298373 2444498 2444498 defendant Caxston Thomas yeoman 607328 607328 Caxston, Thomas, of Lyde, yeoman 1
5300150 2445007 2445007 defendant Nicoll William   607328 607328 Nicoll, William, of Lyde, parish clerk 0
5300155 2445008 2445008 defendant Nicoll William   607328 607328 together with Nicoll, William, of Lyde, parish clerk 2
5323866 2452220 2452220 defendant Latesho John cordwainer 607328 607328 Latesho, John, of Lyde, cordwainer 0
5330895 2454311 2454311 defendant Alcok John husbandman 607328 607328 Alcok, John, of Lyde, husbandman 0
5330897 2454312 2454312 defendant Bate Andrew husbandman 607328 607328 Bate, Andrew, of Lyde, husbandman 0
5330898 2454312 2454312 defendant Robyn Thomas husbandman 607328 607328 Robyn, Thomas, of Lyde, husbandman 1
5492374 2502636 2502636 defendant Chaundons William husbandman 607328 607328 Chaundons, William, of Lyde Prior, husbandman 0
5517196 2510213 2510213 defendant Helwyn John yeoman 607328 607328 Helwyn, John, of Lyde, yeoman 3
5551477 2520470 2520470 defendant Colyn Robert husbandman 607328 607328 Colyn, Robert, of Lyde, husbandman 2
5551478 2520470 2520470 defendant Stokton John yeoman 607328 607328 Stokton, John, of Lyde, yeoman 3
5562627 2523670 2523670 defendant Whyte Mathew husbandman 607328 607328 Whyte, Mathew, of Lyde Prior, husbandman 1
5562643 2523672 2523672 defendant Bysshop John husbandman 607328 607328 Bysshop, John, of Lyde Prior, husbandman 2
5562644 2523672 2523672 defendant Chaunders William husbandman 607328 607328 Chaunders, William, of Lyde Prior, husbandman 3
5584334 2530166 2530166 defendant Kempe William husbandman 607328 607328 Kempe, William, of Lyde, husbandman 1
5588700 2531476 2531476 defendant Baugh Thomas husbandman 607328 607328 Baugh, Thomas, of Lyde, husbandman 3
5614987 2548481 2548481 defendant Bocher Robert   607328 607328 Bocher, Robert, of Lyde 0
5632764 2554261 2554261 defendant atte Bregge Thomas farmer 607328 607328 atte Bregge, Thomas, of Lyde, farmer 0

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);