names

57 rows where place_id = 600360

✎ 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
3640737 1907548 1907548 defendant Chamberlayne Sybil widow 600360 600360 Chamberlayne, Sybil, of Shirbourn, widow 2
3646850 1909414 1909414 defendant Baller Thomas husbandman 600360 600360 Baller, Thomas, of Shirbourn, husbandman 0
3681084 1920163 1920163 defendant Nobell Thomas butcher 600360 600360 Nobell, Thomas, of Shirbourn, butcher 0
4443108 2182806 2182806 defendant Sumonour William   600360 600360 Sumonour, William, of Shirbourn 0
4443284 2182860 2182860 defendant Tour John   600360 600360 Tour, John, of Shirbourn 0
4475110 2192885 2192885 defendant Dalton William   600360 600360 Dalton, William, of Shirbourn, vicar 0
4506196 2202445 2202445 defendant Benynstre John   600360 600360 Benynstre, John, of Shirbourn 1
4573036 2223102 2223102 defendant Mason Robert   600360 600360 Mason, Robert, of Shirbourn 0
4577166 2224370 2224370 defendant Lokyer John   600360 600360 Lokyer, John, of Shirbourn 0
4579404 2225036 2225036 defendant Gore Robert   600360 600360 Gore, Robert, of Shirbourn 0
4579409 2225036 2225036 defendant Mourton William   600360 600360 Mourton, William, of Shirbourn 5
4584879 2226702 2226702 defendant Boucher William   600360 600360 Boucher, William, of Shirbourn 1
4584880 2226702 2226702 defendant Cardemaker Nicholas   600360 600360 Cardemaker, Nicholas, of Shirbourn 2
4590466 2228377 2228377 defendant Drake Robert   600360 600360 Drake, Robert, of Shirbourn 0
4596520 2230152 2230152 defendant Ilberd John   600360 600360 Ilberd, John, of Shirbourn 0
4617915 2236606 2236606 defendant Eme John   600360 600360 Eme, John, of Shirbourn 0
4621784 2237797 2237797 plaintiff Leche Peter   600360 600360 Leche, Peter, of Shirbourn 0
4625044 2238796 2238796 defendant Gourneye John   600360 600360 Gourneye, John, of Shirbourn 2
4658423 2248515 2248515 plaintiff Coute William   600360 600360 Coute, William, of Shirbourn 0
4674118 2257512 2257512 defendant Nobylet Robert gent 600360 600360 Nobylet, Robert, of Shirbourn, gent 3
4708366 2267987 2267987 plaintiff Noblet John (legal representative) 600360 600360 Noblet, John, of Shirbourn, executors of 0
4708371 2267987 2267987 defendant Jolyf Robert gent 600360 600360 Jolyf, Robert, of Shirbourn, gent 1
4778972 2289401 2289401 defendant Gugge alias Bemystre William   600360 600360 Gugge alias Bemystre, William, of Shirbourn, millward 0
4800961 2296491 2296491 defendant Combe Richard weaver 600360 600360 Combe, Richard, of Shirbourn, weaver 0
4820475 2302478 2302478 defendant Colbowyer Robert   600360 600360 Colbowyer, Robert, of Shirbourn, bow maker 1
4821760 2302883 2302883 defendant Dale Henry dyer 600360 600360 Dale, Henry, of Shirbourn, dyer 0
4827051 2304502 2304502 defendant LitelJohn Alice widow 600360 600360 LitelJohn, Alice, of Shirbourn, widow 0
4852214 2312122 2312122 defendant Hillary John gent 600360 600360 Hillary, John, of Shirbourn, gent 0
4880146 2320703 2320703 defendant Hillary John gent 600360 600360 Hillary, John, of Shirbourn, gent 0
4889250 2323423 2323423 defendant Preston John chapman 600360 600360 Preston, John, of Shirbourn, chapman 1
4889252 2323424 2323424 defendant Kest Walter   600360 600360 Kest, Walter, of Shirbourn, mason 0
4916434 2331639 2331639 defendant Trybell Richard husbandman 600360 600360 Trybell, Richard, of Shirbourn, husbandman 0
4927608 2335072 2335072 defendant Alampton John weaver 600360 600360 Alampton, John, of Shirbourn, weaver 2
4940116 2338936 2338936 defendant Cornyssh John chaplain 600360 600360 Cornyssh, John, of Shirbourn, chaplain 2
4940117 2338936 2338936 defendant Makemery William weaver 600360 600360 Makemery, William, of Shirbourn, weaver 3
4995526 2355502 2355502 defendant Barbour Richard barber 600360 600360 Barbour, Richard, of Shirbourn, barber 1
5010363 2359899 2359899 defendant Archer Nicholas   600360 600360 Archer, Nicholas, of Shirbourn, servant 3
5051382 2372029 2372029 defendant Marchall Richard gent 600360 600360 Marchall, Richard, of Shirbourn, gent 0
5107193 2388533 2388533 defendant Tytelyng John brasyeter or brewer 600360 600360 Tytelyng, John, of Shirbourn, brasyeter or brewer 0
5107195 2388534 2388534 defendant Tytelyng John brasyeter or brewer 600360 600360 Tytelyng, John, of Shirbourn, brasyeter or brewer 0
5120646 2392467 2392467 defendant Kayeton John chaplain 600360 600360 Kayeton, John, of Shirbourn, chaplain 0
5139559 2398055 2398055 defendant Herward Thomas husbandman 600360 600360 Herward, Thomas, of Shirbourn, husbandman 3
5139560 2398055 2398055 defendant Laurens Richard husbandman 600360 600360 Laurens, Richard, of Shirbourn, husbandman 4
5139565 2398056 2398056 defendant Herward Thomas husbandman 600360 600360 Herward, Thomas, of Shirbourn, husbandman 3
5244188 2428496 2428496 plaintiff Peny Nicholas (legal representative) 600360 600360 Peny, Nicholas, of Shirbourn, executor of 0
5320169 2451122 2451122 defendant Pyle Thomas singleman 600360 600360 Pyle, Thomas, of Shirbourn, yeoman, singleman 0
5320170 2451122 2451122 defendant Pyle Walter weaver 600360 600360 Pyle, Walter, of Shirbourn, weaver 1
5320171 2451122 2451122 defendant Dyer Richard husbandman 600360 600360 Dyer, Richard, of Shirbourn, husbandman 2
5352845 2460978 2460978 defendant Belle Walter husbandman 600360 600360 Belle, Walter, of Shirbourn, husbandman 1
5382662 2470100 2470100 defendant Dyer Walter dyer 600360 600360 Dyer, Walter, of Shirbourn, dyer 0
5469354 2495763 2495763 defendant Growenyng Edward skinner 600360 600360 Growenyng, Edward, of Shirbourn, skinner 1
5480556 2499157 2499157 defendant Browenyng Edwin skinner 600360 600360 Browenyng, Edwin, of Shirbourn, skinner 3
5555732 2521670 2521670 defendant Bruer John yeoman 600360 600360 Bruer, John, of Shirbourn, yeoman 0
5579945 2528807 2528807 defendant Trevysan John baker 600360 600360 Trevysan, John, of Shirbourn, baker 0
5610443 2546982 2546982 defendant Bouchere Thomas   600360 600360 Bouchere, Thomas, of Shirbourn 1
5621675 2550685 2550685 defendant Jolyf Robert   600360 600360 Jolyf, Robert, of Shirbourn 0
5621677 2550686 2550686 defendant Jolyf Robert   600360 600360 Jolyf, Robert, of Shirbourn 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);