names

119 rows where place_id = 589811

✎ 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
3598854 1867266 1867266 plaintiff Stubbard Nicholas   589811 589811 Stubbard, Nicholas, of Cratfeld 0
3602501 1868441 1868441 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
3602504 1868442 1868442 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
3614878 1872307 1872307 defendant Ruyshale John clerk 589811 589811 Ruyshale, John, of Cratfeld, clerk 4
3616252 1872724 1872724 defendant Smyth Simon yeoman 589811 589811 Smyth, Simon, of Cratfeld, yeoman 1
3616255 1872725 1872725 defendant Smyth Simon yeoman 589811 589811 Smyth, Simon, of Cratfeld, yeoman 1
3623390 1874846 1874846 defendant Barette John yeoman 589811 589811 Barette, John, of Cratfeld, yeoman 0
3629899 1904205 1904205 defendant Grave Nicholas husbandman 589811 589811 Grave, Nicholas, of Cratfeld, husbandman 0
3644430 1908676 1908676 defendant Orford William husbandman 589811 589811 Orford, William, of Cratfeld, husbandman 2
3656631 1912327 1912327 defendant Everard John gent 589811 589811 Everard, John, of Cratfeld, gent 3
3672662 1917452 1917452 defendant Everard John gent 589811 589811 Everard, John, of Cratfeld, gent 0
3682185 1920533 1920533 defendant Smyth William husbandman 589811 589811 Smyth, William, of Cratfeld, husbandman 0
3682410 1920600 1920600 defendant Orferd William yeoman 589811 589811 Orferd, William, of Cratfeld, yeoman 0
3733672 1936773 1936773 defendant Orford William husbandman 589811 589811 Orford, William, of Cratfeld, husbandman 0
3736622 1937704 1937704 defendant Orford William husbandman 589811 589811 Orford, William, of Cratfeld, husbandman 0
3747524 1941140 1941140 defendant Orford William husbandman 589811 589811 Orford, William, of Cratfeld, husbandman 0
3750258 1941998 1941998 defendant Barette John gent 589811 589811 Barette, John, of Cratfeld, gent 0
3754074 1943219 1943219 defendant Smyth William husbandman 589811 589811 Smyth, William, of Cratfeld, husbandman 0
3761328 1945549 1945549 defendant Orford William husbandman 589811 589811 Orford, William, of Cratfeld, husbandman 0
3766485 1947176 1947176 defendant Everard John (legal representative) 589811 589811 Everard, John, of Cratfeld, gent, executors of 0
3781435 1951929 1951929 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
3785686 1953315 1953315 plaintiff Orforth William yeoman 589811 589811 Orforth, William, of Cratfeld, yeoman 0
3810321 1961120 1961120 defendant Botomley Robert glover 589811 589811 Botomley, Robert, of Cratfeld, glover 0
3811462 1961477 1961477 defendant Everard John (legal representative) 589811 589811 Everard, John, of Cratfeld, gent, executor of 0
3848572 1973137 1973137 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
3867988 1979527 1979527 defendant Coford William yeoman 589811 589811 Coford, William, of Cratfeld, yeoman 1
3881895 1984198 1984198 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
3928624 1999912 1999912 defendant Stubbard John, junior yeoman 589811 589811 Stubbard, John, junior, of Cratfeld, yeoman 0
3959619 2010458 2010458 plaintiff Smyth John   589811 589811 (Smyth, John, of Cratfeld 1
3959620 2010458 2010458 plaintiff Smyth Simon   589811 589811 Smyth, Simon, of Cratfeld 2
3959743 2010498 2010498 defendant Boller James   589811 589811 Boller, James, of Cratfeld, wheelwright 0
3977223 2016602 2016602 defendant Smythe Richard yeoman 589811 589811 Smythe, Richard, of Cratfeld, yeoman 2
3990801 2021469 2021469 defendant Orford Christopher tailor 589811 589811 Orford, Christopher, of Cratfeld, tailor 0
3990803 2021470 2021470 defendant Orford William yeoman 589811 589811 Orford, William, of Cratfeld, yeoman 0
4100374 2060465 2060465 defendant Borrett Henry yeoman 589811 589811 Borrett, Henry, of Cratfeld, yeoman 1
4147112 2077133 2077133 defendant Goddard William yeoman 589811 589811 Goddard, William, of Cratfeld,yeoman 2
4169006 2084652 2084652 defendant Warner William gent 589811 589811 Warner, William, of Cratfeld, gent 2
4442064 2182441 2182441 defendant Fraunceys William   589811 589811 Fraunceys, William, of Cratfeld 0
4644900 2244575 2244575 plaintiff Mellys Robert   589811 589811 Mellys, Robert, of Cratfeld 0
4663049 2249909 2249909 defendant Mellys Robert husbandman 589811 589811 Mellys, Robert, of Cratfeld, husbandman 0
4664180 2250284 2250284 defendant Melles Robert whitawer 589811 589811 Melles, Robert, of Cratfeld, whitawer 1
4679310 2259140 2259140 defendant Melles Robert husbandman 589811 589811 Melles, Robert, of Cratfeld, husbandman 1
4679382 2259167 2259167 plaintiff Cook William   589811 589811 Cook, William, of Cratfeld 4
4705507 2267087 2267087 defendant Melles Robert husbandman 589811 589811 Melles, Robert, of Cratfeld, husbandman 0
4723046 2272518 2272518 defendant Mellys Stephen yeoman 589811 589811 Mellys, Stephen, of Cratfeld, yeoman 0
4723047 2272518 2272518 defendant Clerk John yeoman 589811 589811 Clerk, John, of Cratfeld, yeoman 1
4730991 2274895 2274895 defendant Mellys Robert husbandman 589811 589811 Mellys, Robert, of Cratfeld, husbandman 0
4741001 2277879 2277879 defendant Howard John husbandman 589811 589811 Howard, John, of Cratfeld, husbandman 3
4745414 2279166 2279166 defendant Melles Robert husbandman 589811 589811 Melles, Robert, of Cratfeld, husbandman 1
4746192 2279380 2279380 defendant Mellys Robert yeoman 589811 589811 Mellys, Robert, of Cratfeld, yeoman 1
4759615 2283352 2283352 defendant Mellys Robert husbandman 589811 589811 Mellys, Robert, of Cratfeld, husbandman 0
4812009 2299869 2299869 defendant Fynne John yeoman 589811 589811 Fynne, John, of Cratfeld, yeoman 2
4818006 2301713 2301713 defendant Clerk William carpenter 589811 589811 Clerk, William, of Cratfeld, carpenter 0
4859336 2314300 2314300 defendant Mellys Robert yeoman 589811 589811 Mellys, Robert, of Cratfeld, yeoman 1
4891859 2324189 2324189 defendant Ayneld Richard husbandman 589811 589811 Ayneld, Richard, of Cratfeld, husbandman 2
4917029 2331832 2331832 plaintiff Fraunceys William   589811 589811 Fraunceys, William, of Cratfeld 0
4917030 2331832 2331832 defendant Fraunceys William   589811 589811 Fraunceys, William, of Cratfeld 0
4992430 2354620 2354620 defendant Fyn John yeoman 589811 589811 Fyn, John, of Cratfeld, yeoman 3
4995869 2355611 2355611 defendant Kyppyng Thomas husbandman 589811 589811 Kyppyng, Thomas, of Cratfeld, husbandman 0
5018312 2362241 2362241 plaintiff Teysard William   589811 589811 Teysard, William, of Cratfeld 1
5042814 2369458 2369458 defendant Alsun William husbandman 589811 589811 Alsun, William, of Cratfeld, husbandman 5
5043648 2369718 2369718 plaintiff Fyn John   589811 589811 Fyn, John, of Cratfeld 0
5069181 2377277 2377277 plaintiff Fynne John   589811 589811 Fynne, John, of Cratfeld 1
5084342 2381828 2381828 plaintiff Fyn John   589811 589811 Fyn, John, of Cratfeld 0
5095157 2384998 2384998 defendant Toly William carpenter 589811 589811 Toly, William, of Cratfeld, carpenter 1
5104106 2387624 2387624 defendant Baret Robert yeoman 589811 589811 Baret, Robert, of Cratfeld, yeoman 0
5107569 2388644 2388644 defendant Gowyn John tailor 589811 589811 Gowyn, John, of Cratfeld, tailor 0
5135463 2396883 2396883 defendant Everard Henry yeoman 589811 589811 Everard, Henry, of Cratfeld, yeoman 0
5155726 2402834 2402834 defendant Everarde Henry yeoman 589811 589811 Everarde, Henry, of Cratfeld, yeoman 0
5205135 2417260 2417260 defendant Baldry John yeoman 589811 589811 Baldry, John, of Cratfeld, yeoman 0
5205136 2417260 2417260 defendant Baldry Robert yeoman 589811 589811 Baldry, Robert, of Cratfeld, yeoman 1
5213243 2419606 2419606 defendant Gowen John tailor 589811 589811 Gowen, John, of Cratfeld, tailor 1
5213321 2419628 2419628 defendant Baret Robert husbandman 589811 589811 Baret, Robert, of Cratfeld, husbandman 1
5230265 2424471 2424471 plaintiff Baldry Roger   589811 589811 Baldry, Roger, of Cratfeld 0
5230268 2424472 2424472 plaintiff Baldry Roger   589811 589811 Baldry, Roger, of Cratfeld 0
5230384 2424503 2424503 defendant Baret Geoffrey yeoman 589811 589811 Baret, Geoffrey, of Cratfeld, yeoman 0
5230387 2424504 2424504 defendant Baret Geoffrey yeoman 589811 589811 Baret, Geoffrey, of Cratfeld, yeoman 0
5231463 2424786 2424786 defendant Baret Robert husbandman 589811 589811 Baret, Robert, of Cratfeld, husbandman 0
5234496 2425678 2425678 defendant Baret Robert husbandman 589811 589811 Baret, Robert, of Cratfeld, husbandman 1
5257696 2432527 2432527 defendant Everard Henry (legal representative) 589811 589811 Everard, Henry, of Cratfeld, executors of 0
5257697 2432527 2432527 defendant Everard John yeoman 589811 589811 (Everard, John, of Cratfeld, yeoman 1
5261673 2433762 2433762 defendant Baret Thomas yeoman 589811 589811 Baret, Thomas, of Cratfeld, yeoman 2
5288032 2441515 2441515 defendant Baret Thomas laborer 589811 589811 Baret, Thomas, of Cratfeld, laborer 1
5302324 2445663 2445663 plaintiff Everard John   589811 589811 Everard, John, of Cratfeld 0
5311561 2448481 2448481 defendant Baret Robert yeoman 589811 589811 Baret, Robert, of Cratfeld, yeoman 1
5311569 2448484 2448484 defendant (illegible) John yeoman 589811 589811 _, John, of Cratfeld, yeoman 0
5311570 2448484 2448484 defendant Fasselyn Joan widow 589811 589811 Fasselyn, Joan, of Cratfeld, widow 1
5317119 2450198 2450198 plaintiff Everard John   589811 589811 Everard, John, of Cratfeld 0
5317121 2450199 2450199 plaintiff Everard John   589811 589811 Everard, John, of Cratfeld 0
5325802 2452799 2452799 defendant Nicoll John yeoman 589811 589811 Nicoll, John, of Cratfeld, yeoman 0
5333133 2454980 2454980 defendant Everard John   589811 589811 Everard, John, of Cratfeld, court holder 0
5333134 2454980 2454980 defendant Baret Geoffrey yeoman 589811 589811 Baret, Geoffrey, of Cratfeld, yeoman 1
5333135 2454980 2454980 defendant Nicole John yeoman 589811 589811 Nicole, John, of Cratfeld, yeoman 2
5333136 2454980 2454980 defendant Broun John yeoman 589811 589811 Broun, John, of Cratfeld, yeoman 3
5363254 2464161 2464161 defendant Stubbard Nicholas butcher 589811 589811 Stubbard, Nicholas, of Cratfeld, butcher 3
5364024 2464406 2464406 defendant Baret John yeoman 589811 589811 Baret, John, of Cratfeld, yeoman 0
5478844 2498692 2498692 defendant Baret Thomas yeoman 589811 589811 Baret, Thomas, of Cratfeld, yeoman 2
5478845 2498692 2498692 defendant Kysse Robert yeoman 589811 589811 Kysse, Robert, of Cratfeld, yeoman 3
5490825 2502151 2502151 defendant Nycollys John yeoman 589811 589811 Nycollys, John, of Cratfeld, yeoman 0
5493673 2503020 2503020 plaintiff Everard John (legal representative) 589811 589811 Everard, John, of Cratfeld, executors of 0

Next page

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