names

40 rows where place_id = 608970

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676347 1918646 1918646 defendant Threle Edmund gent 608970 608970 Threle, Edmund, of Ardyngton, gent 0
3829534 1967125 1967125 defendant Ardyngton Henry esq 608970 608970 Ardyngton, Henry, of Ardyngton, esq 1
3829539 1967127 1967127 defendant Ardyngton Henry esq 608970 608970 Ardyngton, Henry, of Ardyngton, esq 1
3905213 1992006 1992006 defendant Fayrer Gabriel merchant 608970 608970 Fayrer, Gabriel, of Ardyngton, merchant 0
3973656 2015358 2015358 defendant Ardyngton William gent 608970 608970 Ardyngton, William, of Ardyngton, gent 0
4005677 2026803 2026803 defendant Wardman John yeoman 608970 608970 Wardman, John, of Ardyngton, yeoman 1
4209836 2099001 2099001 defendant Revys Richard laborer 608970 608970 Revys, Richard, of Ardyngton, laborer 0
4209837 2099001 2099001 defendant Sykes Anthony laborer 608970 608970 Sykes, Anthony, of Ardyngton, laborer 1
4418192 2170569 2170569 defendant Maykyn John   608970 608970 Maykyn, John, of Ardyngton 2
4785771 2291586 2291586 defendant Otur John yeoman 608970 608970 Otur, John, of Ardyngton, yeoman 0
4837046 2307545 2307545 plaintiff Fetiplace John   608970 608970 Fetiplace, John, of Ardyngton 1
4839164 2308178 2308178 defendant Fetyplace John gent 608970 608970 Fetyplace, John, of Ardyngton, gent 0
4845218 2310016 2310016 defendant Haukyn Edmund husbandman 608970 608970 Haukyn, Edmund, of Ardyngton, husbandman 0
4964901 2346417 2346417 defendant Hode Thomas laborer 608970 608970 Hode, Thomas, of Ardyngton, laborer 3
4964907 2346419 2346419 defendant Hode Thomas laborer 608970 608970 Hode, Thomas, of Ardyngton, laborer 2
4969411 2347806 2347806 defendant Tame John husbandman 608970 608970 Tame, John, of Ardyngton, husbandman 0
5005418 2358485 2358485 defendant Longe John clerk 608970 608970 Longe, John, of Ardyngton, clerk 0
5010196 2359846 2359846 defendant Clerk John husbandman 608970 608970 Clerk, John, of Ardyngton, husbandman 0
5096054 2385277 2385277 defendant Clerk John yeoman 608970 608970 Clerk, John, of Ardyngton, yeoman 0
5243675 2428344 2428344 defendant Fittewell William carpenter 608970 608970 Fittewell, William, of Ardyngton, carpenter 0
5243676 2428344 2428344 defendant Herman John husbandman 608970 608970 Herman, John, of Ardyngton, husbandman 1
5243677 2428344 2428344 defendant Husband Richard husbandman 608970 608970 Husband, Richard, of Ardyngton, husbandman 2
5243678 2428344 2428344 defendant Coor John tailor 608970 608970 Coor, John, of Ardyngton, tailor 3
5388180 2471673 2471673 defendant Bradford William walker 608970 608970 Bradford, William, of Ardyngton, walker 0
5388181 2471673 2471673 defendant Jakson Robert miller 608970 608970 Jakson, Robert, of Ardyngton, miller 1
5388182 2471673 2471673 defendant Wadyngton William walker 608970 608970 Wadyngton, William, of Ardyngton, walker 2
5388183 2471673 2471673 defendant Wayte Thomas laborer 608970 608970 Wayte, Thomas, of Ardyngton, laborer 3
5388184 2471673 2471673 defendant Kaa Roger walker 608970 608970 Kaa, Roger, of Ardyngton, walker 4
5388185 2471673 2471673 defendant Wayte John laborer 608970 608970 Wayte, John, of Ardyngton, laborer 5
5388186 2471673 2471673 defendant Whiteacreas William smith 608970 608970 Whiteacreas, William, of Ardyngton, smith 6
5388187 2471673 2471673 defendant Willyamson John laborer 608970 608970 Willyamson, John, of Ardyngton, laborer 7
5388188 2471673 2471673 defendant Bradford William, junior laborer 608970 608970 Bradford, William, junior, of Ardyngton, laborer 8
5388189 2471673 2471673 defendant Symm William laborer 608970 608970 Symm, William, of Ardyngton, laborer 9
5388190 2471673 2471673 defendant Mortimer Thomas laborer 608970 608970 Mortimer, Thomas, of Ardyngton, laborer 10
5388191 2471673 2471673 defendant Naute William tailor 608970 608970 Naute, William, of Ardyngton, tailor 11
5512792 2508853 2508853 defendant Milton Richard laborer 608970 608970 Milton, Richard, of Ardyngton, laborer 0
5531550 2514401 2514401 defendant Colyns John butcher 608970 608970 Colyns, John, of Ardyngton, butcher 0
5531551 2514401 2514401 defendant Cutterwold John clerk 608970 608970 Cutterwold, John, of Ardyngton, clerk 1
5548477 2519592 2519592 defendant Carpenter Henry husbandman 608970 608970 Carpenter, Henry, of Ardyngton, husbandman 0
5548481 2519593 2519593 defendant Carpenter Henry husbandman 608970 608970 Carpenter, Henry, of Ardyngton, 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);