names

26 rows where place_id = 603752

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655678 1912041 1912041 plaintiff Broke Richard yeoman 603752 603752 Broke, Richard, of Wyngrave, Bucks, yeoman 0
3688370 1922518 1922518 defendant Doncombe William husbandman 603752 603752 Doncombe, William, of Wyngrave, Bucks, husbandman 0
3964846 2012314 2012314 defendant Chapman William husbandman 603752 603752 Chapman, William, of Wyngrave, Bucks, husbandman 1
4002425 2025644 2025644 defendant Chapman William yeoman 603752 603752 Chapman, William, of Wyngrave, Bucks, yeoman 0
4013294 2029488 2029488 defendant Chapman William husbandman 603752 603752 Chapman, William, of Wyngrave, Bucks, husbandman 1
4017566 2030989 2030989 defendant Chapman William husbandman 603752 603752 Chapman, William, of Wyngrave, Bucks, husbandman 0
4690903 2262685 2262685 defendant Heriotte William husbandman 603752 603752 Heriotte, William, of Wyngrave, Bucks, husbandman 2
4690908 2262686 2262686 defendant Heriott William   603752 603752 Heriott, William, of Wyngrave, Bucks 2
4741368 2277973 2277973 defendant Haryetes William husbandman 603752 603752 Haryetes, William, of Wyngrave, Bucks, husbandman 0
4882465 2321426 2321426 defendant Water John maltman 603752 603752 Water, John, of Wyngrave, Bucks, maltman 0
4911183 2330006 2330006 defendant Cook Richard husbandman 603752 603752 Cook, Richard, of Wyngrave, Bucks, husbandman 4
5070528 2377680 2377680 defendant Hanc or Hauc John husbandman 603752 603752 Hanc or Hauc, John, of Wyngrave, Bucks, husbandman 0
5110702 2389535 2389535 defendant Gernon Michael yeoman 603752 603752 Gernon, Michael, of Wyngrave, Bucks, yeoman 0
5110705 2389536 2389536 defendant Gernon Michael yeoman 603752 603752 Gernon, Michael, of Wyngrave, Bucks, yeoman 0
5269605 2436220 2436220 defendant Quaryngdon John husbandman 603752 603752 Quaryngdon, John, of Wyngrave, Bucks, husbandman 1
5402998 2475938 2475938 defendant Haus or Hans Nicholas yeoman 603752 603752 Haus or Hans, Nicholas, of Wyngrave, Bucks, yeoman 3
5407328 2477158 2477158 defendant Querendon John husbandman 603752 603752 Querendon, John, of Wyngrave, Bucks, husbandman 0
5416001 2479717 2479717 defendant Haus Nicholas yeoman 603752 603752 Haus, Nicholas, of Wyngrave, Bucks, yeoman 3
5432666 2484736 2484736 defendant Quaryngdon John husbandman 603752 603752 Quaryngdon, John, of Wyngrave, Bucks, husbandman 1
5432672 2484738 2484738 defendant Quaryngdon John husbandman 603752 603752 Quaryngdon, John, of Wyngrave, Bucks, husbandman 1
5437735 2486224 2486224 defendant Querendon John husbandman 603752 603752 Querendon, John, of Wyngrave, Bucks, husbandman 0
5437738 2486225 2486225 defendant Querendon John husbandman 603752 603752 Querendon, John, of Wyngrave, Bucks, husbandman 0
5512151 2508664 2508664 defendant Trussell John clerk 603752 603752 Trussell, John, of Wyngrave, Bucks, clerk 0
5581926 2529430 2529430 defendant Grace John husbandman 603752 603752 Grace, John, of Wyngrave, Bucks, husbandman 0
5599300 2534663 2534663 defendant Daverse or Danerse Thomas husbandman 603752 603752 Daverse or Danerse, Thomas, of Wyngrave, Bucks, husbandman 1
5632525 2554206 2554206 defendant Pynge Richard husbandman 603752 603752 Pynge, Richard, of Wyngrave, Bucks, 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);