names

62 rows where place_id = 603228

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653895 1911482 1911482 defendant Mapulhed Thomas yeoman 603228 603228 Mapulhed, Thomas, of Sprouston, yeoman 2
3653896 1911482 1911482 defendant Jenkyns John yeoman 603228 603228 Jenkyns, John, of Sprouston, yeoman 3
3663105 1914371 1914371 defendant Mapulhed Thomas yeoman 603228 603228 Mapulhed, Thomas, of Sprouston, yeoman 2
3663106 1914371 1914371 defendant Jenkens John yeoman 603228 603228 Jenkens, John, of Sprouston, yeoman 3
3706695 1928379 1928379 defendant Mapled Thomas yeoman 603228 603228 Mapled, Thomas, of Sprouston, yeoman 0
4007344 2027409 2027409 plaintiff Mannyng Maud (legal representative) 603228 603228 Mannyng, Maud, of Sprouston, widow, executor of 0
4644279 2244417 2244417 defendant Sylkeman Walter   603228 603228 Sylkeman, Walter, of Sprouston 1
4644281 2244417 2244417 defendant Martyn Thomas   603228 603228 Martyn, Thomas, of Sprouston 3
4749290 2280270 2280270 defendant del Strete Roger yoeman 603228 603228 del Strete, Roger, of Sprouston, yoeman 8
4768799 2286219 2286219 defendant Aslak Walter   603228 603228 Aslak, Walter, of Sprouston 0
4768801 2286220 2286220 defendant Aslak Walter   603228 603228 Aslak, Walter, of Sprouston 0
4789157 2292662 2292662 defendant Aslak Walter esq 603228 603228 Aslak, Walter, of Sprouston, esq 0
4789161 2292664 2292664 defendant Aslak Walter esq 603228 603228 Aslak, Walter, of Sprouston, esq 0
4809496 2299143 2299143 defendant Deye Robert yeoman 603228 603228 Deye, Robert, of Sprouston, yeoman 2
4813110 2300217 2300217 defendant Chopyng Simon husbandman 603228 603228 Chopyng, Simon, of Sprouston, husbandman 0
4873017 2318519 2318519 defendant Aslak Walter esq 603228 603228 together with Aslak, Walter, of Sprouston, esq 3
4878400 2320190 2320190 defendant Norman Robert yeoman 603228 603228 Norman, Robert, of Sprouston, yeoman 1
4882574 2321458 2321458 defendant Martyn Thomas husbandman 603228 603228 Martyn, Thomas, of Sprouston, husbandman 2
4886209 2322548 2322548 defendant Aslak Walter esq 603228 603228 Aslak, Walter, of Sprouston, esq 0
4895731 2325341 2325341 defendant Deye Robert husbandman 603228 603228 Deye, Robert, of Sprouston, husbandman 1
4904447 2328002 2328002 defendant Martyn Thomas husbandman 603228 603228 Martyn, Thomas, of Sprouston, husbandman 2
4904500 2328015 2328015 defendant Deye Robert husbandman 603228 603228 Deye, Robert, of Sprouston, husbandman 1
4906653 2328668 2328668 defendant Gyllyng James laborer 603228 603228 Gyllyng, James, of Sprouston, laborer 2
4910656 2329843 2329843 plaintiff Aslak Walter   603228 603228 Aslak, Walter, of Sprouston 1
4923692 2333847 2333847 defendant Neke William husbandman 603228 603228 Neke, William, of Sprouston, husbandman 0
4923693 2333847 2333847 defendant Neke John husbandman 603228 603228 Neke, John, of Sprouston, husbandman 1
4936208 2337727 2337727 plaintiff Aslac Walter   603228 603228 Aslac, Walter, of Sprouston 1
4941438 2339344 2339344 defendant Aslak Walter esq 603228 603228 Aslak, Walter, of Sprouston, esq 0
4975925 2349762 2349762 defendant Howlyn Robert chaplain 603228 603228 Howlyn, Robert, of Sprouston, chaplain 1
4981394 2351354 2351354 defendant Brid John yeoman 603228 603228 Brid, John, of Sprouston, yeoman 0
5045135 2370174 2370174 defendant Garbot Willliam husbandman 603228 603228 Garbot, Willliam, of Sprouston, husbandman 1
5045137 2370174 2370174 defendant Norman Robert husbandman 603228 603228 Norman, Robert, of Sprouston, husbandman 3
5045138 2370174 2370174 defendant Benet John fisher woman 603228 603228 Benet, John, of Sprouston, husbandman;Fletcher, Alice, of Norwich, fisher woman 4
5063541 2375622 2375622 defendant Garbot William   603228 603228 Garbot, William, of Sprouston 3
5082763 2381347 2381347 defendant Garbot Clerice clerk 603228 603228 Garbot, Clerice, of Sprouston, clerk 0
5101061 2386722 2386722 defendant Page Robert husbandman 603228 603228 Page, Robert, of Sprouston, husbandman 0
5107761 2388701 2388701 defendant Garbot Clericia widow 603228 603228 Garbot, Clericia, of Sprouston, widow 0
5115261 2390889 2390889 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 0
5120521 2392431 2392431 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 0
5175617 2408552 2408552 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 0
5220695 2421745 2421745 defendant Garbot William husbandman 603228 603228 Garbot, William, of Sprouston, husbandman 0
5232910 2425211 2425211 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 2
5236838 2426358 2426358 plaintiff Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 4
5244817 2428654 2428654 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 4
5284432 2440463 2440463 defendant Gryme Roge husbandman 603228 603228 Gryme, Roge, of Sprouston, husbandman 0
5284440 2440465 2440465 defendant Kyng Lawrence husbandman 603228 603228 Kyng, Lawrence, of Sprouston, husbandman 0
5284935 2440614 2440614 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 2
5289948 2442065 2442065 defendant Aslak Thomas gent 603228 603228 Aslak, Thomas, of Sprouston, gent 1
5289949 2442065 2442065 defendant Lews Thomas husbandman 603228 603228 Lews, Thomas, of Sprouston, husbandman 2
5297242 2444189 2444189 defendant Aslak Thomas esq 603228 603228 Aslak, Thomas, of Sprouston, esq 0
5302870 2445845 2445845 defendant Cokke William husbandman 603228 603228 Cokke, William, of Sprouston, husbandman 4
5323203 2452021 2452021 defendant Harveys or Herneys John chaplain 603228 603228 Harveys or Herneys, John, of Sprouston, chaplain 1
5323686 2452170 2452170 defendant Waryns William   603228 603228 Waryns, William, of Sprouston, wosted weaver 0
5323687 2452170 2452170 defendant Waryns Simon   603228 603228 Waryns, Simon, of Sprouston, wosted weaver 1
5350169 2460174 2460174 defendant Garbot Lawrence husbandman 603228 603228 Garbot, Lawrence, of Sprouston, husbandman 0
5350171 2460174 2460174 defendant Garbot William husbandman 603228 603228 Garbot, William, of Sprouston, husbandman 2
5351966 2460719 2460719 defendant Erle Lawrence husbandman 603228 603228 Erle, Lawrence, of Sprouston, husbandman 0
5527343 2513132 2513132 defendant Erle John   603228 603228 Erle, John, of Sprouston, shepherd 1
5601790 2535461 2535461 defendant Arnold Roger husbandman 603228 603228 Arnold, Roger, of Sprouston, husbandman 2
5601827 2535473 2535473 defendant Arnold Roger husbandman 603228 603228 Arnold, Roger, of Sprouston, husbandman 0
5626473 2552251 2552251 defendant Cobbe William husbandman 603228 603228 Cobbe, William, of Sprouston, husbandman 1
5626475 2552251 2552251 defendant Smyth John husbandman 603228 603228 Smyth, John, of Sprouston, husbandman 3

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