names

56 rows where place_id = 755595

✎ 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
4429494 2174024 2174024 plaintiff Walter John   755595 755595 Walter, John, of Algerkirk 0
4445593 2183574 2183574 defendant Honnyng John   755595 755595 Honnyng, John, of Algerkirk 0
4464601 2189597 2189597 defendant Martyn John tailor 755595 755595 Martyn, John, of Algerkirk, tailor 2
4467660 2190563 2190563 defendant Abraham Nicholas   755595 755595 Abraham, Nicholas, of Algerkirk 0
4468356 2190768 2190768 defendant Toly Thomas tailor 755595 755595 Toly, Thomas, of Algerkirk, tailor 0
4489664 2197485 2197485 plaintiff Toup Thomas   755595 755595 Toup, Thomas, of Algerkirk 0
4501986 2201218 2201218 defendant Dalby Robert   755595 755595 Dalby, Robert, of Algerkirk 4
4508321 2203090 2203090 defendant Saunderson William   755595 755595 Saunderson, William, of Algerkirk 0
4508322 2203091 2203091 plaintiff Abraham Nicholas   755595 755595 Abraham, Nicholas, of Algerkirk 0
4526628 2208606 2208606 plaintiff Langdam Richard   755595 755595 Langdam, Richard, of Algerkirk 0
4526629 2208606 2208606 plaintiff Bradenham Richard   755595 755595 Bradenham, Richard, of Algerkirk 1
4533422 2210722 2210722 defendant Toup John   755595 755595 Toup, John, of Algerkirk 0
4544467 2214181 2214181 defendant Dyconson John   755595 755595 Dyconson, John, of Algerkirk 0
4544468 2214181 2214181 defendant Pantre Richard   755595 755595 Pantre, Richard, of Algerkirk 1
4559462 2218908 2218908 plaintiff Ponercroft Richard   755595 755595 (Ponercroft, Richard, of Algerkirk 1
4561855 2219641 2219641 defendant Smyth Walter   755595 755595 Smyth, Walter, of Algerkirk 1
4564068 2220333 2220333 defendant Toup John   755595 755595 Toup, John, of Algerkirk 0
4567883 2221528 2221528 defendant Ketill John   755595 755595 Ketill, John, of Algerkirk 0
4619951 2237221 2237221 defendant Catson John   755595 755595 Catson, John, of Algerkirk 0
4666938 2255389 2255389 defendant Dunham John de   755595 755595 Dunham, John de, of Algerkirk, wright 2
4666942 2255390 2255390 defendant Pantre Richard husbandman 755595 755595 Pantre, Richard, of Algerkirk, husbandman 1
4666943 2255390 2255390 defendant Bette John tailor 755595 755595 Bette, John, of Algerkirk, tailor 2
4666945 2255390 2255390 defendant Hungate John carpenter 755595 755595 Hungate, John, of Algerkirk, carpenter 4
4666946 2255390 2255390 defendant Milner Andrew weaver 755595 755595 Milner, Andrew, of Algerkirk, weaver 5
4679279 2259128 2259128 defendant Pantre Alan husbandman 755595 755595 Pantre, Alan, of Algerkirk, husbandman 0
4712570 2269250 2269250 plaintiff Smyth Robert   755595 755595 Smyth, Robert, of Algerkirk 0
4712571 2269250 2269250 defendant Sybelson John husbandman 755595 755595 Sybelson, John, of Algerkirk, husbandman 0
4715286 2270113 2270113 defendant Toure Katherine widow 755595 755595 Toure, Katherine, of Algerkirk, widow 2
4717371 2270769 2270769 defendant Hardgate John miller 755595 755595 Hardgate, John, of Algerkirk, miller 0
4721885 2272177 2272177 defendant Pulvertoft John gent 755595 755595 Pulvertoft, John, of Algerkirk, gent 2
4726149 2273465 2273465 defendant Gildento Robert husbandman 755595 755595 Gildento, Robert, of Algerkirk, husbandman 1
4727695 2273904 2273904 defendant Gildento Robert husbandman 755595 755595 Gildento, Robert, of Algerkirk, husbandman 0
4741139 2277914 2277914 plaintiff Betson John   755595 755595 Betson, John, of Algerkirk, son of Hugh 0
4763574 2284593 2284593 defendant Gildento Robert husbandman 755595 755595 Gildento, Robert, of Algerkirk, husbandman 0
4776332 2288591 2288591 defendant Polvertoft Roger husbandman 755595 755595 Polvertoft, Roger, of Algerkirk, husbandman 0
4846659 2310464 2310464 defendant Brunham John gent 755595 755595 Brunham, John, of Algerkirk, gent 0
4879489 2320513 2320513 defendant Lundon Thomas husbandman 755595 755595 Lundon, Thomas, of Algerkirk, husbandman 6
4879490 2320513 2320513 defendant Marabull John husbandman 755595 755595 Marabull, John, of Algerkirk, husbandman 7
4881176 2321020 2321020 defendant Garard Roger husbandman 755595 755595 Garard, Roger, of Algerkirk, husbandman 1
4881177 2321020 2321020 defendant Warner William husbandman 755595 755595 Warner, William, of Algerkirk, husbandman 2
4909992 2329652 2329652 defendant Burnham John husbandman 755595 755595 Burnham, John, of Algerkirk, husbandman 2
4913304 2330660 2330660 defendant London Thomas husbandman 755595 755595 London, Thomas, of Algerkirk, husbandman 4
4940687 2339116 2339116 defendant Edelyn William husbandman 755595 755595 Edelyn, William, of Algerkirk, husbandman 6
4947578 2341236 2341236 defendant Broun John husbandman 755595 755595 Broun, John, of Algerkirk, husbandman 0
4956168 2343806 2343806 defendant Thomson John husbandman 755595 755595 Thomson, John, of Algerkirk, husbandman 0
4962279 2345619 2345619 defendant London Thomas husbandman 755595 755595 London, Thomas, of Algerkirk, husbandman 0
5068846 2377181 2377181 defendant London Thomas husbandman 755595 755595 London, Thomas, of Algerkirk, husbandman 1
5124195 2393535 2393535 defendant Tomson John husbandman 755595 755595 Tomson, John, of Algerkirk, husbandman 0
5124196 2393535 2393535 defendant G- Thomas husbandman 755595 755595 G- Thomas, of Algerkirk, husbandman 1
5124201 2393536 2393536 defendant Tomson John husbandman 755595 755595 Tomson, John, of Algerkirk, husbandman 0
5183184 2410822 2410822 defendant Hummyng Thomas husbandman 755595 755595 Hummyng, Thomas, of Algerkirk, husbandman 0
5300944 2445235 2445235 defendant Hummyng Hugh (legal representative) 755595 755595 Hummyng, Hugh, of Algerkirk, executors of 0
5300945 2445235 2445235 defendant Bayly John husbandman 755595 755595 (Bayly, John, of Algerkirk, husbandman 1
5612315 2547600 2547600 plaintiff Campion Robert   755595 755595 Campion, Robert, of Algerkirk 0
5634904 2554909 2554909 plaintiff Pulvertoft John   755595 755595 Pulvertoft, John, of Algerkirk 1
5635412 2555040 2555040 defendant Trumpette John, senior yeoman 755595 755595 Trumpette, John, senior, of Algerkirk, 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);