names

45 rows where place_id = 597505

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628840 1903895 1903895 defendant Strokke John husbandman 597505 597505 Strokke, John, of Lesyngham, husbandman 1
3647825 1909714 1909714 defendant Marmyon William gent 597505 597505 Marmyon, William, of Lesyngham, gent 2
3943577 2004871 2004871 defendant Rogers John husbandman 597505 597505 Rogers, John, of Lesyngham, husbandman 1
3950303 2007191 2007191 defendant Beare William husbandman 597505 597505 Beare, William, of Lesyngham, husbandman 2
4088534 2056199 2056199 defendant Newton William husbandman 597505 597505 Newton, William, of Lesyngham, husbandman 1
4412961 2168928 2168928 plaintiff Almot John   597505 597505 Almot, John, of Lesyngham 0
4418811 2170751 2170751 plaintiff Almot John   597505 597505 Almot, John, of Lesyngham 0
4440081 2181824 2181824 defendant Wytham John de   597505 597505 Wytham, John de, of Lesyngham 3
4499153 2200380 2200380 plaintiff Greyne Thomas   597505 597505 Greyne, Thomas, of Lesyngham 0
4601095 2231572 2231572 defendant Gamull Margaret   597505 597505 Gamull, Margaret, of Lesyngham 1
4703133 2266357 2266357 defendant Bate John pynder or impounder stray animals 597505 597505 Bate, John, of Lesyngham, pynder or impounder stray animals 0
4727977 2273996 2273996 defendant Cros William smith 597505 597505 Cros, William, of Lesyngham, smith 0
4855001 2312917 2312917 defendant Heylot Robert yeoman 597505 597505 Heylot, Robert, of Lesyngham, yeoman 2
4877891 2320039 2320039 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 2
4886156 2322531 2322531 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 0
4887258 2322853 2322853 defendant Trace William butcher 597505 597505 Trace, William, of Lesyngham, butcher 0
4887259 2322853 2322853 defendant Trace Thomas butcher 597505 597505 Trace, Thomas, of Lesyngham, butcher 1
4888083 2323077 2323077 defendant Heylot Robert yeoman 597505 597505 Heylot, Robert, of Lesyngham, yeoman 0
4901141 2326974 2326974 defendant Anound or Avound John   597505 597505 Anound or Avound, John, of Lesyngham 0
4922856 2333563 2333563 defendant Trace William butcher 597505 597505 Trace, William, of Lesyngham, butcher 3
4926006 2334564 2334564 defendant Thaxster Robert husbandman 597505 597505 Thaxster, Robert, of Lesyngham, husbandman 0
4926007 2334564 2334564 defendant Dallyng Richard husbandman 597505 597505 Dallyng, Richard, of Lesyngham, husbandman 1
4926008 2334564 2334564 defendant Coppyng John husbandman 597505 597505 Coppyng, John, of Lesyngham, husbandman 2
4926009 2334564 2334564 defendant Barbour John husbandman 597505 597505 Barbour, John, of Lesyngham, husbandman 3
4943006 2339788 2339788 defendant Heylot Robert husbamdman 597505 597505 Heylot, Robert, of Lesyngham, husbamdman 0
4970736 2348189 2348189 defendant Bunche John tailor 597505 597505 Bunche, John, of Lesyngham, tailor 1
4981912 2351511 2351511 defendant Heylot Robert   597505 597505 Heylot, Robert, of Lesyngham, franklin 1
5049684 2371529 2371529 defendant Idewyn John clerk 597505 597505 Idewyn, John, of Lesyngham, clerk 0
5074606 2378907 2378907 defendant Heylot Robert yeoman 597505 597505 Heylot, Robert, of Lesyngham, yeoman 0
5096100 2385300 2385300 defendant Hamond Hamon husbandman 597505 597505 Hamond, Hamon, of Lesyngham, husbandman 0
5120110 2392320 2392320 defendant Hagon Stephen smith 597505 597505 Hagon, Stephen, of Lesyngham, smith 1
5122619 2393048 2393048 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 2
5126872 2394337 2394337 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 2
5143613 2399267 2399267 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 1
5143614 2399267 2399267 defendant Heylot William husbandman 597505 597505 Heylot, William, of Lesyngham, husbandman 2
5214656 2420015 2420015 defendant Heylot Robert gent 597505 597505 Heylot, Robert, of Lesyngham, gent 3
5229843 2424347 2424347 defendant Thaxstere Robert husbandman 597505 597505 Thaxstere, Robert, of Lesyngham, husbandman 0
5233632 2425427 2425427 defendant Threkyngham John clerk 597505 597505 Threkyngham, John, of Lesyngham, clerk 0
5281486 2439652 2439652 defendant Baxby William husbandman 597505 597505 Baxby, William, of Lesyngham, husbandman 2
5440564 2487084 2487084 defendant Idwyn John   597505 597505 Idwyn, John, of Lesyngham, parson, administrators of 0
5453666 2490990 2490990 defendant Idwyn John (legal representative) 597505 597505 Idwyn, John, of Lesyngham, executors of 0
5453674 2490993 2490993 defendant Idwyn John   597505 597505 Idwyn, John, of Lesyngham, administrators of 0
5465763 2494676 2494676 defendant Idwyn John   597505 597505 Idwyn, John, of Lesyngham, parson, administrators of 0
5551088 2520342 2520342 plaintiff Cokke William clerk 597505 597505 Cokke, William, of Lesyngham, clerk 0
5578303 2528283 2528283 defendant Olyver Robert husbandman 597505 597505 Olyver, Robert, of Lesyngham, husbandman 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);