names

70 rows where place_id = 592724

✎ 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
3608635 1870361 1870361 defendant Blome John smith 592724 592724 Blome, John, of Rumsey, smith 3
3609399 1870600 1870600 defendant Stylfeld William brewer 592724 592724 (Stylfeld, William, of Rumsey, brewer 1
3707908 1928770 1928770 defendant Norton Robert merchant 592724 592724 Norton, Robert, of Rumsey, dyer, merchant 0
3707910 1928771 1928771 defendant Norton Robert merchant 592724 592724 Norton, Robert, of Rumsey, dyer, merchant 0
3864347 1978271 1978271 defendant Bull John chapman 592724 592724 Bull, John, of Rumsey, chapman 1
3966309 2012842 2012842 defendant Perkyns Oswald capper 592724 592724 Perkyns, Oswald, of Rumsey, capper 0
3966310 2012842 2012842 defendant Perkyns John capper 592724 592724 Perkyns, John, of Rumsey, capper 1
4102964 2061349 2061349 defendant Hamon Richard tanner 592724 592724 Hamon, Richard, of Rumsey, tanner 0
4220143 2102546 2102546 defendant Barrowe Edward esq 592724 592724 Barrowe, Edward, of Rumsey, esq 0
4363244 2151921 2151921 defendant Cowse Richard mercer 592724 592724 Cowse, Richard, of Rumsey, mercer 0
4376851 2156792 2156792 defendant Harvie William mercer 592724 592724 Harvie, William, of Rumsey, mercer 0
4511171 2203943 2203943 defendant Kyngeston Nicholas   592724 592724 Kyngeston, Nicholas, of Rumsey 3
4511180 2203944 2203944 defendant Thorn Thomas   592724 592724 Thorn, Thomas, of Rumsey 4
4584661 2226623 2226623 defendant Marchall John   592724 592724 Marchall, John, of Rumsey 2
4584665 2226624 2226624 defendant Marchall John   592724 592724 Marchall, John, of Rumsey 2
4674604 2257664 2257664 defendant Whyte Stephen dyer 592724 592724 Whyte, Stephen, of Rumsey, dyer 0
4678071 2258750 2258750 defendant Taunton Roger chapman 592724 592724 Taunton, Roger, of Rumsey, chapman 0
4680159 2259403 2259403 defendant Hayne John goldsmith 592724 592724 Hayne, John, of Rumsey, Hants & of Stowe St Edward, Gloucs, goldsmith 0
4798999 2295860 2295860 defendant Riche Henry ostler 592724 592724 Riche, Henry, of Rumsey, ostler 1
4807455 2298524 2298524 defendant Harnyst Richard weaver 592724 592724 Harnyst, Richard, of Rumsey, weaver 0
4816047 2301108 2301108 defendant Cooke John husbandman 592724 592724 Cooke, John, of Rumsey, husbandman 0
4899142 2326374 2326374 defendant Russyngton Robert husbandman 592724 592724 Russyngton, Robert, of Rumsey, husbandman 0
5072363 2378220 2378220 defendant Artoure John smith 592724 592724 Artoure, John, of Rumsey, smith 0
5090064 2383465 2383465 defendant Farley John yeoman 592724 592724 Farley, John, of Rumsey, yeoman 0
5091134 2383804 2383804 defendant Baker William baker 592724 592724 Baker, William, of Rumsey, baker 0
5096029 2385267 2385267 defendant Sevyere William merchant 592724 592724 Sevyere, William, of Rumsey, merchant 0
5123465 2393312 2393312 defendant Gyles Thomas yeoman 592724 592724 Gyles, Thomas, of Rumsey, yeoman 0
5137891 2397593 2397593 defendant atte Hethe Joan spinster 592724 592724 atte Hethe, Joan, of Rumsey, spinster 4
5170746 2407165 2407165 defendant Underwode Richard mercer 592724 592724 Underwode, Richard, of Rumsey, mercer 3
5186506 2411802 2411802 defendant Langford Thomas yeoman 592724 592724 Langford, Thomas, of Rumsey, yeoman 0
5186508 2411802 2411802 defendant Langford Cecily   592724 592724 Langford, Cecily, of Rumsey, servant 2
5186509 2411802 2411802 defendant Hille John fuller 592724 592724 Hille, John, of Rumsey, fuller 3
5218457 2421128 2421128 defendant Hyde Robert tanner 592724 592724 Hyde, Robert, of Rumsey, tanner 0
5218915 2421258 2421258 defendant Bony or Bovy Robert shoemaker 592724 592724 Bony or Bovy, Robert, of Rumsey, shoemaker 0
5234727 2425744 2425744 defendant Lyle John laborer 592724 592724 Lyle, John, of Rumsey, laborer 0
5265756 2435040 2435040 defendant Everard Thomas   592724 592724 Everard, Thomas, of Rumsey, court holder 0
5265757 2435040 2435040 defendant Notte John husbandman 592724 592724 Notte, John, of Rumsey, husbandman 1
5266930 2435408 2435408 defendant Underwode Richard tucker 592724 592724 Underwode, Richard, of Rumsey, tucker 1
5266931 2435408 2435408 defendant Gyles Thomas weaver 592724 592724 Gyles, Thomas, of Rumsey, weaver 2
5284632 2440519 2440519 defendant Gregory John yeoman 592724 592724 Gregory, John, of Rumsey, yeoman 0
5284633 2440519 2440519 defendant Gregory Joan widow 592724 592724 Gregory, Joan, of Rumsey, widow 1
5286300 2441000 2441000 defendant atte Well William tanner 592724 592724 atte Well, William, of Rumsey, tanner 0
5298876 2444652 2444652 defendant Curteys Henry fuller 592724 592724 Curteys, Henry, of Rumsey, fuller 0
5298877 2444652 2444652 defendant Gregory John dyer 592724 592724 Gregory, John, of Rumsey, dyer 1
5298878 2444652 2444652 defendant at Noke Wililam husbandman 592724 592724 at Noke, Wililam, of Rumsey, husbandman 2
5313327 2449024 2449024 defendant Halle William   592724 592724 Halle, William, of Rumsey, wax chandler 1
5313452 2449055 2449055 plaintiff Borde John butcher 592724 592724 Borde, John, of Rumsey, butcher 0
5315347 2449647 2449647 plaintiff Cokys Thomas mercer 592724 592724 Cokys, Thomas, of Rumsey, mercer 0
5315349 2449647 2449647 defendant Hebbys John   592724 592724 Hebbys, John, of Rumsey, "helyer" 1
5351938 2460709 2460709 defendant Cokkys Thomas husbandman 592724 592724 Cokkys, Thomas, of Rumsey, husbandman 0
5390631 2472382 2472382 defendant Hake William yeoman 592724 592724 Hake, William, of Rumsey, yeoman 3
5416636 2479891 2479891 defendant Hake William yeoman 592724 592724 Hake, William, of Rumsey, yeoman 3
5450053 2489906 2489906 defendant Staitroute Stephen husbandman 592724 592724 Staitroute, Stephen, of Rumsey, husbandman 0
5450054 2489906 2489906 defendant Holme John husbandman 592724 592724 Holme, John, of Rumsey, husbandman 1
5450863 2490146 2490146 defendant Hake William fuller 592724 592724 Hake, William, of Rumsey, fuller 0
5490554 2502065 2502065 defendant Dekyn John husbandman 592724 592724 Dekyn, John, of Rumsey, husbandman 2
5491170 2502258 2502258 defendant Allerege Edward husbandman 592724 592724 Allerege, Edward, of Rumsey, husbandman 1
5491171 2502258 2502258 defendant Stilneld William husbandman 592724 592724 Stilneld, William, of Rumsey, husbandman 2
5491172 2502258 2502258 defendant Hewet John husbandman 592724 592724 Hewet, John, of Rumsey, husbandman 3
5497663 2504244 2504244 defendant Calken or Cawen Luke dyer 592724 592724 Calken or Cawen, Luke, of Rumsey, dyer 0
5497665 2504245 2504245 defendant Calken Luke dyer 592724 592724 Calken, Luke, of Rumsey, dyer 0
5539924 2516967 2516967 plaintiff Hall Ralph glover 592724 592724 Hall, Ralph, of Rumsey, glover 0
5540761 2517238 2517238 defendant Dyer Walter tanner 592724 592724 Dyer, Walter, of Rumsey, tanner 1
5567063 2524953 2524953 defendant Saunder William husbandman 592724 592724 Saunder, William, of Rumsey, husbandman 0
5567064 2524953 2524953 defendant Lower Robert husbandman 592724 592724 Lower, Robert, of Rumsey, husbandman 1
5567065 2524953 2524953 defendant Newman Richard husbandman 592724 592724 Newman, Richard, of Rumsey, husbandman 2
5567066 2524953 2524953 defendant Thomas William husbandman 592724 592724 Thomas, William, of Rumsey, husbandman 3
5579886 2528789 2528789 defendant Otewey William tanner 592724 592724 Otewey, William, of Rumsey, tanner 0
5589142 2531612 2531612 defendant Awey William tanner 592724 592724 Awey, William, of Rumsey, tanner 1
5589143 2531612 2531612 defendant Molenns Henry yeoman 592724 592724 Molenns, Henry, of Rumsey, yeoman 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);