names

106 rows where place_id = 603084

✎ 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
3653005 1911270 1911270 defendant Melyn Michael yeoman 603084 603084 Melyn, Michael, of Romesey, yeoman 1
3729291 1935412 1935412 defendant Ylbert Thomas butcher 603084 603084 Ylbert, Thomas, of Romesey, butcher 0
3947395 2006164 2006164 plaintiff Cockerell John innholder 603084 603084 Cockerell, John, of Romesey, innholder 0
3947396 2006164 2006164 plaintiff Harvy Richard vintner 603084 603084 Harvy, Richard, of Romesey, vintner 1
4064758 2047680 2047680 defendant Williams William shoemaker 603084 603084 Williams, William, of Romesey, shoemaker 0
4074113 2051037 2051037 plaintiff Pulley William yeoman 603084 603084 Pulley, William, of Romesey, yeoman 0
4187943 2091283 2091283 defendant Gauntlett John clothier 603084 603084 Gauntlett, John, of Romesey, clothier 1
4200148 2095605 2095605 defendant Dowse George gent 603084 603084 Dowse, George, of Romesey, gent 0
4374366 2155899 2155899 defendant Blose or Bloyse John yeoman 603084 603084 Blose or Bloyse, John, of Romesey, yeoman 0
4374367 2155899 2155899 defendant Barnerd John butcher 603084 603084 Barnerd, John, of Romesey, butcher 1
4413169 2168990 2168990 defendant atte Grome Richard   603084 603084 atte Grome, Richard, of Romesey 0
4443717 2183004 2183004 plaintiff Chapman Ralph   603084 603084 Chapman, Ralph, of Romesey 0
4444845 2183361 2183361 plaintiff Cook John   603084 603084 Cook, John, of Romesey 0
4460630 2188383 2188383 plaintiff Skynnere Nicholas   603084 603084 Skynnere, Nicholas, of Romesey 0
4471015 2191589 2191589 defendant Huwet John   603084 603084 Huwet, John, of Romesey 0
4481858 2195032 2195032 defendant Fisshere John   603084 603084 Fisshere, John, of Romesey 1
4489102 2197309 2197309 defendant Tybbe John clerk 603084 603084 with Tybbe, John, of Romesey, clerk 1
4489103 2197309 2197309 defendant Abyndone John clerk 603084 603084 Abyndone, John, of Romesey, clerk 2
4489104 2197309 2197309 defendant Bannyng Edmund   603084 603084 Bannyng, Edmund, of Romesey 3
4494201 2198876 2198876 defendant Caldeburgh Hugh tanner 603084 603084 Caldeburgh, Hugh, of Romesey, tanner 0
4495202 2199183 2199183 defendant Phielp John skinner 603084 603084 Phielp, John, of Romesey, skinner 0
4515153 2205154 2205154 defendant Bocher David   603084 603084 Bocher, David, of Romesey 0
4530812 2209926 2209926 defendant Chapman Ralph   603084 603084 Chapman, Ralph, of Romesey 0
4535233 2211284 2211284 defendant Pipere Richard   603084 603084 Pipere, Richard, of Romesey, lock smith 1
4537765 2212088 2212088 defendant Couper John   603084 603084 Couper, John, of Romesey 0
4563488 2220153 2220153 plaintiff Robyns Henry   603084 603084 Robyns, Henry, of Romesey 0
4570137 2222231 2222231 defendant Broun Hugh chaplain 603084 603084 Broun, Hugh, of Romesey, chaplain 0
4570138 2222231 2222231 defendant Carpetner Hugh   603084 603084 Carpetner, Hugh, of Romesey 1
4575537 2223856 2223856 defendant Teukesbury William shoemaker 603084 603084 Teukesbury, William, of Romesey, shoemaker 1
4587064 2227363 2227363 plaintiff Horn Thomas   603084 603084 Horn, Thomas, of Romesey 0
4593854 2229353 2229353 defendant Tomas Henry tanner 603084 603084 Tomas, Henry, of Romesey, tanner 0
4597497 2230462 2230462 defendant Smyth John   603084 603084 Smyth, John, of Romesey 0
4602766 2232081 2232081 plaintiff Whelere Richard   603084 603084 Whelere, Richard, of Romesey 0
4602767 2232081 2232081 defendant Shethere Robert   603084 603084 Shethere, Robert, of Romesey 0
4603823 2232377 2232377 defendant Whyte William   603084 603084 Whyte, William, of Romesey 0
4603825 2232378 2232378 plaintiff Wyght Alice   603084 603084 Wyght, Alice, of Romesey 0
4603827 2232378 2232378 defendant Whyte William   603084 603084 Whyte, William, of Romesey 1
4603828 2232379 2232379 plaintiff Wyght Alice   603084 603084 Wyght, Alice, of Romesey 0
4603830 2232379 2232379 defendant Whyte William   603084 603084 together with Whyte, William, of Romesey 1
4603893 2232397 2232397 defendant Staunton John   603084 603084 Staunton, John, of Romesey 0
4628747 2239917 2239917 defendant Styward John   603084 603084 Styward, John, of Romesey 0
4649937 2246000 2246000 plaintiff Waryn William   603084 603084 Waryn, William, of Romesey 0
4658048 2248394 2248394 plaintiff Cook Hugh carpenter 603084 603084 Cook, Hugh, of Romesey, carpenter 0
4658049 2248394 2248394 defendant Touker Nicholas fuller 603084 603084 Touker, Nicholas, of Romesey, fuller 0
4660706 2249171 2249171 defendant Skynner Richard skinner 603084 603084 Skynner, Richard, of Romesey, skinner 0
4665747 2250762 2250762 plaintiff Horn Thomas, senior   603084 603084 Horn, Thomas, senior, of Romesey 0
4665748 2250762 2250762 defendant Frank Edith widow of John Clerk alias Couk 603084 603084 Frank, Edith, of Romesey, widow of John Clerk alias Couk 0
4675540 2257960 2257960 defendant Kirkeby John gent 603084 603084 Kirkeby, John, of Romesey, gent 0
4677180 2258480 2258480 plaintiff Halle Joan   603084 603084 Halle, Joan, of Romesey 0
4682057 2260006 2260006 defendant Doumere Richard husbandman 603084 603084 Doumere, Richard, of Romesey, husbandman 0
4685634 2261098 2261098 defendant Chamberlayne John husbandman 603084 603084 Chamberlayne, John, of Romesey, husbandman 0
4701981 2266028 2266028 defendant Cobyn John husbandman 603084 603084 Cobyn, John, of Romesey, husbandman 1
4701982 2266028 2266028 defendant Person John dyer 603084 603084 Person, John, of Romesey, dyer 2
4704022 2266638 2266638 defendant Person John dyer 603084 603084 Person, John, of Romesey, dyer 0
4706082 2267278 2267278 defendant atte Hall Joan   603084 603084 atte Hall, Joan, of Romesey, widow, formerly wife of John 1
4718123 2271008 2271008 defendant Person John dyer 603084 603084 Person, John, of Romesey, dyer 0
4726090 2273447 2273447 defendant Person John dyer 603084 603084 Person, John, of Romesey, dyer 1
4726576 2273587 2273587 defendant Prest John husbandman 603084 603084 Prest, John, of Romesey, husbandman 1
4726618 2273597 2273597 defendant Prest John husbandman 603084 603084 Prest, John, of Romesey, husbandman 1
4726620 2273598 2273598 defendant Prest Robert husbandman 603084 603084 Prest, Robert, of Romesey, husbandman 0
4727983 2273998 2273998 defendant Person John dyer 603084 603084 Person, John, of Romesey, dyer 0
4743021 2278475 2278475 defendant Fairle John tanner 603084 603084 Fairle, John, of Romesey, tanner 0
4751863 2281039 2281039 plaintiff Steward John baker 603084 603084 Steward, John, of Romesey, baker 0
4755288 2282041 2282041 defendant Grenefeld John yeoman 603084 603084 Grenefeld, John, of Romesey, yeoman 1
4755290 2282042 2282042 defendant Levenoth John (legal representative) 603084 603084 Levenoth, John, of Romesey, butcher, executrix of 0
4755690 2282163 2282163 defendant Touker atte Middel Brigge William fuller 603084 603084 Touker atte Middel Brigge, William, of Romesey, fuller 0
4755692 2282163 2282163 defendant Baron Thomas fuller 603084 603084 Baron, Thomas, of Romesey, fuller 2
4797314 2295332 2295332 defendant Feraunt John smith 603084 603084 Feraunt, John, of Romesey, smith 1
4816217 2301157 2301157 plaintiff Lovell Matilda   603084 603084 Lovell, Matilda, of Romesey, abbess 0
4831800 2305965 2305965 defendant Scherman Elizabeth widow 603084 603084 Scherman, Elizabeth, of Romesey, widow 2
4851657 2311953 2311953 defendant Guarre John   603084 603084 Guarre, John, of Romesey, bailiff 0
4881182 2321021 2321021 defendant Kyng Richard husbandman 603084 603084 Kyng, Richard, of Romesey, husbandman 2
4881183 2321021 2321021 defendant Artur John smith 603084 603084 Artur, John, of Romesey, smith 3
4889611 2323550 2323550 defendant Jompeney Thomas sawyer 603084 603084 Jompeney, Thomas, of Romesey, sawyer 0
4892155 2324289 2324289 defendant Hardyng John tucker 603084 603084 Hardyng, John, of Romesey, tucker 0
4901060 2326957 2326957 defendant Huse John fuller 603084 603084 Huse, John, of Romesey, fuller 0
4901062 2326957 2326957 defendant White Thomas tanner 603084 603084 White, Thomas, of Romesey, tanner 2
4926120 2334596 2334596 defendant Kymbrygge Richard carpneter 603084 603084 Kymbrygge, Richard, of Romesey, carpneter 0
4942124 2339520 2339520 defendant Whitston William dyer 603084 603084 Whitston, William, of Romesey, dyer 0
5005463 2358499 2358499 defendant Kent John clerk 603084 603084 Kent, John, of Romesey, clerk 0
5008844 2359478 2359478 defendant Catell John   603084 603084 Catell, John, of Romesey, wheel wright 0
5011794 2360300 2360300 defendant Mody John   603084 603084 Mody, John, of Romesey, shoe maker 1
5022714 2363554 2363554 defendant Fayrle John tanner 603084 603084 Fayrle, John, of Romesey, tanner 0
5023004 2363638 2363638 defendant Bocher John butcher 603084 603084 Bocher, John, of Romesey, butcher 1
5025978 2364493 2364493 defendant Bolde John tanner 603084 603084 Bolde, John, of Romesey, tanner 0
5025979 2364493 2364493 defendant Frenche Thomas tanner 603084 603084 Frenche, Thomas, of Romesey, tanner 1
5025980 2364493 2364493 defendant Hill Richard tapener or weaver 603084 603084 Hill, Richard, of Romesey, tapener or weaver 2
5030109 2365678 2365678 plaintiff Payn John merchant 603084 603084 Payn, John, of Romesey, merchant 0
5030115 2365679 2365679 plaintiff Payn John merchant 603084 603084 Payn, John, of Romesey, merchant 0
5044015 2369837 2369837 defendant Fayrle John tanner 603084 603084 Fayrle, John, of Romesey, tanner 0
5056185 2373423 2373423 defendant Senyer William husbandman 603084 603084 Senyer, William, of Romesey, husbandman 1
5056186 2373423 2373423 defendant Burnham Thomas chandler 603084 603084 Burnham, Thomas, of Romesey, chandler 2
5088454 2382998 2382998 defendant Roll John fuller 603084 603084 Roll, John, of Romesey, fuller 0
5232626 2425122 2425122 defendant Hulle John fuller 603084 603084 (Hulle, John, of Romesey, fuller 1
5232627 2425122 2425122 defendant Florens John   603084 603084 Florens, John, of Romesey husbandman 2
5258606 2432814 2432814 defendant Algar William miller 603084 603084 Algar, William, of Romesey, miller 0
5269034 2436044 2436044 defendant Gaterygge Robert butcher 603084 603084 Gaterygge, Robert, of Romesey, butcher 1
5314132 2449242 2449242 defendant Gaterygge John butcher 603084 603084 Gaterygge, John, of Romesey, butcher 0
5410242 2478015 2478015 plaintiff Broke Elizabeth   603084 603084 Broke, Elizabeth, of Romesey, abbess of the house & church of the BM 0
5534460 2515322 2515322 defendant Rey John merchant 603084 603084 Rey, John, of Romesey, merchant 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);