names

64 rows where place_id = 624981

✎ 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
3761420 1945585 1945585 defendant Bodwell William tailor 624981 624981 Bodwell, William, of Mulberton, tailor 1
3769966 1948262 1948262 defendant Runale John smith 624981 624981 Runale, John, of Mulberton, smith 4
3841438 1970901 1970901 defendant Hyx Henry husbandman 624981 624981 Hyx, Henry, of Mulberton, husbandman 2
3849747 1973509 1973509 defendant Fornefyld Robert laborer 624981 624981 Fornefyld, Robert, of Mulberton, laborer 1
3856998 1975822 1975822 defendant Bryggis William husbandman 624981 624981 Bryggis, William, of Mulberton, husbandman 1
3863408 1977956 1977956 defendant Chauncy Henry gent 624981 624981 Chauncy, Henry, of Mulberton, gent 0
3899584 1990080 1990080 defendant Warde John husbandman 624981 624981 Warde, John, of Mulberton, husbandman 1
3899585 1990080 1990080 defendant Belward Robert husbandman 624981 624981 Belward, Robert, of Mulberton, husbandman 2
3899586 1990080 1990080 defendant Dennes Nicholas husbandman 624981 624981 Dennes, Nicholas, of Mulberton, husbandman, husbandman 3
3923009 1998002 1998002 plaintiff Sewall William   624981 624981 Sewall, William, of Mulberton 0
4045197 2040738 2040738 plaintiff Rudlond Thomas husbandman 624981 624981 Rudlond, Thomas, of Mulberton, husbandman 0
4075386 2051501 2051501 defendant Barker William husbandman 624981 624981 Barker, William, of Mulberton, husbandman 2
4075394 2051504 2051504 defendant Rychardson William clerk 624981 624981 Rychardson, William, of Mulberton, clerk 0
4079981 2053143 2053143 defendant Rudlonde Thomas yeoman 624981 624981 Rudlonde, Thomas, of Mulberton, yeoman 0
4083985 2054550 2054550 defendant Cuddon Francis gent 624981 624981 Cuddon, Francis, of Mulberton, gent 0
4143997 2076063 2076063 defendant Barbor William weaver 624981 624981 Barbor, William, of Mulberton, weaver 3
4164471 2083092 2083092 defendant Cuddon Francis gent 624981 624981 Cuddon, Francis, of Mulberton, gent 0
4195404 2093938 2093938 defendant Cuddon Francis gent 624981 624981 Cuddon, Francis, of Mulberton, gent 2
4223703 2103776 2103776 defendant Nunne Robert gent 624981 624981 Nunne, Robert, of Mulberton, gent 2
4223708 2103777 2103777 defendant Nunne Robert gent 624981 624981 Nunne, Robert, of Mulberton, gent 2
4288129 2125804 2125804 defendant Bushopp William yeoman 624981 624981 Bushopp, William, of Mulberton, gent, or of Swafylde, yeoman 0
4388770 2160876 2160876 defendant Pytcher Robert yeoman 624981 624981 Pytcher, Robert, of Mulberton, yeoman 2
4394391 2162723 2162723 defendant Edward William yeoman 624981 624981 Edward, William, of Mulberton, yeoman 2
4401619 2165137 2165137 defendant Richardson William clerk 624981 624981 Richardson, William, of Mulberton, clerk 2
4407372 2167027 2167027 defendant Richardson Richard gent 624981 624981 Richardson, Richard, of Mulberton, or of Furnivals Inn, Middx, gent 1
4580279 2225313 2225313 defendant Brakle John   624981 624981 Brakle, John, of Mulberton 3
4654258 2247213 2247213 defendant Douny or Donny Robert yeoman 624981 624981 Douny or Donny, Robert, of Mulberton, yeoman 0
4673338 2257299 2257299 defendant Herdyng Thomas tanner 624981 624981 Herdyng, Thomas, of Mulberton, tanner 0
4736386 2276510 2276510 defendant Morle Thomas   624981 624981 Morle, Thomas, of Mulberton 0
4819128 2302059 2302059 defendant Pentynggale John husbandman 624981 624981 Pentynggale, John, of Mulberton, husbandman 2
4831220 2305794 2305794 defendant Belstede Thomas yeoman 624981 624981 Belstede, Thomas, of Mulberton, yeoman 2
4850696 2311673 2311673 defendant Dounham John yeoman 624981 624981 Dounham, John, of Mulberton, yeoman 2
4863802 2315652 2315652 defendant Edrych Walter gent 624981 624981 Edrych, Walter, of Mulberton, gent 1
4865277 2316112 2316112 defendant Dowenyng John husbandman 624981 624981 Dowenyng, John, of Mulberton, husbandman 1
4901160 2326979 2326979 defendant Belsted Thomas husbandman 624981 624981 Belsted, Thomas, of Mulberton, husbandman 4
4908249 2329131 2329131 defendant Curteys Stephen husbandman 624981 624981 Curteys, Stephen, of Mulberton, husbandman 2
4918912 2332430 2332430 defendant Ederych Walter yeoman 624981 624981 Ederych, Walter, of Mulberton, yeoman 0
4919460 2332590 2332590 defendant James John husbandman 624981 624981 James, John, of Mulberton, husbandman 2
4949852 2341940 2341940 defendant Belsted John chapman 624981 624981 Belsted, John, of Mulberton, chapman 4
4975795 2349726 2349726 defendant Belsted Robert husbandman 624981 624981 Belsted, Robert, of Mulberton, husbandman 4
4992431 2354620 2354620 defendant Edriche Walter husbandman 624981 624981 Edriche, Walter, of Mulberton, husbandman 4
4994116 2355114 2355114 defendant Kent Robert husbandman 624981 624981 Kent, Robert, of Mulberton, husbandman 1
4994536 2355231 2355231 defendant Bukston Robert husbandman 624981 624981 Bukston, Robert, of Mulberton, husbandman 0
5008120 2359260 2359260 defendant Ederych Walter yeoman 624981 624981 Ederych, Walter, of Mulberton, yeoman 0
5019167 2362495 2362495 defendant Edryche Walter husbandman 624981 624981 Edryche, Walter, of Mulberton, husbandman 2
5023635 2363822 2363822 defendant Ederyche Walter husbandman 624981 624981 Ederyche, Walter, of Mulberton, husbandman 5
5173977 2408087 2408087 defendant Broun Thomas husbandman 624981 624981 Broun, Thomas, of Mulberton, husbandman 2
5194247 2414049 2414049 defendant Broun Thomas husbandman 624981 624981 Broun, Thomas, of Mulberton, husbandman 2
5240333 2427386 2427386 defendant Ederych Walter husbandman 624981 624981 Ederych, Walter, of Mulberton, husbandman 0
5286040 2440927 2440927 defendant Belstede Robert husbandman 624981 624981 Belstede, Robert, of Mulberton, husbandman 5
5312528 2448784 2448784 defendant Petynggale John husbandman 624981 624981 Petynggale, John, of Mulberton, husbandman 2
5313245 2448998 2448998 defendant Petyngale John husbandman 624981 624981 Petyngale, John, of Mulberton, husbandman 0
5314327 2449303 2449303 defendant Petynggale John husbandman or yeoman 624981 624981 Petynggale, John, of Mulberton, husbandman or yeoman 0
5315905 2449833 2449833 defendant Belsted Robert yeoman 624981 624981 Belsted, Robert, of Mulberton, yeoman 2
5320384 2451182 2451182 defendant Berd Thomas husbandman or yeoman 624981 624981 Berd, Thomas, of Mulberton, husbandman or yeoman 0
5338035 2456463 2456463 defendant Petyngale John husbandman 624981 624981 Petyngale, John, of Mulberton, husbandman 0
5369849 2466160 2466160 defendant Petynghale John husandman 624981 624981 Petynghale, John, of Mulberton, husandman 3
5369856 2466161 2466161 defendant Petynghale John husandman 624981 624981 Petynghale, John, of Mulberton, husandman 3
5394920 2473619 2473619 defendant Seffrey William husbandman 624981 624981 Seffrey, William, of Mulberton, husbandman 0
5453938 2491068 2491068 defendant Seffrey William husbandman 624981 624981 Seffrey, William, of Mulberton, husbandman 0
5453941 2491069 2491069 defendant Seffrey William husbandman 624981 624981 Seffrey, William, of Mulberton, husbandman 0
5588419 2531382 2531382 defendant Bay William laborer 624981 624981 Bay, William, of Mulberton, laborer 3
5599153 2534616 2534616 defendant Belward John husbandman 624981 624981 Belward, John, of Mulberton, husbandman 1
5632644 2554232 2554232 defendant Belsted Thomas yeoman 624981 624981 Belsted, Thomas, of Mulberton, yeoman 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);