names

89 rows where place_id = 700599

✎ 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
3922824 1997936 1997936 defendant Williamson Christopher butcher 700599 700599 Williamson, Christopher, of Est Rasen, butcher 2
4134229 2072565 2072565 defendant Butler William laborer 700599 700599 Butler, William, of East Rasen, laborer 3
4427968 2173589 2173589 defendant Baker John   700599 700599 Baker, John, of East Rasen 0
4438759 2181415 2181415 defendant Kempe John   700599 700599 Kempe, John, of East Rasen 0
4446262 2183744 2183744 defendant Fole Hugh   700599 700599 Fole, Hugh, of East Rasen 0
4452417 2185750 2185750 defendant Pulter John   700599 700599 Pulter, John, of East Rasen 0
4453478 2186093 2186093 plaintiff Leen William tailor 700599 700599 Leen, William, of East Rasen, tailor 0
4464694 2189625 2189625 defendant Pulter John   700599 700599 Pulter, John, of East Rasen 0
4493921 2198795 2198795 plaintiff Benyngworth John de   700599 700599 Benyngworth, John de, of East Rasen 0
4495299 2199207 2199207 defendant Ryby Robert   700599 700599 Ryby, Robert, of East Rasen 0
4500530 2200786 2200786 plaintiff Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4500532 2200786 2200786 defendant Sampton John   700599 700599 Sampton, John, of East Rasen 1
4500534 2200787 2200787 plaintiff Jammeson John   700599 700599 Jammeson, John, of East Rasen 0
4505083 2202122 2202122 plaintiff Skayll John   700599 700599 Skayll, John, of East Rasen 0
4510208 2203675 2203675 plaintiff Barbour Robert   700599 700599 Barbour, Robert, of East Rasen 0
4514651 2205001 2205001 defendant Ryby Robert   700599 700599 Ryby, Robert, of East Rasen 0
4515735 2205348 2205348 plaintiff Clerk Simon   700599 700599 Clerk, Simon, of East Rasen 0
4524199 2207902 2207902 defendant Bonet Thomas   700599 700599 Bonet, Thomas, of East Rasen, vicar 0
4524220 2207909 2207909 defendant Bonet Thomas   700599 700599 Bonet, Thomas, of East Rasen, vicar 0
4524702 2208064 2208064 plaintiff Hosyer William   700599 700599 Hosyer, William, of East Rasen 0
4524706 2208065 2208065 plaintiff Hosyer William   700599 700599 Hosyer, William, of East Rasen 0
4525463 2208297 2208297 plaintiff Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4525467 2208298 2208298 plaintiff Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4534739 2211145 2211145 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4540832 2213037 2213037 defendant Scampton John glover 700599 700599 Scampton, John, of East Rasen, glover 3
4546524 2214844 2214844 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4559740 2219000 2219000 defendant Ke_ Richard miller 700599 700599 Ke_, Richard, of East Rasen, miller 1
4560397 2219190 2219190 defendant Pulter John   700599 700599 Pulter, John, of East Rasen 1
4561842 2219639 2219639 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4569769 2222124 2222124 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 3
4569998 2222187 2222187 plaintiff Wiche John   700599 700599 Wiche, John, of East Rasen 0
4569999 2222187 2222187 defendant Milner Richard   700599 700599 Milner, Richard, of East Rasen 0
4570000 2222188 2222188 plaintiff Wiche John   700599 700599 Wiche, John, of East Rasen 0
4570001 2222188 2222188 defendant Milner Richard   700599 700599 Milner, Richard, of East Rasen 0
4571085 2222524 2222524 defendant Daukyn wiliam   700599 700599 Daukyn, wiliam, of East Rasen 0
4579981 2225227 2225227 defendant Bonet Thomas   700599 700599 Bonet, Thomas, of East Rasen, vicar 0
4592060 2228872 2228872 defendant Naton John   700599 700599 Naton, John, of East Rasen 0
4599550 2231075 2231075 defendant Hosyer William   700599 700599 Hosyer, William, of East Rasen 0
4606140 2233032 2233032 plaintiff Auke Richard   700599 700599 Auke, Richard, of East Rasen 0
4606141 2233032 2233032 defendant Benyngworth John tailor 700599 700599 Benyngworth, John, of East Rasen, tailor 0
4610781 2234443 2234443 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4618611 2236830 2236830 defendant Benyngworth John   700599 700599 Benyngworth, John, of East Rasen 0
4622747 2238091 2238091 defendant Jamesson John   700599 700599 Jamesson, John, of East Rasen 0
4628501 2239835 2239835 plaintiff Scayle John   700599 700599 Scayle, John, of East Rasen 0
4636369 2242210 2242210 defendant Kelsey Robert   700599 700599 Kelsey, Robert, of East Rasen 3
4644406 2244455 2244455 defendant Barnard Nicholas   700599 700599 Barnard, Nicholas, of East Rasen 0
4657112 2248118 2248118 defendant Crosby John   700599 700599 Crosby, John, of Est Rasen 4
4659418 2248806 2248806 defendant Jamesson John husbandman 700599 700599 Jamesson, John, of Est Rasen, husbandman 0
4665418 2250660 2250660 defendant Croyser John smith 700599 700599 Croyser, John, of Est Rasen, smith 0
4681486 2259824 2259824 defendant Arcale Thomas spicer 700599 700599 Arcale, Thomas, of East Rasen, spicer 3
4727011 2273714 2273714 defendant Anke or Auke John butcher 700599 700599 Anke or Auke, John, of East Rasen, butcher 0
4727012 2273714 2273714 defendant Anke or Auke William tailor 700599 700599 Anke or Auke, William, of East Rasen, tailor 1
4727013 2273714 2273714 defendant Lytster John clerk 700599 700599 Lytster, John, of East Rasen, clerk 2
4738255 2277057 2277057 defendant Polume William husbandman 700599 700599 Polume, William, of East Rasen, husbandman 0
4746820 2279571 2279571 plaintiff Hosear William   700599 700599 Hosear, William, of East Rasen 0
4755092 2281977 2281977 defendant Richardson John   700599 700599 Richardson, John, of East Rasen 0
4814544 2300659 2300659 plaintiff Jamesson Willim   700599 700599 Jamesson, Willim, of East Rasen 0
4814545 2300659 2300659 defendant Kelsay John chapman 700599 700599 Kelsay, John, of East Rasen, chapman 0
4838689 2308025 2308025 defendant Jameson William merchant 700599 700599 Jameson, William, of East Rasen, merchant 0
4838690 2308025 2308025 defendant Stu_pell John chapman 700599 700599 Stu_pell, John, of East Rasen, chapman 1
4850165 2311515 2311515 defendant Sotherne William butcher 700599 700599 Sotherne, William, of East Rasen, butcher 0
4859597 2314371 2314371 defendant Jamesson William chapman 700599 700599 Jamesson, William, of Est Rasen, chapman 0
4865921 2316313 2316313 defendant Jamesson William chapman 700599 700599 Jamesson, William, of Est Rasen, chapman 0
4872743 2318426 2318426 defendant Kynyerby Thomas chapman 700599 700599 Kynyerby, Thomas, of Est Rasen, chapman 0
4916063 2331524 2331524 defendant Chesterfeld John husbandman 700599 700599 Chesterfeld, John, of East Rasen, husbandman 0
5017357 2361966 2361966 defendant Anke or Auke William tailor 700599 700599 Anke or Auke, William, of Est Rasen, tailor 0
5022707 2363551 2363551 defendant Jamesson William, senior   700599 700599 Jamesson, William, senior, of Est Rasen 1
5022710 2363552 2363552 defendant Jamesson William, senior   700599 700599 Jamesson, William, senior, of Est Rasen 1
5076923 2379593 2379593 defendant Boner or Bouer John shoemaker 700599 700599 Boner or Bouer, John, of Est Rasen, shoemaker 0
5076924 2379593 2379593 defendant Bardell Richard miller 700599 700599 Bardell, Richard, of Est Rasen, miller 1
5076925 2379593 2379593 defendant Hoby John   700599 700599 Hoby, John, of Est Rasen, wright 2
5076926 2379593 2379593 defendant Everyngham Thomas glover 700599 700599 Everyngham, Thomas, of Est Rasen, glover 3
5152182 2401777 2401777 defendant Cade Thomas butcher 700599 700599 Cade, Thomas, of East Rasen, butcher 0
5152183 2401777 2401777 defendant Dace John butcher 700599 700599 Dace, John, of East Rasen, butcher 1
5170078 2406981 2406981 defendant Cade Thomas butcher 700599 700599 Cade, Thomas, of East Rasen, butcher 0
5170079 2406981 2406981 defendant Cade John butcher 700599 700599 Cade, John, of East Rasen, butcher 1
5187416 2412045 2412045 defendant Cade Thomas butcher 700599 700599 Cade, Thomas, of East Rasen, butcher 0
5187417 2412045 2412045 defendant Cade John butcher 700599 700599 Cade, John, of East Rasen, butcher 1
5219266 2421360 2421360 defendant Bele Thomas yeoman 700599 700599 Bele, Thomas, of Est Rasen, yeoman 3
5258284 2432710 2432710 defendant Jameson William merchant 700599 700599 Jameson, William, of Est Rasen, merchant 0
5278391 2438787 2438787 plaintiff Bell Henry clerk 700599 700599 Bell, Henry, of Est Rasen, clerk 0
5293542 2443080 2443080 defendant Jameson William merchant 700599 700599 Jameson, William, of Est Rasen, merchant 0
5346779 2459151 2459151 defendant Hadilsey Richard butcher 700599 700599 Hadilsey, Richard, of Est Rasen, butcher 0
5376533 2468256 2468256 defendant Chapman John yeoman 700599 700599 Chapman, John, of East Rasen, yeoman 0
5376535 2468257 2468257 defendant Chapman John yeoman 700599 700599 Chapman, John, of East Rasen, yeoman 0
5479120 2498780 2498780 defendant Est John tailor 700599 700599 Est, John, of Est Rasen, tailor 0
5479121 2498780 2498780 defendant Kent William tailor 700599 700599 Kent, William, of Est Rasen, tailor 1
5490112 2501925 2501925 plaintiff Beel William merchant of the staple 700599 700599 Beel, William, of Est Rasen, merchant of the staple 0
5624303 2551546 2551546 defendant Boston John merchant 700599 700599 Boston, John, of Est Rasen, merchant 5

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