names

43 rows where place_id = 600422

✎ 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
3640982 1907619 1907619 defendant Strode Thomas yeoman 600422 600422 Strode, Thomas, of Stevenache, yeoman 1
3668118 1915974 1915974 defendant Algor William yeoman 600422 600422 Algor, William,of Stevenache, yeoman 0
3691488 1923494 1923494 defendant Mathewe Robert yeoman 600422 600422 Mathewe, Robert, of Stevenache, yeoman 0
3691489 1923494 1923494 defendant Auncell Richard laborer 600422 600422 Auncell, Richard, of Stevenache, laborer 1
3831153 1967629 1967629 defendant Metcalff George husbandman 600422 600422 Metcalff, George, of Stevenache, husbandman 0
3877694 1982782 1982782 defendant Wylshyre Edward husbandman 600422 600422 Wylshyre, Edward, of Stevenache, husbandman 0
3914628 1995236 1995236 defendant Heethe Roger husbandman 600422 600422 Heethe, Roger, of Stevenache, husbandman 0
3914629 1995236 1995236 defendant Heethe Thomas husbandman 600422 600422 Heethe, Thomas, of Stevenache, husbandman 1
3914630 1995236 1995236 defendant Sewell Richard husbandman 600422 600422 Sewell, Richard, of Stevenache, husbandman 2
3965716 2012624 2012624 defendant Clarke Thomas husbandman 600422 600422 Clarke, Thomas, of Stevenache, husbandman 0
4473790 2192446 2192446 defendant Kyng Thomas   600422 600422 Kyng, Thomas, of Stevenache 1
4483305 2195479 2195479 plaintiff Noreys John   600422 600422 Noreys, John, of Stevenache 0
4520109 2206622 2206622 defendant Brokesbourne Richard   600422 600422 Brokesbourne, Richard, of Stevenache 0
4567241 2221314 2221314 defendant Wryght John   600422 600422 Wryght, John, of Stevenache, wheel wright 3
4601627 2231725 2231725 defendant Threhous Joan   600422 600422 Threhous, Joan, of Stevenache 0
4601630 2231726 2231726 defendant Threhous Joan   600422 600422 Threhous, Joan, of Stevenache 0
4752761 2281262 2281262 defendant Cropper John husbandman 600422 600422 Cropper, John, of Stevenache, husbandman 4
4786178 2291713 2291713 defendant Chapman Richard maltman 600422 600422 Chapman, Richard, of Stevenache, maltman 0
4813200 2300243 2300243 defendant Russell John husbandman 600422 600422 Russell, John, of Stevenache, husbandman 0
4892178 2324299 2324299 defendant Brokesburne John (legal representative) 600422 600422 Brokesburne, John, of Stevenache, esq, executors of 0
4892180 2324299 2324299 defendant Hylyon Thomas   600422 600422 Hylyon, Thomas, of Stevenache, bailiff 2
4895711 2325335 2325335 defendant Brokesburne John (legal representative) 600422 600422 Brokesburne, John, of Stevenache, esq, executors of 0
4898397 2326154 2326154 defendant Dey Simon husbandman 600422 600422 Dey, Simon, of Stevenache, husbandman 0
4902540 2327413 2327413 defendant Brokesburne John (legal representative) 600422 600422 Brokesburne, John, of Stevenache, esq, executors of 0
4902542 2327413 2327413 defendant Harmour John skinner 600422 600422 Harmour, John, of Stevenache, skinner 2
4912614 2330447 2330447 defendant Berrefe John husbandman 600422 600422 Berrefe, John, of Stevenache, husbandman 0
4969010 2347694 2347694 defendant Neuman John wheeler 600422 600422 Neuman, John, of Stevenache, wheeler 1
4969013 2347695 2347695 defendant Neuman John wheeler 600422 600422 Neuman, John, of Stevenache, wheeler 1
4979774 2350906 2350906 defendant Hamond Roger (legal representative) 600422 600422 Hamond, Roger, of Stevenache, executors of 0
4979775 2350906 2350906 defendant Gene or Geve Henry husbandman 600422 600422 (Gene or Geve, Henry, of Stevenache, husbandman 1
5010370 2359901 2359901 defendant Brokesburne John (legal representative) 600422 600422 Brokesburne, John, of Stevenache, esq, executor of 0
5010371 2359901 2359901 defendant Harmour John skinner 600422 600422 Harmour, John, of Stevenache, skinner 1
5053554 2372665 2372665 defendant atte Gate William husbandman 600422 600422 atte Gate, William, of Stevenache, husbandman 0
5053555 2372665 2372665 defendant Loder William   600422 600422 Loder, William, of Stevenache, servant 1
5111907 2389870 2389870 defendant Puttenham Richard   600422 600422 Puttenham, Richard, of Stevenache, holy water clerk 1
5113419 2390317 2390317 defendant Burwell George butcher 600422 600422 Burwell, George, of Stevenache, butcher 1
5234069 2425554 2425554 defendant Doget William yeoman 600422 600422 Doget, William, of Stevenache, yeoman 0
5234072 2425555 2425555 defendant Doget William yeoman 600422 600422 Doget, William, of Stevenache, yeoman 0
5245254 2428767 2428767 defendant Neweman John husbandman 600422 600422 Neweman, John, of Stevenache, husbandman 1
5363576 2464262 2464262 defendant Folkemare Walter husbandman 600422 600422 Folkemare, Walter, of Stevenache, husbandman 1
5528864 2513549 2513549 defendant Puncard William husbandman 600422 600422 Puncard, William, of Stevenache, husbandman 0
5528865 2513549 2513549 defendant Hunt John husbandman 600422 600422 Hunt, John, of Stevenache, husbandman 1
5609199 2537781 2537781 defendant Chaunseler John smith 600422 600422 Chaunseler, John, of Stevenache, smith 2

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