names

45 rows where place_id = 606435

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3665192 1915066 1915066 defendant Dykeson Adam smith 606435 606435 Dykeson, Adam, of Stretham, smith 0
3709807 1929384 1929384 defendant Mychell William chaplain 606435 606435 Mychell, William, of Stretham, chaplain 0
3709808 1929384 1929384 defendant Heryngham William laborer 606435 606435 Heryngham, William, of Stretham, laborer 1
3709809 1929384 1929384 defendant Maltby Thomas laborer 606435 606435 Maltby, Thomas, of Stretham, laborer 2
3853694 1974787 1974787 defendant Savage William husbandman 606435 606435 Savage, William, of Stretham, husbandman 2
3877947 1982869 1982869 defendant Lownders Clement husbandman 606435 606435 Lownders, Clement, of Stretham, husbandman 0
3877949 1982870 1982870 defendant Lownders Clement husbandman 606435 606435 Lownders, Clement, of Stretham, husbandman 0
4167805 2084227 2084227 defendant Hynton William keelman 606435 606435 Hynton, William, of Stretham, keelman 4
4248466 2112474 2112474 defendant Holland John gent 606435 606435 Holland, John, of Stretham, gent 1
4353150 2148330 2148330 defendant Sole John husbandman 606435 606435 Sole, John, of Stretham, husbandman 1
4386178 2160057 2160057 defendant Buttes John gent 606435 606435 Buttes, John, of Stretham, gent 0
4417197 2170256 2170256 defendant Shepherd John le   606435 606435 Shepherd, John le, of Stretham 0
4625181 2238840 2238840 defendant Elsyng John   606435 606435 Elsyng, John, of Stretham, parson 4
4809990 2299282 2299282 defendant Cokayn John husbandman 606435 606435 Cokayn, John, of Stretham, husbandman 2
4916099 2331536 2331536 defendant Colvyle Geoffrey husbandman 606435 606435 Colvyle, Geoffrey, of Stretham, husbandman 3
4926206 2334619 2334619 defendant Cotes Thomas husbandman 606435 606435 Cotes, Thomas, of Stretham, husbandman 5
4926213 2334620 2334620 defendant Cotes Thomas husbandman 606435 606435 Cotes, Thomas, of Stretham, husbandman 5
4978770 2350600 2350600 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 0
5005788 2358591 2358591 defendant Dunnyng John husbandman 606435 606435 Dunnyng, John, of Stretham, husbandman 3
5015789 2361504 2361504 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 0
5047690 2370927 2370927 defendant Baret Thomas chaplain 606435 606435 Baret, Thomas, of Stretham, chaplain 0
5055268 2373160 2373160 defendant Snell or Suell Thomas yeoman 606435 606435 Snell or Suell, Thomas, of Stretham, or of Croydon, Surrey, yeoman 0
5055274 2373163 2373163 defendant Snell or Suell Thomas yeoman 606435 606435 Snell or Suell, Thomas, of Stretham, or of Croydon, Surrey, yeoman 0
5064802 2376010 2376010 defendant Stede John yeoman 606435 606435 Stede, John, of Stretham, yeoman 0
5065845 2376305 2376305 defendant Westhorp Warren laborer 606435 606435 Westhorp, Warren, of Stretham, laborer 0
5065850 2376307 2376307 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 0
5075735 2379246 2379246 defendant Snelle or Suelle Thomas husbandman 606435 606435 Snelle or Suelle, Thomas, of Stretham, husbandman 0
5106695 2388384 2388384 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 2
5106699 2388385 2388385 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 0
5114480 2390633 2390633 defendant Gerard John husbandman 606435 606435 Gerard, John, of Stretham, husbandman 1
5115199 2390867 2390867 defendant Bedyll John husbandman 606435 606435 Bedyll, John, of Stretham, husbandman 0
5115522 2390965 2390965 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 0
5117090 2391425 2391425 defendant Michell Robert husbandman 606435 606435 Michell, Robert, of Stretham, husbandman 2
5299103 2444718 2444718 defendant Webster William fishmonger 606435 606435 Webster, William, of Stretham, fishmonger 0
5342237 2457766 2457766 defendant Gerard John tilemaker 606435 606435 Gerard, John, of Stretham, tilemaker 0
5343567 2458176 2458176 defendant Creste John husbandman 606435 606435 Creste, John, of Stretham, husbandman 0
5343568 2458176 2458176 defendant Goodeherst Richard husbandman 606435 606435 Goodeherst, Richard, of Stretham, husbandman 1
5343569 2458176 2458176 defendant Willoughby John husbandman 606435 606435 Willoughby, John, of Stretham, husbandman 2
5343570 2458176 2458176 defendant Greve Roger collier 606435 606435 Greve, Roger, of Stretham, collier 3
5412739 2478760 2478760 defendant Garrerd John husbandman 606435 606435 Garrerd, John, of Stretham, husbandman 1
5427627 2483221 2483221 defendant Garrard John husbandman 606435 606435 Garrard, John, of Stretham, husbandman 0
5427638 2483224 2483224 defendant Garrard John husbandman 606435 606435 Garrard, John, of Stretham, husbandman 0
5427647 2483226 2483226 defendant Garrard John husbandman 606435 606435 Garrard, John, of Stretham, husbandman 1
5445341 2488503 2488503 defendant Garrard John husbandman 606435 606435 Garrard, John, of Stretham, husbandman 0
5483233 2499927 2499927 defendant Chaunceler Robert husbandman 606435 606435 Chaunceler, Robert, of Stretham, husbandman 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);