names

73 rows where place_id = 599635

✎ 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
3637563 1906559 1906559 defendant Twychener Robert dyer 599635 599635 Twychener, Robert, of Chertesey, dyer 0
3652524 1911120 1911120 defendant Pygott John beer brewer 599635 599635 Pygott, John, of Chertesey, beer brewer 0
3653637 1911400 1911400 defendant Pycot John husbandman 599635 599635 Pycot, John, of Chertesey, husbandman 0
3653642 1911402 1911402 defendant Habson Henry   599635 599635 Habson, Henry, of Chertesey, tile maker 0
3659678 1913283 1913283 defendant Wright William smith 599635 599635 Wright, William, of Chertesey, smith 2
3678876 1919460 1919460 defendant Broke Richard husbandman 599635 599635 Broke, Richard, of Chertesey, husbandman 0
3762653 1945955 1945955 defendant Valance George husbandman 599635 599635 Valance, George, of Chertesey, husbandman 0
4174865 2086677 2086677 defendant Carter John yeoman 599635 599635 Carter, John, of Chertesey, yeoman 2
4545076 2214381 2214381 defendant Ingram Richard   599635 599635 Ingram, Richard, of Chertesey 2
4558204 2218506 2218506 defendant Ingram Richard   599635 599635 Ingram, Richard, of Chertesey 2
4596980 2230299 2230299 plaintiff Sawyer John   599635 599635 Sawyer, John, of Chertesey 0
4603436 2232265 2232265 defendant Estele William tailor 599635 599635 Estele, William, of Chertesey, tailor 1
4866228 2316405 2316405 defendant Best John, junior laborer 599635 599635 Best, John, junior, of Chertesey, laborer 0
4867866 2316922 2316922 defendant Bonnalet John husbandman 599635 599635 Bonnalet, John, of Chertesey, husbandman 0
4867916 2316935 2316935 defendant Guny John tailor 599635 599635 Guny, John, of Chertesey, tailor 0
5040784 2368860 2368860 defendant Hert Thomas   599635 599635 Hert, Thomas, of Chertesey, bailiff 1
5043033 2369533 2369533 defendant Hert Thomas   599635 599635 Hert, Thomas, of Chertesey, wax chandler 0
5043037 2369533 2369533 defendant Weller John laborer 599635 599635 Weller, John, of Chertesey, laborer 4
5043038 2369533 2369533 defendant Skelton Thomas baker 599635 599635 Skelton, Thomas, of Chertesey, baker 5
5097279 2385635 2385635 defendant Lewe Mathew cordwainer 599635 599635 Lewe, Mathew, of Chertesey, cordwainer 0
5130567 2395424 2395424 defendant Marler William husbandman 599635 599635 Marler, William, of Chertesey, husbandman 5
5149989 2401128 2401128 defendant Marler William husbandman 599635 599635 Marler, William, of Chertesey, husbandman 6
5168693 2406569 2406569 defendant Hert Thomas (legal representative) 599635 599635 Hert, Thomas, of Chertesey, yeoman, executors of 3
5168695 2406569 2406569 defendant Marler William husbandman 599635 599635 Marler, William, of Chertesey, husbandman 5
5168701 2406570 2406570 defendant Hert Thomas (legal representative) 599635 599635 Hert, Thomas, of Chertesey, yeoman, executors of 3
5168703 2406570 2406570 defendant Marler William husbandman 599635 599635 Marler, William, of Chertesey, husbandman 5
5186282 2411740 2411740 defendant Skelton Thomas baker 599635 599635 Skelton, Thomas, of Chertesey, baker 1
5258170 2432675 2432675 defendant FitzJohn Henry esq 599635 599635 FitzJohn, Henry, of Chertesey, esq 0
5322170 2451703 2451703 defendant Aleyn Robert miller 599635 599635 Aleyn, Robert, of Chertesey, miller 0
5398992 2474783 2474783 defendant Campion Isabella widow 599635 599635 Campion, Isabella, of Chertesey, widow 0
5406127 2476827 2476827 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5409032 2477665 2477665 defendant Campion Isabel widow 599635 599635 Campion, Isabel, of Chertesey, widow 0
5409718 2477883 2477883 plaintiff Bonne Henry shoemaker 599635 599635 Bonne, Henry, of Chertesey, shoemaker 0
5419178 2480663 2480663 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5419182 2480664 2480664 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5422410 2481650 2481650 defendant Campion Isabel widow 599635 599635 Campion, Isabel, of Chertesey, widow 0
5434458 2485246 2485246 defendant Braddok Ralph yeoman 599635 599635 Braddok, Ralph, of Chertesey, yeoman 0
5435064 2485420 2485420 defendant Machyn John butcher 599635 599635 Machyn, John, of Chertesey, butcher 0
5435065 2485420 2485420 defendant Skelton Margaret widow 599635 599635 Skelton, Margaret, of Chertesey, widow 1
5437355 2486117 2486117 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5445116 2488427 2488427 plaintiff Dunne Henry shoemaker 599635 599635 Dunne, Henry, of Chertesey, shoemaker 0
5447030 2489002 2489002 defendant Latymer Hugh yeoman 599635 599635 Latymer, Hugh, of Chertesey, yeoman 0
5448702 2489508 2489508 defendant Asell John yeoman 599635 599635 Asell, John, of Chertesey, yeoman 0
5448703 2489508 2489508 defendant Latymer Hugh yeoman 599635 599635 Latymer, Hugh, of Chertesey, yeoman 1
5449572 2489760 2489760 defendant Broddoke Ralph porter or potter in the monastery of St Peter 599635 599635 Broddoke, Ralph, of Chertesey, porter or potter in the monastery of St Peter 0
5449833 2489839 2489839 defendant Braddok Ralph   599635 599635 Braddok, Ralph, of Chertesey 0
5451051 2490206 2490206 defendant Creild Robert yeoman 599635 599635 Creild, Robert, of Chertesey, yeoman 0
5451773 2490405 2490405 defendant Grene Robert   599635 599635 Grene, Robert, of Chertesey, 0
5459486 2492749 2492749 defendant Latymer Hugh yeoman 599635 599635 Latymer, Hugh, of Chertesey, yeoman 0
5461727 2493446 2493446 defendant Broddoke Ralph potter in the monastery of St Peter 599635 599635 Broddoke, Ralph, of Chertesey, potter in the monastery of St Peter 0
5463721 2494065 2494065 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5465611 2494625 2494625 defendant Newe William yeoman 599635 599635 Newe, William, of Chertesey, yeoman 0
5465612 2494625 2494625 defendant Peke John laborer 599635 599635 Peke, John, of Chertesey, laborer 1
5465613 2494625 2494625 defendant Bocher Thomas laborer 599635 599635 Bocher, Thomas, of Chertesey, laborer 2
5471219 2496328 2496328 defendant Latymer Hugh yeoman 599635 599635 Latymer, Hugh, of Chertesey, yeoman 0
5471221 2496329 2496329 defendant Letymer Hugh yeoman 599635 599635 Letymer, Hugh, of Chertesey, yeoman 0
5473254 2496962 2496962 defendant Broddoke Ralph potter alias porter in the monastery of St Peter 599635 599635 Broddoke, Ralph, of Chertesey, potter alias porter in the monastery of St Peter 0
5477106 2498159 2498159 defendant Peke Thomas yeoman 599635 599635 Peke, Thomas, of Chertesey, yeoman 1
5477108 2498159 2498159 defendant Bocher Thomas laborer 599635 599635 Bocher, Thomas, of Chertesey, laborer 3
5482469 2499696 2499696 defendant Latymer Hugh yeoman 599635 599635 Latymer, Hugh, of Chertesey, yeoman 0
5484946 2500419 2500419 defendant Braddoke Ralph yeoman 599635 599635 Braddoke, Ralph, of Chertesey, yeoman 0
5484947 2500419 2500419 defendant Braddoke William chaplain 599635 599635 Braddoke, William, of Chertesey, chaplain 1
5486813 2500956 2500956 defendant Grene Robert yeoman 599635 599635 Grene, Robert, of Chertesey, yeoman 0
5521548 2511557 2511557 defendant Parys Robert beer brewer 599635 599635 Parys, Robert, of Chertesey, beer brewer 0
5523265 2512106 2512106 defendant Parys Robert beer brewer 599635 599635 Parys, Robert, of Chertesey, beer brewer 0
5532295 2514642 2514642 defendant Barker Henry smith 599635 599635 Barker, Henry, of Chertesey, smith 0
5565887 2524623 2524623 defendant Wodford Barnard yeoman 599635 599635 Wodford, Barnard, of Chertesey, yeoman 0
5587803 2531203 2531203 defendant Wheteley William husbandman 599635 599635 Wheteley, William, of Chertesey, husbandman 1
5593053 2532813 2532813 plaintiff Wykys Henry   599635 599635 Wykys, Henry, of Chertesey 0
5605401 2536568 2536568 defendant Stubbys William mercer 599635 599635 Stubbys, William, of Chertesey, mercer 0
5607720 2537317 2537317 defendant Broke Richard husbandman 599635 599635 Broke, Richard, of Chertesey, husbandman 0
5607901 2537376 2537376 defendant Drewe William yeoman 599635 599635 Drewe, William, of Chertesey, yeoman 0
5607903 2537377 2537377 defendant Smyth Thomas barber 599635 599635 Smyth, Thomas, of Chertesey, barber 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);