names

50 rows where place_id = 606211

✎ 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
3664452 1914829 1914829 defendant Gardyner Richard yeoman 606211 606211 Gardyner, Richard, of St Mary Cray, yeoman 0
3664453 1914829 1914829 defendant Bocher William yeoman 606211 606211 Bocher, William, of St Mary Cray, yeoman 1
3664454 1914829 1914829 defendant Bukley William clerk 606211 606211 Bukley, William, of St Mary Cray, clerk 2
3673852 1917854 1917854 defendant Stake Henry weaver 606211 606211 Stake, Henry, of St Mary Cray, weaver 0
3674383 1918034 1918034 defendant Gardyner Richard   606211 606211 Gardyner, Richard, of St Mary Cray, "pouller" 0
3700369 1926353 1926353 defendant Staple John yeoman 606211 606211 Staple, John, of St Mary Cray, yeoman 0
3700370 1926353 1926353 defendant Maygate George laborer 606211 606211 Maygate, George, of St Mary Cray, laborer 1
3700371 1926353 1926353 defendant Staple Thomas laborer 606211 606211 Staple, Thomas, of St Mary Cray, laborer 2
3700372 1926353 1926353 defendant Johnson Henry shoemaker 606211 606211 Johnson, Henry, of St Mary Cray, shoemaker 3
3759302 1944897 1944897 defendant Gardener Richard pulter 606211 606211 Gardener, Richard, of St Mary Cray, pulter 1
3777332 1950654 1950654 defendant Bagthwayte John (legal representative) 606211 606211 Bagthwayte, John, of St Mary Cray or of London, vintner, executor of 0
3777335 1950655 1950655 defendant Bagthwayte John (legal representative) 606211 606211 Bagthwayte, John, of St Mary Cray or of London, vintner, executor of 0
3787219 1953796 1953796 defendant Eyer Thomas husbandman 606211 606211 Eyer, Thomas, of St Mary Cray, husbandman 0
3827016 1966303 1966303 defendant Hawsey William tanner 606211 606211 Hawsey, William, of St Mary Cray, tanner 4
3834832 1968833 1968833 defendant Gardyner Richard husbandman 606211 606211 Gardyner, Richard, of St Mary Cray, husbandman 2
4404677 2166132 2166132 defendant Kettle Jane widow 606211 606211 Kettle, Jane, of St Mary Cray, widow 0
4488655 2197174 2197174 defendant Forster Nicholas   606211 606211 Forster, Nicholas, of St Mary Cray 0
4514407 2204924 2204924 defendant Clerk Robert   606211 606211 Clerk, Robert, of St Mary Cray 0
4530065 2209692 2209692 defendant Jolyf John cooper 606211 606211 Jolyf, John, of St Mary Cray, cooper 1
4570085 2222218 2222218 defendant Dryver John   606211 606211 Dryver, John, of St Mary Cray 0
4577573 2224493 2224493 defendant Byfeld Thomas   606211 606211 Byfeld, Thomas, of St Mary Cray 0
4578640 2224807 2224807 defendant Byfeld Thomas   606211 606211 Byfeld, Thomas, of St Mary Cray 0
4589275 2228024 2228024 defendant Dorkyng Thomas   606211 606211 Dorkyng, Thomas, of St Mary Cray 2
4627656 2239580 2239580 defendant Jolyf John   606211 606211 Jolyf, John, of St Mary Cray 0
4668911 2255979 2255979 defendant Houprest William mealman 606211 606211 Houprest, William, of St Mary Cray, mealman 0
4681765 2259908 2259908 defendant Munde John fletcher 606211 606211 Munde, John, of St Mary Cray, fletcher 1
4691670 2262928 2262928 defendant Hardell John husbandman 606211 606211 Hardell, John, of St Mary Cray, husbandman 1
4699751 2265366 2265366 defendant Hardell John yeoman 606211 606211 Hardell, John, of St Mary Cray, yeoman 0
4700046 2265435 2265435 defendant Hardell John yeoman 606211 606211 Hardell, John, of St Mary Cray, yeoman 0
4732060 2275208 2275208 defendant Howeprest William husbandman 606211 606211 Howeprest, William, of St Mary Cray, husbandman 0
4732305 2275281 2275281 plaintiff Pakenham Thomas   606211 606211 Pakenham, Thomas, of St Mary Cray 0
4747149 2279671 2279671 defendant Hoprest William husbandman 606211 606211 Hoprest, William, of St Mary Cray, husbandman 1
4846124 2310294 2310294 defendant Douners John laborer 606211 606211 Douners, John, of St Mary Cray, laborer 0
4920539 2332935 2332935 defendant Lefe Thomas husbandman 606211 606211 Lefe, Thomas, of St Mary Cray, husbandman 1
4925732 2334482 2334482 defendant atte Lees Thomas husbandman 606211 606211 atte Lees, Thomas, of St Mary Cray, husbandman 0
4978635 2350558 2350558 defendant Moger John husbandman 606211 606211 Moger, John, of St Mary Cray, husbandman 0
5005639 2358548 2358548 defendant Moger John husbandman 606211 606211 Moger, John, of St Mary Cray, husbandman 0
5010402 2359910 2359910 plaintiff Maister Robert   606211 606211 Maister, Robert, of St Mary Cray 1
5061037 2374875 2374875 defendant Dorant William butcher 606211 606211 Dorant, William, of St Mary Cray, butcher 1
5133767 2396368 2396368 defendant Stode Alexander yeoman 606211 606211 Stode, Alexander, of St Mary Cray, yeoman 0
5330543 2454224 2454224 defendant Moger Robert husbandman 606211 606211 Moger, Robert, of St Mary Cray, husbandman 0
5340629 2457272 2457272 defendant Kene or Dene Thomas yeoman 606211 606211 Kene or Dene, Thomas, of St Mary Cray, yeoman 1
5347708 2459436 2459436 defendant Adene Joan widow 606211 606211 Adene, Joan, of St Mary Cray, widow 3
5394165 2473391 2473391 defendant Strodyll John husbandman 606211 606211 Strodyll, John, of St Mary Cray, husbandman 3
5436837 2485947 2485947 defendant Blak Richard yeoman 606211 606211 Blak, Richard, of St Mary Cray, yeoman 0
5445534 2488561 2488561 defendant Notte John husbandman 606211 606211 Notte, John, of St Mary Cray, husbandman 0
5451431 2490302 2490302 defendant Blak Richard   606211 606211 Blak, Richard, of St Mary Cray 0
5564049 2524100 2524100 defendant Lane Thomas miller 606211 606211 Lane, Thomas, of St Mary Cray, miller 0
5599372 2534689 2534689 defendant Watson Richard laborer 606211 606211 Watson, Richard, of St Mary Cray, laborer 0
5599373 2534689 2534689 defendant Moger Thomas tailor 606211 606211 Moger, Thomas, of St Mary Cray, tailor 1

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