names

35 rows where place_id = 616842

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3716438 1931434 1931434 defendant Huntley Edmund husbandman 616842 616842 Huntley, Edmund, of Churcham, husbandman 2
3966355 2012860 2012860 defendant Phelipps John (legal representative) 616842 616842 Phelipps, John, of Churcham, yeoman, executors of 0
3976720 2016423 2016423 defendant Phillipp John (legal representative) 616842 616842 Phillipp, John, of Churcham, yeoman, executors of 0
3985645 2019630 2019630 defendant Phelipps John (legal representative) 616842 616842 Phelipps, John, of Churcham, yeoman, executors of 0
4000525 2024958 2024958 plaintiff Grene John yeoman 616842 616842 Grene, John, of Churcham, yeoman 0
4005658 2026797 2026797 defendant Grene John yeoman 616842 616842 Grene, John, of Churcham, yeoman 0
4005659 2026797 2026797 defendant Holder John yeoman 616842 616842 Holder, John, of Churcham, yeoman 1
4005660 2026797 2026797 defendant Hemyng Richard husbandman 616842 616842 Hemyng, Richard, of Churcham, husbandman 2
4005662 2026798 2026798 defendant Holder John yeoman 616842 616842 Holder, John, of Churcham, yeoman 0
4005663 2026798 2026798 defendant Grene John yeoman 616842 616842 Grene, John, of Churcham, yeoman 1
4005664 2026798 2026798 defendant Hemynge Richard yeoman 616842 616842 Hemynge, Richard, of Churcham, yeoman 2
4038056 2038253 2038253 defendant Grene John yeoman 616842 616842 Grene, John, of Churcham, yeoman 0
4083892 2054512 2054512 defendant Greene Thomas yeoman 616842 616842 Greene, Thomas, of Churcham, yeoman 0
4117033 2066393 2066393 defendant Pears John (legal representative) 616842 616842 Pears, John, of Churcham, yeoman, executrix of 0
4117034 2066393 2066393 defendant Pears Agnes widow 616842 616842 Pears, Agnes, of Churcham, widow 1
4130918 2071370 2071370 defendant Greene Thomas yeoman 616842 616842 Greene, Thomas, of Churcham, yeoman 0
4209027 2098710 2098710 defendant Grene Thomas yeoman 616842 616842 Grene, Thomas, of Churcham, yeoman 0
4235066 2107818 2107818 defendant Howlder John, senior yeoman 616842 616842 Howlder, John, senior, of Churcham, yeoman 1
4235067 2107818 2107818 defendant Howlder John, junior yeoman 616842 616842 Howlder, John, junior, of Churcham, yeoman 2
4235068 2107818 2107818 defendant Rone or Rove John husbandman 616842 616842 Rone or Rove, John, of Churcham, husbandman 3
4236128 2108207 2108207 defendant Wooll or Woolles Thomas yeoman 616842 616842 Wooll or Woolles, Thomas, of Churcham, yeoman 0
4301530 2130650 2130650 defendant Greene James yeoman 616842 616842 Greene, James, of Churcham, yeoman 2
4311259 2134085 2134085 defendant Grene John, senior yeoman 616842 616842 Grene, John, senior, of Churcham, yeoman 0
4311260 2134085 2134085 defendant Grene John, junior yeoman 616842 616842 Grene, John, junior, of Churcham, yeoman 1
4311262 2134086 2134086 defendant Grene John, senior yeoman 616842 616842 Grene, John, senior, of Churcham, yeoman 0
4311263 2134086 2134086 defendant Grene John, junior yeoman 616842 616842 Grene, John, junior, of Churcham, yeoman 1
4376063 2156501 2156501 defendant Payne William yeoman 616842 616842 Payne, William, of Churcham, yeoman 1
5279767 2439165 2439165 defendant Swete John husbandman 616842 616842 Swete, John, of Churcham, husbandman 1
5279768 2439165 2439165 defendant Coke William husbandman 616842 616842 Coke, William, of Churcham, husbandman 2
5279769 2439165 2439165 defendant Adams John husbandman 616842 616842 Adams, John, of Churcham, husbandman 3
5279770 2439165 2439165 defendant Philippes John husbandman 616842 616842 Philippes, John, of Churcham, husbandman 4
5298444 2444521 2444521 defendant Huntley William yeoman 616842 616842 Huntley, William, of Churcham, yeoman 0
5313174 2448972 2448972 defendant Huntley William yeoman 616842 616842 Huntley, William, of Churcham, yeoman 0
5350292 2460212 2460212 defendant Favell William husbandman 616842 616842 Favell, William, of Churcham, husbandman 0
5509280 2507757 2507757 defendant Cok Robert clerk 616842 616842 Cok, Robert, of Churcham, clerk 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);